AirTable Integration: show a value when the submission is edited

#2.  Can you please add a variable that I can pass to airtable which lets me know if a submission is an edit?  Again, there are workarounds, using zapier, but they are not very reliable, and they require a very complicated script which has to search an entire airtable record and delay itself 10 minutes just to work.

To clarify, do you want to include the edit link in your Airtable integration?

May we know what kind of variable would like to for the edit link to be mapped?

Can you please share more information regarding your feature  request so that we can forward it to our developers?

Looking forward for your response.

 Hi Richie, thanks for getting back to me.

I'll give you a really quick overview of what I'm doing here:

I use jotform to collect submissions for events to be displayed on a community calendar.  Each event is stored as an individual record on Airtable.  I use Zapier integrations with jotform and Airtable to do a lot of the heavy lifting behind the scenes like handling jotform submissions which are EDITS and also turning single jotform entries into multiple records in Airtable if a user specifies that they want the event to repeat on multiple dates.

The way the integration works is that for every new jotform submission, a new record is created in Airtable.  And for every time someone EDITS an existing submission, it creates a new record in Airtable.

Problem:

It is virtually impossible to determine which records in Airtable are NEW submissions versus which records in Airtable are EDITS of previous submissions.  (I came up with a solution, but it involved two Zapier integrations, one VERY UGLY jotform hack, and a several hundred lines of javascript. It's a ridiculously convoluted, slow, and expensive workaround)

Proposed solution:

In addition to the jotform to Airtable integration sending over the jotform fields, please also include the ability to send over just TWO additional items:

1) The JotForm ID which is used in the edit URL.  This could be sent in the form of a string or a number.

This unique identifier will allow users to track which Airtable entries are tied to an ORIGINAL submission and each subsequent EDIT.  This can either be passed as an integer or a string... it doesn't really matter... I can't think of any mathematical operation anyone would need to do with it.

2) An integer representing the version of the submission.

IDEALLY I'd like to see jotform pass an integer to Airtable, which represents the VERSION of the submission.  A BRAND NEW submissions would pass the number 1.  If someone edited the submission, the submitted edit would pass the number 2.  Edited again? Pass the number 3.  This would be a bit more useful than a simple edit toggle (pass 1 if this is an edited form, otherwise pass 0).  SECONDARY to that solution, a simple toggle returning "1" for an edited form and "0" for an original form would be okay as Airtable does create a timestamp which would allow users to determine the chronological order of edits.

Thanks so much for your time.

-Joshua

Thank you for sharing a detailed requirement for your feature request.

For your 1st request, I have forwarded it to our developers at this thread https://www.jotform.com/answers/1940189

I have also forwarded to our developers to create a toggle to show edited/not edited submission in the Airtable integration.

Do note that we cannot give you an ETA when this feature would be added or will it be passed however, we will keep you posted via this thread.