Field with app formula doesn't update automatically but others do

Hello!

I'm having an issue with an app I am creating where one of the formulas (that uses data from other tables) is not updating when the tables with the source data are edited. The odd thing is that I use a very similar formula in another table and that formula is working and updating fine.

Here's a photo of the formula that's working correctly

orsinij_0-1719329853125.png

And here's a photo of the Add/Update settings for that table

orsinij_1-1719329896573.png

This is a photo of the formula I am having issues with. When I go in to the Authorized Users sheet and set Forest Funds? to Yes it does not re-calculate the formula to get the value of System Approved. However, if I go into the table that contains this formula and edit it the formula will update and provide the correct response. I would just like it to automatically sync like the other one if possible.

orsinij_2-1719330040516.png

And here's the update settings for the table (I added the All_Changes hoping that would let the formula update fields)

orsinij_3-1719330115820.png

The only other thing different about the 2 tables that I can think of is that most of the columns in the problem table have this formula for Editable_If as there is 1 column I want users to be able to update and the rest I don't want users to update. 

orsinij_4-1719330292859.png

I found a post where someone was having a similar issue and the solution there was to turn off Delta Sync. Delta Sync is already turned off on my app so I'm not sure how to fix this issue. Any suggestions would be very much appreciated

0 2 476
2 REPLIES 2

Copy exactly your formula in a new virtual column.

Virtual column will be recalculated automatically for each Sync. Remember that formulas in normal columns require a data change to be recalculated.

 

Take a look for the next appsheet documentation:

App Formulas 

 

Hello! 

They are both in Virtual Columns. I tried copying the equation into a new virtual column but the same issue occurs.

Top Labels in this Space