Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Create an automatic pending payment table according to start and end date. MRR

Topic Labels: Automations
294 1
Showing results for 
Search instead for 
Did you mean: 

I have a Profiles table.
Each profile pay monthly according to start and end date.


I want to create another table out of this table with payments request per month.
Each payment request is per whole month / or until the end date
start date 1.6.22 end date 20.6.22
payment request will have from 1.6.22 to 20.6.22 instead of 1.6.22 to 30.6.22 and amount will be the % of the “amount to pay monthly” which is in the profile table.


So basically an Monthly Recurring Revenue (MRR).

  • A worker will start and fill all pending payment manually once he see it get paid in the back.
  • If a Pending moved to Paid don’t overrun it with pending again…
1 Reply 1

Wow this airtable is so low in terms of features and tools, better use a Django DB + some scripting will take 5% of the time and much cheaper.