Help

Watch for an updated field in table1, then add it's value to a value in table2

Topic Labels: Automations Formulas
144 0
cancel
Showing results for 
Search instead for 
Did you mean: 
hauwi
6 - Interface Innovator
6 - Interface Innovator

Hi. I find it helps to think of this as similar to updating the number of available stock-items after an order. 😊

I have a 'claims' table where each record is a tutor claim - per student. Each claim contains a 'number of hours claimed' field. I then have an update record automation which passes that value to a 'hours last session' field in my 'student' table.

Now, in my 'student' table I need a new automation to run each time my 'hours last session' field is updated, to take that value and add it to a 'total hours used' field, Essentially, a running total.

It seems simple but I just can't seem to find a way of doing this!

Any help would be very much appreciated! Thank you.

 

0 Replies 0