In summary I was hoping that Appsheet had a “Rest on Sync?” option to complement it “Reset on Edit?” option, as I looking to cut down on virtual colums.
I am looking to automatically update the related child records when the the related / reference parent table record is updated - without using virtual columns. This is in the effort to affoid slow syncing on large data sets and or many virtual columns.
Currently I can only achieve this using virtual columns and I was wondering if anyone know if there is a way to effectively achieve a “Rest on Sync” option or some kind of workaround for my below expression I have in either the intial value (so that I user can change the value after if needed) or in the App formula were a user is not able to update the value.
Hi @Skip2MiLu
You may want to consider using a bot then.
I suggest you use a table as a base for one “reset all” button, that will be displayed to your users. Then, clicking on this action will trigger a bot that will update/reset all expected results.
1 Like
Hi @Aurelien
Thanks for the support. I not sure if I understanding you suggestion correctly.
Are you saying a bot is going to help me recalculate expressions I have in either the initial value and or app formula for a specific column I have specifically set them to recalculate.
(i.e. similar to a column “Reset on Edit toggle”, the only difference is that expression will Rested i.e. Recalculate on sync and run on each record for each record where a “Reset on Sync toggle” was selected for that column)
Hi @Skip2MiLu
Yes indeed.
That means you will have to define one action per column you wish to reset, and trigger all of these with the help of a bot.
And with this system, you will have to build a mechanism that will emulate the “on sync” action through a data action.
1 Like
Ok, sounds interested. I am however unfamiliar with bots. Any guidance on how I go about achieving your suggestion.
Your suggestion about actions made me thing of another scenario that might also work and I wanted to get your thoughts on the idea and if you think it would be an option.
So if editing the row is what would trigger a reset or recalculation of any initial value of app formula.
Would it not be possible to then have one action for that table that when triggered would edit a additional column I added for that table to capture a new value or “i.e. edit the row”. Would editing a row with this value then result in the column recalculating any initial value or app formula expression and thereby achieve what I looking for?
Hi @Skip2MiLu
Editing a row through an action button or a bot won’t trigger the “reset on edit”.
It would be more considered as “updating a row”, I would say.
For creating a bot, I suggest you follow this:
Bots: The Essentials - AppSheet Help
Basically, your Step type will be “Run a data action” as mentionned here:
Steps: The Essentials - AppSheet Help
Your data action will have to be created from the Behavior>Actions panel, as you would usually do for any data action.
That means you have to reproduce all of your “initial value” expression in such action.
2 Likes
