Sep 04, 2024 06:31 AM
I have a column that fills in the State Abbreviation from Jot Form. The form is a drop-down selection that is the same as my single select column in Airtable. Somewhere new duplicate selections are being generated with new submissions. I am trying to figure out where to even look for how this could be happening. Any help would be appreciated.
Sep 04, 2024 10:43 AM
When that happens for me it is usually an automation that adds it with something like a space at the end. Creating a duplicate Select option.
Sep 04, 2024 02:52 PM
That seems reasonable but the selection in the Jot Form is a drop-down and the answer to the drop-down is what gets pulled into Zapier then Airtable. Where would there be an opportunity to put a space in it? And when I fixed the duped States in Airtable there wasn't a space.
Sep 04, 2024 04:29 PM
Could the original choice have an extra leading or trailing space?
Sep 04, 2024 11:50 PM
Hello @Debbie_Benkovic,
As for both of the suggestions from @Nathan_Ramey & @kuovonne. It looks like it should be solved.
If not?
Then also check if is there any other API or Integration triggered when jotform is submitted. Also, check for airtable automation as well.
👍
Sep 05, 2024 08:16 AM
There were 2 more instances today and there is a space being added. Because all of the instances are still coming from a dropdown list and I couldn't find an extra space anywhere. I did notice that both are passenger 3. There is a patient, a passenger 2, and a passenger 3. Only the passenger 3 was duped. There is an animation that creates backlinks to link all the patients together in Airtable. This has been in place and working for quite a while. See the screen grab of what the State Portion looks like in the Airtable automation and the Zapier field that specifies the State for passenger 3.