I am building a SaaS product using Softr, Make, Airtable, Stripe, and some other tools. To do so I need to manage licenses (eg. user seats). The challenge I’m running into is getting the quantity of subscriptions purchased in Stripe Checkout linked to the User that was created in Softr. I know this User ID must be passed to Stripe because when the subscription is purchased Softr lists what Subscription the user is on. However, that is not accessible and the quantity of subscriptions doesn’t seem to be stored in Softr. While I can get the quantity of subscriptions purchased directly from Stripe I cannot find a way to link the Stripe subscription data to the User created in Softr.
If I could pass the User ID from Softr to Stripe as meta data that could work but that’s not an option with the Pricing Block.
The only hack I can come up with is to assume that the billing email that the user entered in Stripe is the same as the email they used to create their account in Softr. That won’t always be the case so that will cause me to not be able to track the quantity of licenses.
The only other option I can think of is to completely drop the use of Softr/Stripe integration, create my own pricing block, and manage all of the API calls via Make and Stripe on my own.
Thoughts?
I’m not sure if I’m understanding correctly, but I might be able to help you think of a solution. One idea that comes to mind is creating an intermediary table in Airtable to link the information between them and leveraging Airtable’s automation features.
I will be running into a similar issue (minus the quantity but i have different subscription levels) but assumed that I could store subscription status in Airtable and block the user from being able to submit a form or perhaps being able to login if subscription status == no (or something like that)
Is what you’re needing more complicated? Or is my assumption that the above is easy, not correct?
The issue stems from there being no way (that I can find) to link a User created via the Softr native (utility) Sign Up page and the subscription purchased via Stripe Checkout.
Okay, with some help from ChatGPT I was able to figure out how to pass the User’s Airtable RecordID to Stripe. I use the Stripe Pricing table and embed it in a Softr Custom Code block along with some other custom code which passes the record ID to client_reference_id in Stripe. Then in Make I use a Stripe module to watch the checkout.session.completed event and in that payload I get the client_reference_id and Stripe’s customer ID. This gives me the link I need to manage subscription licenses with Make and Airtable from there.
I don’t know if this is possible using Softr’s Pricing Table block and Stripe integration. I spent enough time on this already so I’m going to move forward with this path.