Zeroes in questions asking for numbers entered as empty values (Airtable integration)

  • Curran_Joseph
    Asked on August 21, 2019 at 7:22 AM

    Hi, I am integrating jotforms with airtable and when zeroes are entered they show up as empty values on airtable. Do you know any ways I can fix this so that they appear as numbers?

  • jherwin
    Replied on August 21, 2019 at 8:56 AM

    You're right. If the value of the field is zero (0) it is appearing as blank in Airtable Integration. Can you please try creating a formula in your Airtable? 

    Please check this related article: https://community.airtable.com/t/test-for-empty-but-not-empty-if-zero/19628

  • Curran_Joseph
    Replied on August 21, 2019 at 10:26 AM

    Unfortunately because each of the questions are number fields in order to integrate it with Jotform, I am unable to add a formula. I created a formula in a different field as per the link, but it did not work for my context.  

  • jherwin
    Replied on August 21, 2019 at 11:55 AM

    The zero value is sent to the spreadsheet/submission/notification so I think you need to contact Airtable support regarding this.

    https://support.airtable.com/

    Please try to contact them and let us know what their input regarding this issue.

  • Curran_Joseph
    Replied on August 22, 2019 at 3:31 AM

    Will do. Thanks