Help

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

Topic Labels: Automations
1180 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Sion_Cohen
5 - Automation Enthusiast
5 - Automation Enthusiast

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

image

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
Example:
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.

image

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
Sion_Cohen
5 - Automation Enthusiast
5 - Automation Enthusiast

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.