Can I change the arrangement of the table column without affecting the form field

I have a form that I wanted to have people download a report for through one of the links. And one of the project stakeholders asked if we could change the order those fields appear on the report but not the form. I know I can go to the submission sheet and adjust the order, but not all of the people using the form have access to a Jotform account which is why we use the reporting link. Is there a way to change the order on that?

Hi Hayes,

Thanks for reaching out to Jotform Support. I just wanted to confirm if I understand your concern correctly. Do you mean to change the arrangement of the Column without affecting the form field? Yes, adding fields or columns on the Submissions table gives the ability to process data which will not affect the functionality of the form. You can check our Jotform Tables FAQ.

You can import data to an existing Google Sheets using our Google Sheets Integration. Then, advice them to make a copy of it, after that they can change the column arrangement. Let me show you how to set that up:

First, let's connect your Google account to the form:

1. In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. Click on Integrations on the left side of the screen and select the Google Sheets integration.
3. Now, click on the Downward Arrow icon and select or connect your Google account.

Then, let's set up the integration settings:

1. Click on Use an Existing Spreadsheet.
2. Click on Select in the Spreadsheet Name section, and choose your Google Spreadsheet, and click on the Select button at the bottom left corner of the window.
3. Select the fields that you want to send to Google Sheets, and then click on Save. That's it. 

Once you set up everything, whenever your form gets a submission, your Google Spreadsheet will also be updated. Check out my screencast to see how it'll work:

Let us know if you need any more help.

That is great, but is there a way to have that data arranged how I have it in the submissions for example on this form https://form.jotform.com/242625831488161 I have the submissions ordered in a specific way to meet the teams needs but when I use the google sheets integration it does not pull in that order.

Additionally your Jotform Tables FAQ leads to a 404.

Hi Hayes,

When I cloned and tested your form, everything worked the way it was supposed to. Take a look at the screenshot below to see my results:

If the data on your Google Sheet is not arranged in order based on your form submission, you can redo the integration in Jotform to fix it. Here's a guide on How to Integrate Forms With Google Sheets and Jotform Tables Help Guide that you can check out.

Let us know if there’s anything else we can help you with.

Hi Christine!

I was also able to get the submissions to pull into google sheets the issue is I cannot change the order in which the form fields appear. If you look at the submissions for that form I have them ordered differently (so Girl name first, then caregiver name, etc.) and in the screenshot that you sent the form fields are not pulling in that order. Is there a way to pull the form fields in the order they are in on the submissions tab, or can they only be in the order they appear on the form?

Hi Hayes,

You can rearrange the column. You need to do it in your Google Sheets. Ensure that you have integrated your Google Sheet 1st. Let me show you how:

1. Open your Google Sheets.
2. Then you can move the column by dragging it.

Please note below:

• Changes in your Google Sheets spreadsheet don’t affect your Jotform form entries.
• Renaming column headings in Google Sheets may break the integration. You can redo the integration in Jotform to fix it.
• Adding filters in Google Sheets may stop your spreadsheet from updating. Reapply the filters in Google Sheets to see the updates.
• Inline edits in Tables won’t update entries in Google Sheets, unlike entry edits.

Give it a try and let us know how it goes.