Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Hi - New to Zapier. 

I have used zapier for Jotform and Excel integration. All Jotform submissions are recording nicely into the excel spreadsheet. Each new one appearing on a separate row.

However, the Submission ID field is not integrating properly in the excel sheet .Originally it shows up in the field as 5.46872E+18. I’ve amended the formatting for that column to allow for numbers etc and then it shows majority of the Jotform submission ID however makes the last 4 digits as zeros, when there are actual numbers in the orginal jotform submission ID. For example, the Jotform ID may be 5468729065987856 and when it integrates into excel via zapier, the number is 5468729065980000.

I’ve tried amending the excel column to a number, general, text etc and even added a ‘ to the beginning and it doesn’t work.

There are only two ‘ID’ fields to choose from in Jotform to integrate into excel. One is ‘ID’ and the other is ‘Form ID’. I have tried both and the ‘ID’ field is the only one that at least has some of the correct numbers in it when it transfers over. 

Can anyone suggest how to fix this??

Hi @RistaKCS 

Good question.

I’d recommend using Airtable instead of Excel.

Airtable has Field types. (e.g. Single Text)

Hi @RistaKCS!

I’m sorry that you’re having trouble getting Excel to keep the format that you set. Looking at the format in Excel would definitely be my first shout, and I can see that you’ve already tried that. Just to confirm the settings that you need, you’ll need to select the whole column where the ID is going (not just one cell) and choose Text for the format (not number or general). Could you give that one more try to check that the settings don’t stick?

Let us know how you get on!

Just wondering if this issue was ever resolved? I’m having the same issue at the moment and it’s very frustrating 😤

Hi all, 

The issue seems to be related to Excel’s Number format. When the format is not compatible with Jotform Submission ID, it gets only a portion of the Submission ID. If the actual ID was 5468729065987856, Excel records only a part of the ID: 546872906598. So even after the cell format is changed, the original data cannot be extracted. Excel displays the number as 5468729065980000.

But if the column type is set before the zap runs to something that may hold the Submission ID like “text”, the Submission ID can be viewed without any problem. 

Bests,

 

 

Terms & Conditions