Multiple Language Survey

HI @jyothis_m

Yes, I ended up doing the same as you do now in your new example with the enum list.
I added all languages like this:

SWITCH([LANGUAGE],
“Česky”,“Referenční číslo”,
“Dansk”,“Reference nummer”,
“Deutsch”,“Referenznummer”,
“Eestikeelne”,“Viitenumber”,
“English”,“Reference number
bla bla bla
bla bla bla”)

Maybe later I will do it same way as you do now :slightly_smiling_face:

But I have another question if okay?

Let me explain:
Before when I was using Google Form, each time someone submitted the form, the date and time was always added to Google Sheet. Even if the form had been open for like 2-3 hours, it still added the date and time from the moment the ‘Save’ button was clicked.

At first in the Appsheet, I had a column with ‘Date/time’ set with Now(), but this Date/time was registered when the form was opened. Therefore, if the form had been open for 2-3 hours because no customers used the tablet, the timestamp was also 2-3 hours behind.

Right now, I have added a Behavior that inserts the date/time Now(), and added that behavior to the Save-form button.

It works as intended. But from here I have some weird things happening sometimes.

In the UX - Primary view, I am using this: 'Finish View = sheetname_Form"

  • 8 out 10 times it re-opens the form again as it should do, ready for a new submission after hitting the save button. But why not 10 out of 10? I dont get it? And also, when it does not re-open the form, it just shows an empty screen with the ‘Form’ at the bottom which you can click to open the Form, but even worse, when this happens with the blank screen, the date/time is not inserted into google sheet.
    I dont get it. I cannot figure out what is causing this. There is no pattern.

I need to have the exact date/time registration when someone hits the Save button.
What is the best way to do that?

If the method I am using right now, with the behavior adding date/time when Save button is clicked is not working 100% of the time, I need to do something else :confused:

I have been thinking about doing something like this:
Removing the behavior action from the save button again, and somehow, after each form has been submitted, then just show a picture and a button ala ‘Open form’ and then use the timestamp from when the ‘Open form’ was clicked. But how can I do that? Will I have to add a new table in google sheet, insert a picture, and then create a new View pointing to that sheet when ever the Save button is clicked?
Yes, I know, if someone clicks the ‘Open Form’ without doing more and leaves the tablet, the next customer will get the wrong timestamp.

Soo… aaaaaah.. Frustrated :grinning_face_with_smiling_eyes:
How can I make 1000% sure always to have the timestamp exactly when the form is submitted?

all the best