the date data suddenly changes, does not match the data on the google sheet

[beckymargajaya]

after edit data in google apps form, my data date suddenly change in my view. 1 Aug 2023 change to 8 jan 2023.

 i check data in google sheet is no problem.

is this bug? or must always sync before editing?

this is big problem for me, because if user forget to sync, editing form get data from view, not from google sheet, if user not careful and save the form, the wrong date saved to google sheet. please help me.

sorry if my english is bad.

[AleksiAlkio]

It sounds your locale settings don't match between the app's table definitions and gSheet's settings.

[beckymargajaya]

thanks for your respon sir.

can you tell me how to setting locale apps table?

[AleksiAlkio]

Through table settings.. 

[beckymargajaya]

update sir,

my locale is same beetween appsheet and google sheet

[AleksiAlkio]

Have you checked all tables from your app?

[beckymargajaya]

my app using two table, and all table have the same local settings.

[AleksiAlkio]

When you are adding a new record, and I assume you have the initial value set with TODAY(), does the date work just fine with all devices?

[beckymargajaya]

yes sir, that work just fine.

[beckymargajaya]

1. this is my data in the begining:

2. now, i try to add new record by clicking add button.

today() function is working fine here.

3. now i want to save this data:

everything is normal here, data automaticaly show withtout sinc and without any errors.

4. then I click the status button to check my data status.

everything work fine, from here I need update my data by clicking "BELUM FOTO EPOXY" button.

everything is good, and I click that table to edit the data.

edit form opened with valid data.

I just change field "Foto Epoxy" here, and save the data

everything normal, there is no data with False value in the field.

the I go back to check "case open" menu to view all data.

look what is happening???

my date data suddenly changed.

then I check to my gSheets, everything is normal.

this is dangerous for me, because if user not sync, and click that data to editing, the edit form will opened with invalid data. (check the date value) 

and if user not careful then click save button, the wrong data saved to gSheets.

I hope there is solution for this.

[AleksiAlkio]

One of your printscreens shows "Sync to complete" which means that you have a sheet formula in your gSheet the app is waiting to complete with the sync.What that formula is doing? Is it there by mistake?

[beckymargajaya · Accepted solution]

that is the problem, user must always sync before editing. should I remove all data validation on my gSheet? my gsheet have formula to calculate aging (DAYS function).

I will try to remove that formula first. thank you sir.

[AleksiAlkio]

Yes, that's a normal behavior. When you save (write) something with the app, first it writes the data, then it calculates all sheet formulas, and then it syncs that data to user's device. If you don't sync at least on the background, the calculation is not shown properly.

It would be better to calculate those numbers with app formulas.