The column's name is correct but it pulled out the wrong data

Please see the attached image.

The column's name is correct but it is pulling the wrong date from different column on our MFG RMA form.

Please fix it.

Hi Shania,

Thanks for reaching out to Jotform Support. Let me help you with that:

If the column's name is correct but it is pulling data from the wrong column in your MFG RMA form, this issue may be related to how the data is mapped or displayed in Jotform Tables.

Here’s how to address this:

1. Check the form field labels and data: Ensure that the form fields in your MFG RMA form are correctly labeled and that the data entered corresponds to the correct fields.
2. Verify the column mapping in Jotform Tables: The column headings in Jotform Tables represent the labels of the fields on the connected form. If the data appears incorrect, double-check that the column is indeed linked to the correct form field.
3. Rename the column if needed: You can rename columns in Jotform Tables for clarity without affecting the form fields. To do this, double-click on the column name, type the desired name, and press Enter to save. This can help avoid confusion but does not change the data source.

If the problem persists, it may require reviewing the form setup or data integration to ensure the correct data is pulled into the right columns.

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

how to Verify the column mapping in Jotform Tables

Hi Shania,

To verify the column mapping in Jotform Tables and ensure the correct data is pulled from your form fields, you can reset the table columns to their default view. This will synchronize the columns with the original form field labels and order from the Form Builder.

Here’s how to do it:

1. Open Jotform Tables and go to the table for your MFG RMA form.
2. Click on the Three Dots icon next to the tab name of the table you want to reset.
3. Select Reset columns to default from the menu.
4. Confirm by clicking the Reset to default button in the confirmation modal.

This action will revert all columns to their original position and name as set in the Form Builder, ensuring the data matches the correct fields.

Note that shared users do not have access to this option, and this reset only affects the active tab.

There is no Select Reset columns to default from the menu

Hi Shania,

If you do not see the option to "Reset columns to default" in the menu, it may be because you are a shared user or the feature is not available in your current view. This option is only accessible to the form owner or users with full access rights.

As an alternative, you can manually verify the column mapping by comparing the column names in Jotform Tables with the field labels in your Form Builder. Make sure each column corresponds to the correct form field.

If columns have been renamed or reordered, you can manually rename or move them back to match the form fields for clarity.

If the issue continues, reviewing the form setup or data integration might be necessary to ensure data is pulled correctly.

Hi Shania,

I checked the form and found that it is under a different account. Can you confirm if you are a collaborator of the Table? Also, the screenshot didn’t show up for me. Can you try uploading it again? Let me show you how to post a screenshot to our Help Center:

1. On the Help Center page, scroll down to the Your Answer section and click on the Image icon.

2. Drag and drop your image into the Upload box, or click on it and select your file.

3. Then, click on the Add button in the bottom-right corner of the window.

4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

Once we hear back from you, we'll be able to help you with this.