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.
Hey there! I have followed your steps, however when I get to the “include a button with URL created in Airtable (that includes the variable)” I don’t see how we can do that:
The way I currently have it setup is I make a URL using a calculated field iin Airtable and adding the parameters I want to get back in a combined string.
EG: Variable1 & “-” & Variable2 & “-” & Variable3
Note: Its important to separate them by ‘-’ as no other character will work
Now in softr, I use a modal to show my payment gateway, but this will also work as long as you display the URL you just made, once a payment is made, it will track the string you’ve created
To get the data back to Airtable after the payment is complete you need to do 3 things;
Setup the listener in Stripe, in your stripe in you products there will be an option to add webhooks to the payment, I’m using checkout.session to track mine, but there are heaps you can use to trigger the webhook.
Create a new automation in Airtable and have the trigger as a webhook, copy this url and paste it into the stripe endpoint from the previous step.
Below the webhook, run a script that does whatever you want with the data you’re parsing through.
For step 3, depending on how much coding experience you have, I’m more than happy to help write something for you, but the general structure would be something like this (my code):
Here, price and data are parsed in via input variables which are taken from the webhook
let {data, price} = input.config();
// Split the input string
let [property, requestedBy] = data.split('_');
// Determine the report type based on the price
let reportType;
if (price === 15000) {
reportType = 'Preliminary Site Investigation';
} else if (price === 40000) {
reportType = 'Detailed Site Investigation';
} else if (price === 90000) {
reportType = 'Comprehensive Site Investigation';
} else {
throw new Error('Invalid price');
}
// Reference to the tables
let table = base.getTable('Property Reports');
// Create a record in the table
await table.createRecordAsync({
'My Properties': [{ id: property }],
'Requested by': [{ id: requestedBy }],
'Report Type': {name: reportType},
});
If that all makes sense give it a go, if not let me know where you got lost and I’ll provide screenshots of stuff.
Hey Harry I am very interested in the solution that you had shared. It seems it is possible to bypass Make/Zapier to accept payments before updating Airtable. I have some questions though such as how to show the stripe checkout page based on the unique form information. Can I DM you about them?
