Periodic Expense

AppSheet AppSheet Q&A
, ,
1

Does anyone know how to configure an application that allows entering a periodic expense? that is, place an expense, with an initial date and that said expense is copied as many times as there are periods to be paid, in a table**. is this possible?**

2

Definitely possible. Set up a scheduled Bot that runs on the minimum interval, like say every day. The Bot checks every row of your periodic_expense table to check if any of them are ready to be charged. I recommend these columns in your periodic_expense table:

  1. expense
  2. price
  3. interval (days)
  4. last_charged_date
  5. next_scheduled_charge_date (fomula of last+interval)
  6. start_date (?)
1 Like
3

Thank you mark!

4

Do you know of any sample app on how such a bot could be executed? I know almost nothing about Bots and they have a lot of potential. Some tutorial.

5

No. Have you tried reading the help files?

https://help.appsheet.com/en/articles/4865307-appsheet-automation-the-essentials

1 Like
6

Right now I will. Thank you so much