I run a paid membership community. Members are managed via Airtable. Subscriptions via Stripe.
I want to change the status of users who canceled their subscription in Stripe from “Member” to "Not a Member" at the end of their billing period, rather than instantly.
E.g. If a person cancels on the 2nd day of their monthly subscription, they should still have access for the next 28 days.
Setting up tracking of billing periods on the Airtable side seems too complicated. What would be a good solution?
Best answer by SamBView original