Is there a way to run a bot when a view is entered?

[andyburnett]

I would like to populate the some fields in a view based upon the values that are returned from a Google Apps Script function call. I have a bot that returns the JSON correctly, but I can't find a way to make this run when a view is entered. Is this possible?

[peterson]

Hi, unfortunately this is not possible.
Appsheet only has "add, delete, update" as possible events to choose. There isn't a known way to call a bot just by opening a view. You could maybe use a button to trig an action, that would work, or call this bot after you hit the sabe button in a form view.
Sorry about that.

[andyburnett]

Thanks for your thoughts. I am new to Appsheet. How do I create a new button and associate it with a bot? 

[Suvrutt_Gurjar]

This may or may not be possible but could you mention what view you are referring to? Meaning transition from which view to which view?

AppSheet has what is called as event actions that are executed when a row is selected in summary views and when a rows is saved in a form view. You may want to evaluate those if those are of any help. Event actions are available only for summary views and form view , though.

You could possibly set a column value on as event action and then run a data change event.

View events - AppSheet Help

[SkrOYC · Accepted solution]

Adding 2 cents to @Suvrutt_Gurjar clear explanation...

The issue here is not if you can trigger a bot or not when opening a detail view, instead it's the fact that AppSheet doesn't work with real time data so even after the bot is fired you won't be able to get that data by the time the detail view is displayed

[andyburnett]

Thank you everyone. Unfortunately, the inability to read the data returned from the function makes Appsheet a non-starter for me. Oh well, off to look at Retool instead.