So I have an App formula in a table that does a SUM of some items in a different table. Nothing complicated. When I click edit on row in that table the SUM() works fine. Yet I want this to update everytime you make a change in a totally different table. Again, not a drama, done it loads of times.
Iโve got a bot where the trigger is a change in one column which then calls an action to look at multiple rows and writes a timestamp in a column of the where the SUM() formula is. The reasoning being that timestamping the forces all the App formulas to run and update.
Yet the weird thing is you add an item in the other table, the bot runs, timstamps the first table, I can see other App formulas run yet this SUM one comes up with zero. If I edit the record it adds up fine in the form.
Any ideas? Could the fact hte App is not deployed be causing this? Could put in a delay on the Bot, but 10mins is the shortest time and is going to confuse the users.
LinkedIn
Twitter
