DETAIL VIEW - APP SYNC - FORM VIEW

AppSheet AppSheet Q&A
, , , , , ,
1

Hi friends,

I have faced an issue. I have used a formula for a column (Primary Table) which pulls the value from another table (secondary) by using select() function. when the secondary table is updated (an entry is made), even after syncing the formula doesn’t pulls or displays the value of the secondary tables column in detail view. but at detailed view’s edit option (form view) , values are visible and while clicking the save button , at detail view the fields or columns are displayed.

jaichith_1-1688932758280.png
jaichith_1-1688932758280.png417×509 28.8 KB

jaichith_2-1688932846077.png
jaichith_2-1688932846077.png642×610 31.3 KB

After saving or click next…

jaichith_3-1688932925496.png
jaichith_3-1688932925496.png677×658 41.9 KB

Pls help me to solve this.

I want the fields or column values in detail view without clicking save or click next. FYI : there is no error in formula expression.

@dbaum , @AleksiAlkio @Marc_Dillon @Suvrutt_Gurjar

2

Please, read this post:

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/How-to-Refresh-Data-without-clicking-Edit-Save/m-p/277798#M56556

3

Do you know any other method which does updating automatically when app syncs …

WHAT TO DO IF WE HAVE MULTIPLE TABLES. ?

4

Könnte sein, dass dieses Erklär-Video ab der 9. Min. ihre Lösung sein kann: Viele-zu-Viele-Beziehungen aufbauen

5

As it’s a result of a normal column, that’s a normal behavior. You need to use either a virtual column or calculate it with a “execute an action on a set of rows” action.