Share
ReportHi everyone!
I've an app linked to an excel file, the goal of the app is to complete a survey of 900 fields (100 questions with 9 columns). I've tried to use a gallery with 9 boxes which update the Excel file live with a patch. In OnChange properties I have the following formula:
Patch(Tabla1;ThisItem;{'Customer satisfaction':TextInput1_1.Text})
This is working, but the app runs too slow as it is updating instantly the content in my file (which makes the app almost impossible as is necessary to fill 900 fields).
I want to have a way to save all the answers of my survey and then update the file at once, avoiding the app going slow, Can anyone help me with that? Thanks in advance.
Attached is a photo of the survey to clarify the layout I'm using for it.
All responses (
Answers (
356
