Set The Question Order with Google Sheet Integration

  • Profile Image
    Asked on January 13, 2022 at 09:40 AM

    Is it possible to specify which order the form questions are imported to Google Sheets?

    For example, I have a Jotform with five questions. By default, when connect to Google Sheets the import will go like this:

    Question 1 - Column A
    Question 2 - Column B
    Question 3 - Column C
    Question 4 - Column D
    Question 5 - Column E

    Is there something in Jotform that will allow me to change this order. Say I want 'Question 2' to appear in Column E instead.

    I know I can manually move the column in Google Sheets after connecting it but I'm constantly cloning forms and want to avoid having to do that if possible. It would be better if I can simply configure the order within Jotform itself. Maybe be editing the FIELD IDS?



  • Profile Image
    Answered on January 13, 2022 at 10:12 AM

    Hi Adam, unfortunately there is no option to change the column order of the Google Sheet in the integration.

    We also do not recommend making changes in the spreadsheet columns.

    This is one of the reasons why the spreadsheet stops updating or their values may be interchanged.

    If you have further questions, let us know.