Behaviour/action to update column values - only updates 1st expression

AppSheet AppSheet Q&A
1

Hi,

I have 2 columns that I update on a new entry from values in virtual columns. The values to be passed are working correctly; however, only 1 of the expressions updates correctly when I save the entry.

mosyah72_0-1678360854551.png
mosyah72_0-1678360854551.png836×397 30 KB

Which ever expression is listed at the top is updated correctly, the other returns zero. If i swap their positions then the other column updates with the correct value.

The behaviour is triggered when the form is saved.

I’m only new to Appsheets is there something I’m missing? Is it reading the 1st expression then exiting?

2

No they should both update. Since they seem to work if they are the first you can assume the formula is correct. Check for any required_if or Editable_if formulas within [fuel_kmperlitre] and [fuel_km] as a starting point.

3

Thanks for you reply… No, I can’t see any of *_if you’ve mentioned.

4

Why would you base a value setting action on virtual column?! You should actually get rid of the virtual columns and put their formulas directly in the action.

1 Like