About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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.

Question

The Jotform Submission ID field is not integrating properly in the Excel sheet

  • 15 December 2022
  • 4 replies
  • 91 views
R

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??

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @RistaKCS 

Good question.

I’d recommend using Airtable instead of Excel.

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

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Danvers
Userlevel 7
Badge +12

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!

J

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

uugurlu

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