cancel
Showing results for 
Search instead for 
Did you mean: 
Workflow Hero

Calculated field with lookup does not update on edit

Hi,

 

I have a form which calculates discount based on certain criteria. the form is as below

 

 

While adding a new record the discount gets calculated without any issues. But when the saved record is opened for editing, the column initially brings up the value for a few seconds and then turns blank as shown below.

 

 

The formula used for fetching the discount is

lookup("PriceListMultiplier","ColumnForLookup",FmlHiddenCoulmnForItem,"Multi")

The PriceListMultiplier List is as below with index on ColumnForLookup.

 

Please could you advise on why this unexpected behavior is happening and a possible solution.

 

Thanks

Labels: (1)
0 Kudos
Reply
8 Replies
Workflow Hero

Re: Calculated field with lookup does not update on edit

Hi,


Is Recalculate formula on Edit Mode set to "Yes"?

Accept as Solution Reply
Workflow Hero

Re: Calculated field with lookup does not update on edit

yes it is, since this is in repeated section

Get Outlook for iOS

Accept as Solution Reply
Workflow Hero

Re: Calculated field with lookup does not update on edit

Can you send me the form please?

Accept as Solution Reply
Workflow Hero

Re: Calculated field with lookup does not update on edit

I am a armature, Please explain in detail, should I download the from and send it or is there  another way

Accept as Solution Reply
Workflow Hero

Re: Calculated field with lookup does not update on edit

Yes download and send on my email 

Accept as Solution Reply
Workflow Hero

Re: Calculated field with lookup does not update on edit

try enclose FmlHiddenCoulmnForItem with apostrophees (or even better with {textStart}{TextEnd}) as well.

minus sign might be interpreted as arithmetic operation and so cause problems.

Accept as Solution Reply
Workflow Hero

Re: Calculated field with lookup does not update on edit

Thanks, I tried Giving the formula as advised but the result is negative.  lookup("PriceListMultiplier","ColumnForLookup",{TextStart}FmlHiddenCoulmnForItem{TextEnd},"Multi"). As specified earlier while creating a new record the calculation is correct but while I try to edit a saved record the calculation fails What I had observed is that while opening on edit mode the value appears for a split second and the field recalculates and produces blank. I did try to set the recalculate on edit to No. but this also did not help. My feeling is that the recalculation happens before the concatenated string is generated and if a delay can be given to the recalculation it should work. Please advise If my assumption is right, if so how will I create a delay before the field recalculation.

Accept as Solution Reply
Workflow Hero

Re: Calculated field with lookup does not update on edit

that was my next question to ask - do you have recalculate on edit set for FmlHiddenCoulmnForItem as well?

if so, check developer console for any errors reported.

Accept as Solution Reply