Issues on sending submissions to Google sheet

[C_NZ]

• Goal: <!----send the form submissions to a Google sheet->

• Steps:

• Details: <!---I tried multiple ways to write the code, but failed to append the data to the sheet and it kept showing me the same error message "column "0" not found. expected column name to be....">
  

  

• Screenshots:

• App json export:

[Paulo]

Hi @C_NZ, welcome to the forum!

It looks like we just need to update the values for each key under 'Values to append.' We need to reference the value of the component using {{ }} syntax.

For example:

If the name of the Text input component is textInput1, we should set the value of the key NAME to {{ textInput1.value }}

Success:

[C_NZ]

Hi, Paulo
Thank you so much for your reply and help, I got it.

C_NZ

[Paulo]

Awesome! You're welcome.

[C_NZ]

Hi, Paulo,
I encountered another issue today, the "submit" button is not working correctly: when I click the "run", the code works correctly, and I submit the content to the destination sheet; however, when I click the button "submit", it is not working and only submit the "time" to the sheet. same issue to the app on the phone, the submit button not working. I set the "control query" for the "event handler" for the button component. Do you know where is my issue?

[Paulo]

• Could you share a screenshot with the event handler? It's missing from the first screenshot.
• Do we get any error in the console? Open the debug console located at the bottom right of the UI and share any errors.