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.
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.
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!
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
Hi,
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.