Hello! I have an app that uses SELECT() function to take values from one table to sum them in another table. The expression itself works fine, no mistakes. But the calculated result doesn’t update automatically unless I edit. When I press edit, then I see the updated expression result. What am I doing wrong or how cant it be fixed.
You have created that formula in a normal column. The app formula will recalculate it only when you open & save that record… or when you are creating a new record. Create a virtual coumn with the same app formula. Virtual columns are recalculated every time you sync the app.