Jump to content
  • 0

Running Mathematical Formula on inserted data


Saurabh
 Share

Question

Hi!

I am trying to create a "financial projection" dashboard. 

So essentially, what I am looking to do is:

  1. User enters different "monthly" expenses - like Car, Mortgage, etc. 
  2. Keeping fields simple, it is:
    1. Expense Name
    2. Amount
    3. Start Month
    4. End Month
  3. Once different expenses like these are mentioned, my plan is to "insert" this expense for all these combined into another table with simple fields
    1. Expense Name
    2. Amount
    3. Month

What I am missing is getting a triggered action to work on it to automatically insert on monthly levels. 

 

Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

Hi @Saurabh,

You could create a Triggered Action that runs on Insert, and action to Insert into the other table.
Something like this: 
This viedo might be useful: https://www.youtube.com/watch?v=w6T1cqg0gnk

Another approach could be to create a Task that runs every month, that will copy the data from one table to another.
image.png.87e08c9935960ebfc5df445087c24403.png

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...