A field is not sent to Google Sheet

  • Koos
    Asked on December 20, 2020 at 12:17 AM

    Hi team.

    Our form 'dealer order form' has a field named Dhc73 which data we need populated in the Gsheet. What could.be the reason that it's not showing?

    You can find my form "Dealer Order Form" at: https://form.jotform.com/203114185480044

    Thanks for the help.

  • Ariel JotForm Support
    Replied on December 20, 2020 at 1:40 AM

    Hi,

    Thank you for reaching out to us.

    I've cloned your form, but can't seem to find the field labeled "Dhc73".

    16084463752020 12 20 14 36 40 Screenshot 10

    Can you send us screenshots of the field you're referring to?

    Also, try redoing the integration, see if the issue persists.

    Should you have any further inquiries, we will be more than happy to help.

    Related Guides:

  • koosvis
    Replied on December 21, 2020 at 2:14 PM

    Good day.

    Here is a picture and a video: https://drive.google.com/uc?id=11ONGEo5LGqx_X24LZg30ksjJE7thKHHn

    Looking forward to the fix

    K.


    1608577767 5fe0f2e7c28e4 Tutorial 3130   Screenshot 10

  • Elton Support Team Lead
    Replied on December 21, 2020 at 3:55 PM

    Thanks for explaining it on the video, we appreciate it. I cloned your form and integrate it with Google Spreadsheet without making any modification in the form and it's working fine. The shipping value is passed into the integrated spreadsheet.

    12222020 dEbJ0DWPq1 Screenshot 10

    12222020 6oLyJmIBtH Screenshot 21

    Here's my cloned form: https://form.jotform.com/203556537237964

    Sheet: https://docs.google.com/spreadsheets/d/184wkB1ouRGDux4KAnSMO0DhPfJw4EAVB0gZLxaRpT5E/edit?usp=sharing

    Feel free to test my cloned form by submitting it then check the sheet.

    I suggest you re-integrate your form with Google Spreadsheet, this would probably fix it.

    Aside from that, the reason why the shipping value isn't shown on the preview page is that it is listed as a field to be hidden on the preview. You can check this in the widget settings.

    12222020 qw7gGqvUh0 Screenshot 32