Re: Action button not displaying for Yes/No column

dennish · 08-10-2024 05:57 AM

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?

TeeSee1

@dennish wrote:

NOT([Archive])

should work as shown here

I have [DelFlag] as YES/NO and "DELETE" = TRUE, "DONT" = FALSE.

@dennish wrote:

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 am not sure exactly what you mean here. What do you mean by "save the change"? If you change the Archive column to "Archived", isn't it expected that you no longer see the action??

dennish

I changed the 'Set these columns' setting to Archive = [Archive] and changed the Behaviour for 'Only if this condition is true' to = NOT([Archive]) and it still doesn't work (the Archive button is not displaying inline with the Archive column in the detail view against items where the Archive column value is FALSE).

I noticed you are using 3 different columns:

L1 column for 'Set these columns'
ID column to attach the action button to
DelFlag column for 'Only if this condition is true'

I have used the Archive column for all 3 settings. That shouldn't matter right?

I even tried changing the Archive column into an enum column and set it up in the same way as another enum column in the same table but still only the action button for that other enum column is displayed in the detail view.

@TeeSee1 wrote:
@dennish wrote:
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 am not sure exactly what you mean here. What do you mean by "save the change"? If you change the Archive column to "Archived", isn't it expected that you no longer see the action??

What I mean is that when I go to edit the main view of the table, which I've configured as a deck view, this Archive action I created does not appear in the list of Actions (under Show action bar toggle) under the Automatic tab. I would have to select Manual and add the Archive section manually (whereas the other actions I created for the enum column appear automatically in the Automatic tab). I don't want to show the action bar because it looks cluttered and detracts from the list of items.