Skip to main content

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

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.



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…

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.

Reply


Terms & Conditions