I need my Airtable “Members” table to be updated with some infos coming from Stripe when my Subscription Product is purchased by a user.
Basically, when a user goes from free to paid, i need to update that user record in the Airtable table with these 3 columns
- Is a paying member? → Yes - Subscription start date → date of the purchase - Subscription end date (i only have annual options, so exactly 1 year after purchase) → this could also be a calculated field directly in Airtable, no problem
I see in this video there’s “Purchase date” column in the Airtable base. So hopefully this can be done automatically
I mean, i think Softr has these infos somewhere, because they are used to define a user group based on payment, but i don’t know how to show them in Airtable.
Hello @rrthegefsrht
Thanks a lot for your reply.
I imagine it’s a feature many of us would need… you are right!
Do you know how could i do it via Zapier? I tried but the “start date” field that comes from Stripe is not actually a date, but has a weird format.
If i don’t use Zapier or Make, The only alternative would be checking the subscription status directly on Stripe? Does Softr at least know when the subscription period ends?
We could support this for you with Relay.app, a flexible alternative to Zapier and Make. Feel free to send me a note at jacob@relay.app and I can help you get it set up.