0

Is there a way to get an action done in the background

I have two tables: 1. Fixed Assets which includes a monthly depreciation date. Now I want to have the depreciation booked to the second table being General Ledger. However, I want to have that happen without any user interference. So basically if today's date is depreciation date then booking should happen. But I have no idea to make that happen. All I thought of still requires user handling or a button. 

2 replies

null
    • Mconneen
    • 4 yrs ago
    • Reported - view

    @berry_in_manila ...  Well.. while we wait for Ninox to impement a schedule ..  There are a few options..

    1.  Use the Options Trigger after Open event to fire a global function to determine if something needs to be done.  This assumes that 

          A.  Someone opens the application at least once a day. 

          B.  The function will be smart enough NOT to duplicate action.. 

    2.  You could use Integromat (https://www.integromat.com/en/) or something similar to run a "scheduled" event to pull the desired records and then book the depreciation into the GL. 

    3.  Use the Button method.. and wait for Ninox to provide a scheduler .. 

    • berry_in_manila
    • 4 yrs ago
    • Reported - view

    Thx for your reply. Will start working on suggestion 1

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 1379Views