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.
