Expression result appears in the virtual column but not in the normal column

AppSheet AppSheet Q&A
,
1

Please help me find the solution to this Appsheet formula problem I am facing.

I’ve two columns with the same expression:
IF([AM]=“”,“”,IF([AM]=“Over”,TOTALHOURS([Work From]-[Clock In]),IF([Execuse AM Value]>TOTALHOURS([Clock In]-[Work From]),“”,(TOTALHOURS([Clock In]-[Work From])-[Execuse AM Value]))))

one of the columns is normal from the spreadsheet and the other one is virtual

The problem here is
when I test the expression in each column i have a correct result in the expression result and the virtual column but I have 0 in the normal column

3X_7_e_7e0868691fa0b4d1034e1db07d04ade6d71b4adb.png
3X_7_e_7e0868691fa0b4d1034e1db07d04ade6d71b4adb.png1402×582 46.8 KB

Note that

  • I make my changes throw the form
  • I don’t need that virtual column in my project because I need to save data in the spreadsheet
1 Like
2

Khaled_Ibrahim:

Please help me find the solution to this Appsheet formula problem I am facing.

  1. Check the column definition to make sure there are no settings that would cause rounding or truncation to occur.

  2. For your normal column, is the expression in the App Formula property? If it is in Initial Value, it is only executed when the row is first added and never again.

  3. Have you checked the sheet for actual value saved there?

  4. When you state:

Khaled_Ibrahim:

I make my changes throw the form

…are you making the changes in the same Form for the row where the column “AM Late/Over” exists and is the column included? For example, if the Form operates on a Slice but the slice does not include the column, the App Formula will not fire for that column.

1 Like
3

Thanks for replay
the two columns have the same definition

3X_c_c_ccbb64cffaa37a7422db18a6f2a73efcf2930f8b.png
3X_c_c_ccbb64cffaa37a7422db18a6f2a73efcf2930f8b.png589×1262 50 KB

the sheet save the 0 value as resulted in the normal column

  • yes I make the changes in the same row … result changes every time in the virtual column but stays 0 in the normal one
4

Hmm, I am wondering if you might be impacted by a known issue where the server computes differently than the client/UI side of things. Virtual Columns are computed on the server while your “normal” columns’ App Formula will be computed on the client/UI side.

AppSheet introduced a feature where the server and client use “consistent” computation methods. Check the setting shown in the image below. If it is not already set to “Consistent”, change the setting and try again to see if that fixes it.

3X_c_3_c317d6d6f12455380d8a637020b153e0042eb0a6.png
3X_c_3_c317d6d6f12455380d8a637020b153e0042eb0a6.png1834×566 42.9 KB

5

It’s already as shown in your image … I didn’t make any change to this setting

1 Like
6

I’m out of options. I would recommend reaching out to support.

https://www.appsheet.com/Support/Contact

Maybe one last ditch effort is to re-write the expression. I think using the IFS() function is more appropriate than nested IF’s.

1 Like
7

Thanks for you

8

Mr. @Steve could you help me, please

9

Find an existing row with a blank value in the real column with the App formula, open that row in a form view, make no changes in the form, then click Save. Does the real column with the App formula get a value?

10

I would also check the settings of that column in spreadsheet, and also test the formula in initial value

1 Like
11

No, it didn’t make any change

1 Like
12

I can’t make the formula in the initial value, my app is changeable continuously

13

I recommend you engage Support for further help with this. Someone there can look directly at your app configuration and troubleshoot.

https://www.appsheet.com/Support/Contact

1 Like