Reset on Sync? Option

[Skip2MiLu]

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.  

[Aurelien]

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.

[Skip2MiLu]

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)

[Aurelien]

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.

[Skip2MiLu]

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?  

[Aurelien]

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.