Mobile multiple form components append to gsheets

I'm using retool mobile which uses several form components (e.g date picker, select & text input) along with a button which triggers a query that appends data from the above components to a gsheet. The problem is that it appends each component in a new row but I want one new row with all the component values per button press. Any suggestions on how to do this?
Thanks in advance!

Hey Phil, this query seems to do the trick for me. Here my columns in the sheet are named "column1", "column2", etc; just replace those strings with your column names. Let me know if you have any questions.

Thanks, that worked! I was close but had "{{datePicker1.value}}" etc instead of just {{datePicker1.value}}.

1 Like