A field is not sent to Google Sheet

  • Profile Image
    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.

  • Profile Image
    Ariel_P
    Answered on December 20, 2020 at 01: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.jpg

    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:

  • Profile Image
    koosvis
    Answered on December 21, 2020 at 02: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 -

  • Profile Image
    EltonCris
    Answered on December 21, 2020 at 03: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.png

    12222020_6oLyJmIBtH.png

    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.png