There is an Archive column in my table which I have set up as a Yes/No column type with Yes being displayed as "Archived" and No being displayed as "Current".
I have created an action for the table in a Prominent position with the type "Data: set the values of some columns in this row" to set the Archive column to Archived. The Behaviour is set to Only if [Archive] = "Current".
When I save the change and also click on the sync icon in the app the Archive action does not show anywhere in the detail view.
I've tried the following settings for the Only if Behaviour but none of them work:
[Archive] = FALSE
[Archive] = NO
[Archive] = "N"
NOT([Archive])
I have a Google Sheet at the backend and can see that the values in the Archive column are recorded as TRUE/FALSE in Google Sheet however when I test the expression in Appsheet the values in the Archive column show as Y/N.
I have also noticed that it does not show in the list of Actions when editing the view for the same table. The only actions shown are the previous two Actions I had created on another column in the table which was set up as an enum.
What's happening? Any ideas?
LinkedIn
Twitter
