Save the number of updates

[Hayley 0]

Is there a way to calculate on how many times will my update datapage be updated?

Thank you in advance.

[PotatoMato 0]

Hello @Hayley.  Yes, this can be achieved by this formula: (SELECT field_name FROM table_name WHERE ID = target.[@field:ID]) + 1. So every time they click the update button, it will automatically add 1 to your current number of update.

Hope this helps.

-PotatoMato
 

[telly 1]

Hi @Hayley,

You may also use a trigger for this, basically every update for that record, add one for the specify field, you may check this link: https://howto.caspio.com/tables-and-views/triggered-actions/

[TellMeWhy 0]

The best way to do this, and document the updates, as mentioned by telly, is through trigger, you may create a new table where you can store updated values as well if you'd like (like a history log of some sort).

Create a trigger on your main table and on update, insert a new record on the new table (history log). If you want to display the total amount of times it has been updated on a DataPage, you may use a Caclulated Field/Value and count the records in the history log table