Hi there, I am trying to get an action button to show up on a view and I must be making some syntax error.
I have used this Statement in the Behavior Field: (CONTEXT(“View”)=“IToolsV2_Part”) and this:
CONTEXT(“View”)=“Part” and this: CONTEXT(“View”)=“Sheet1_Part”). The Table is just called Sheet1, the App is called IToolsV2 and I can never get the Action to show up on the “Parts” View. Only the Main View and when the behavior is set the action disappears completely. Any ideas?
Sounds like you need OR() - https://support.google.com/appsheet/answer/10108121?hl=en
OR(CONTEXT(“View”) = “..”, CONTEXT(“View”) = “…”,)
Please post a screenshot of the configuration screen for the action.
Hi Folks, here is the Action, a question if I may, I’m trying to have an action execute after a data update.
Basically I am trying to update a separate SQL Database from the spreadsheet modified by Appsheet using some sort of update trigger. Likely there is a much easier way to do this and any help is appreciated as I’m not that familiar with Appsheet yet.
The Action is also set in the view. If I remove the Behavior Condition the action does appear on the view.
(below) but a trash can appears on the main view now for some reason.
Show us the whole action config, including “Appearance”
The only real difference between the two days is yesterday I was using an existing view and this field was not available in the existing View but was present today when I created a view:
This is resolved, it would appear that the Actions can only be added to Primary views. Thanks for the help.
