Payment Processing On Form

[AFGF]

Hi all,

I need to build a form to collect a person’s name and email address but when they sign up a small application fee is also collected. I am thinking of using Stripe or Braintree for payment processing.

The key question here is where will the backend database be hosted? On Stripe/Braintree or on Airtable or on both? Another angle w.r.t the same question: how to go about making a form that accepts a payment?

Have you done this before? If so, how did you do it?

Thank you so very much,
Freedom.

[JonathanBowen]

Hi @AFGF - not exactly sure from your description what your set-up is, but a suggestion:

• Use a Jotform payment form to capture customer details and the payment (integrates with Stripe, PayPal, Braintree, others)
• Send the collected form data to Airtable using the built-in Jotform integration

JB

[AFGF]

Hi JB :slightly_smiling_face:
Good morning.

Sorry about my unclear description. I am going to look at Jotform now and report back shortly on how/if it worked.

THANK YOU SO MUCH, JB.

Cheers!

[AFGF]

Hi again JB:

If supposedly I did not use Jotform, and, instead used this Zapier integration: https://zapier.com/apps/airtable/integrations/stripe

Is there any technical difference between the output from Zapier and the output from Jotform? Or, would they change the capabilities of my database in any way?

Thank you,
Freedom.

[JonathanBowen]

Hi @AFGF- so it looks like you can do Stripe -> Airtable in Zapier, i.e. when a new charge is created in Stripe you can push the data into your Airtable base. However, it doesn’t look like you can do Airtable -> Stripe, e.g. create a charge in Stripe from a new Airtable record (or submission of an Airtable form). So, you’re going to need some sort of form to capture the customer and card details - all of the well known form providers offer this - Jotform, Wufoo, Cognito - have this form integrate with Stripe, then use Zapier to send Stripe data to Airtable. Make sense? Stripe also offers hosted checkout pages so this could also be an option, i.e. lose the 3rd party form and just have Stripe. That said the 3rd party form solutions have done a lot of work to make presenting a payment form easier. I know from experience that the Stripe checkout pages aren’t as easy to set up as, say, a Jotform payment form.

But to answer your question, there’s no difference in the data that comes from Stripe via Zapier or Stripe via Jotform - just a question of building the base to match what each service can send. And if Stripe is the payment gateway in either case, this is going to be the same, I imagine.

JB

[AFGF]

Your explanation is rad. I totally get it. It all makes sense. Will definitely share the final product in “Show and Tell” section!!! :grinning_face_with_big_eyes:
THANK YOU SO MUCH FOR YOUR HELP.

[ScottWorld]

Your #1 best solution for accepting payments on Airtable forms is to use Fillout's advanced forms for Airtable.

Fillout can do all of this natively, without needing to use Make as a middleman! 🙂

Fillout offers hundreds of features that Airtable’s native forms don’t offer, including the ability to update Airtable records from a form, display Airtable lookup fields & Airtable rollup fields & Airtable attachments & formulas on forms, dynamically & conditionally filter linked record fields by any values that you would like, perform math or other live calculations on your forms, accept payments on forms, create multi-page forms with conditional paths, create new linked records on a form, display as many fields as you want to see in a linked record selection list (including attachment fields), connect a single form to dozens of external apps simultaneously, limit the number of linked records that can be chosen, upload an unlimited amount of attachments simultaneously, add CAPTCHAs to your form, add choice matrixes to your forms, direct integration with hundreds of apps like Calendly & Google Maps on your forms, and so much more. 

Of course, if you want to still accept payments with JotForm, that's fine too, but JotForm doesn't have live communication with Airtable, and it only supports some of Airtable's field types. So if you use JotForm as your form tool, then I would highly recommend using Make's JotForm integrations to bring your form submission data into Airtable.

For those of you who are considering using Zapier, I would STRONGLY recommend against using Zapier. Make is INFINITELY more powerful & customizable than Zapier, yet it is SIGNIFICANTLY CHEAPER than Zapier. I wrote an entire post here comparing Make vs. Zapier.

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

[paulo]

We have built a third-party form that integrates with Airtable. Our form is capable of integrating with Stripe to process payments. Just bringing this up as another option for you.