Here’s the situation I’m trying to acheive:
- the users fill out a form, which creates a record in airtable. (wich checkbox ‘payment complete’ unchecked)
- users pays the corresponding amount via Stripe
- After payment is complete, find the record in airtable and check the checkbox ‘payment complete’.
I’ve created the form for step one. But I don’t know how to connect the stipe payment to the record. For example, is there a way to pass metadata (recordid) to stripe or something? That way, I could use Zapier to update the record in Airtable.
Ok. I’m a bit further, but not completely there yet.
So let me rephrase my question: Is there a way to pass the Record ID to stripe checkout?
Hi edwinvdg, any progress on this issue? I am interested in implementing something similar so any advice you have or resources you can point me to would be much appreciated.
Hi @siyu , nope. Did not find a fitting solution, so I had to create a workaround. And that workaround is as follows:
- Someone needs to fill out a form (with email address) which goes into a record in airtable
- pay in stripe (hopefully with same email address)
- Using Zapier, I check whether the email address matches. Then I update that record.
Thanks for sharing the workaround you figured! What site is this? Is there a live version I can check out? I wonder what it’s like as far as user experience goes. Thanks either way!
Hi @siyu. The site is in dutch, but here it is: https://niet-niks.nl. And the specific experience, you can find here: https://www.niet-niks.nl/kist-detail?recordId=recpkQX9g6ofAZwod
Hey @edwinvdg I have a situation quite similar to yours. I realize you faced this issue some time ago, I was wondering if you figured out a more seamless way to update a record after stripe payment. In my case, users might have multiple records and they might need to pay for and update one of them, so the email matching might not work, the actual record ID might be needed. thanks
@edwinvdg email is indeed one option. How do you generate stripe payment links? If it’s in Airtable can’t you attach metadata like it’s mentioned here ? Attaching metadata to Stripe Payment Link - Stack Overflow
Hey @TJ-Pitchstr , for now this solutions works quite ok. So didn’t search for a better one. Did you find one in the meantime?
Adding metadata in the Stripe link would be awesome, but how can we do that in Softr?
I found a way to achieve this. Basically you want to pass the metadata to stripe using the payment link. There is a functionality in Stripe, in the edit payment link page that allows you to generate the URL including an email or a client ID (record ID).
Once you have the right URL, you create a column in your airtable base with a formula that includes the payment link URL+the parameters you want to pass to stripe. For example, I’m passing the email adress of the user and the record ID.
Finally, in Softr you need to include an action button that will be the one the user will click to pay. This action button should open a URL. You can select to obtain the URL from airtable, so you select the one in your cell that contains the payment link with the metadata.
Then in Make or Zappier, you create the automation that when the payment in stripe is done, the corresponding record is updated. You will have the record informationa and email as part of the payment metadata.
I hope this is understandable and useful for your use case, I have tested and is working for me.