Why phone numbers not attaching to Sheets/Zapier?

  • jasoniinergy
    Asked on July 18, 2019 at 10:18 PM

    Hi guys,


    We have set up an email notification for when a prospect fills out our form, but the phone number isn't carrying across in our zapier integration, and it's not filling out in the google sheet. As you can see in the zap, the 'Phone' step is reading as "No Data" within the zap, yet within the field selection, a number is displayed (I have tested this multiple times and it's definitely the correct field). The same goes for the spreadsheet.

    This is the most crucial step in our form and I don't understand why it's not working - Our form is embedded in a ClickFunnel, everything else is carrying across, and the changes I have made in the form are reflected within the funnel, so it's not a synchronization issue; Can we please get this fixed?

    I've included the physical form URL below, in addition here is the URL for the funnel the form is embedded into - www.whatshappenings.net

    Jotform Thread 1896562 Screenshot
  • jherwin
    Replied on July 18, 2019 at 11:43 PM

    Try using the short-text entry field as your phone field and set a mask input, please refer to the guide below.

    Guide: Getting-Started-with-the-Basics-of-Input-Masking

    Please give it a try and let us know if the issue persists.

  • jherwin
    Replied on July 18, 2019 at 11:49 PM

    In addition to my answer, I tried to integrate one of my forms with phone field into the google spreadsheet and the phone values ​​were passed to the sheet successfully.
    1563508067sheet Screenshot 10
    Please try re-integrating your form on a google sheet and see if the issue persists. Please note that re-integration of the spreadsheet form will create a new spreadsheet file.

    Guide: How-to-Integrate-Forms-with-Google-Sheets

    Perhaps, your form is integrated into google spreadsheet through Zapier as well?