Uploading Stripe payments through Jotform to AT

You probably need a number or a currency field.

However, your much better option would probably be to use Fillout’s advanced forms for Airtable, which offers native Stripe integration, and communicates natively with Airtable.

- ScottWorld, Expert Airtable Consultant

Thanks - that did not make a difference. Please see in the image I attached that the people are choosing text: “I can pay …”. So I’m guessing that’s what it could upload, though I would be happy if it uploaded the price paid instead.

My guess is that under the hood each of your “choices” is not just text, they’re whole objects. Does JotForm allow you to get just the name of your products? Do they have the equivalent of a Lookup or formula field?

Thanks - It does allow me to grab those from a regular field, but I can’t figure out how to grab them (or assign them a dollar value to grab) from the payment processor’s field.

I sent the question to Jotform support - this is what they told me:
Sorry, but there is no option to map the payment field to Airtable as there is no similar field type on Airtable.

This is only possible if you set up your products outside the payment field using Single/multiple-choice fields and using a form calculation widget/short text field to show the total.

Then you can map these separate fields onto Airtable.

That’s weird — I wonder what kind of format those payments are in that JotForm believes that Airtable can’t accommodate it?

If you’re required to use JotForm, you may want to use Make’s JotForm integrations along with Make’s Airtable integrations, which will enable you to get your data into Airtable.

However, your much better option would be to use Fillout’s advanced forms for Airtable, which offers native Stripe integration, and communicates natively with Airtable.

Fillout offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records using a form, display Airtable lookup fields on forms, control access to a form via SSO or email domains, perform math or other live calculations on your forms, accept payments on forms, collect signatures on a form, create multi-page forms with conditional paths, create new linked records on a form, connect a single form to dozens of external apps simultaneously, add CAPTCHAs to your form, and much more.

I show how to use a few of the advanced features of Fillout on these 2 Airtable podcast episodes:

• Using Fillout to create an eSignature approval process with PDF file creation.
• Using Fillout to create an order entry form with line items.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld

Again, I think because the Product field type stores data as “the whole Product Object”. I think, or its a structured array. That’s why I asked if you could get the product name with a calculated column or something, and pass that column off to Airtable. That way you’re just passing a string.

Wish we could - we’re an all-volunteer non-profit.
Thanks for the tips!

I figured it out! To Kamille’s point - I had been trying to use a “calculation” field in Jotform to pull the payment number. I needed to use a plain text field in Jotform and in AT. Then I put in conditional logic in Jotform, so if a person paid $25, for example, it put 25 in the Jotform plain text field. Then the AT integration could pull that into AT. I assume this will work will a number field in both places too. Thank you for your help!