Hayley 0 Posted November 27, 2020 Report Share Posted November 27, 2020 Is there a way to calculate on how many times will my update datapage be updated? Thank you in advance. Quote Link to post Share on other sites
0 PotatoMato 0 Posted November 27, 2020 Report Share Posted November 27, 2020 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 Quote Link to post Share on other sites
0 telly 1 Posted November 28, 2020 Report Share Posted November 28, 2020 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/ Quote Link to post Share on other sites
0 TellMeWhy 0 Posted December 25, 2020 Report Share Posted December 25, 2020 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 Quote Link to post Share on other sites
Question
Hayley 0
Is there a way to calculate on how many times will my update datapage be updated?
Thank you in advance.
Link to post
Share on other sites
3 answers to this question
Recommended Posts
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.