Actions Linked to a Column

AppSheet AppSheet Q&A
1

I have a table with a column called Actions and I use this column to display Actions.

I have 4 Actions linked to the Column which send notofications in Microsoft Teams to various people depending on the Status of the Order

Requested, Approved, Ordered, Cancelled

When Status is Orderd or Cancelled there are no Actions to show.
I want to hide the Actions column if Status =Canceled or Ordered.

But, this doesn’t work, any sugesstions welcome please.

3X_e_1_e1f23c48c0cb42c002618ddff52fc22b4616927a.jpeg
3X_e_1_e1f23c48c0cb42c002618ddff52fc22b4616927a.jpeg563×285 26.2 KB

3X_4_f_4f3e27ccff556d1d10aa0c67c895c9c4e15e8809.jpeg
3X_4_f_4f3e27ccff556d1d10aa0c67c895c9c4e15e8809.jpeg547×330 24.5 KB

2

Your logic is wrong. Try this instead:

AND(
  ("Ordered" <> [Material Status]),
  ("Cancelled" <> [Material Status])
)

or:

NOT(
  OR(
    ("Ordered" = [Material Status]),
    ("Cancelled" = [Material Status])
  )
)

or:

NOT(
  IN(
    [Material Status],
    {"Ordered", "Cancelled"}
  )
)
1 Like
3

Steve:

auto> NOT(> OR(> (("Ordered" = [Material Status]),> (("Cancelled" = [Material Status])> )> )> >

Thanks @Steve. i have tried all of these but column is still showing.

1 Like
4

I found a typo in two of them, which I’ve corrected. Please try the corrected expressions.

5

I did notice these and had removed those brackets when I tried them first.

1 Like
6

They still didnt work @Steve

7

What does the Test button in Expression Assistant tell you?

1 Like
8

Steve:

auto> NOT(> OR(> ("Ordered" = [Material Status]),> ("Cancelled" = [Material Status])> )> )> >

3X_f_b_fbc83b22b1e16478fdfad16736b5e334c0dea490.jpeg
3X_f_b_fbc83b22b1e16478fdfad16736b5e334c0dea490.jpeg1699×662 69.8 KB

2 Likes
9

Hmmm… So the expression works, but the actions aren’t hidden. Instead, you’re probably going to have to hide the actions individually using each action’s Only if this condition is true setting.

10

Steve:

auto> NOT(> OR(> ("Ordered" = [Material Status]),> ("Cancelled" = [Material Status])> )> )> >

I already have expressions in the Actions to hide them which work but when there are no Actions showing, the actual column still shows

11

Could you update if you wish to hide that Action column in table view for those rows with [Matrerial Status=“Ordered” or “Cancelled”

1 Like
12

Yes, that is exactly what I am trying to do @Suvrutt_Gurjar

13

Thank you. Then if I have understood your requirement correctly, I believe it is not possible in summary view such as table view.

I believe conditional Show_if conditions on columns may not work in summary views because there will be some rows that may need to show such columns. So hiding it for some rows and showing for others cannot happen in a table view. I believe in table view, it is Show column for all rows or none.

1 Like
14

That’a a pity. It takes up so much room on an inline view. Maybe if we ever get a wider screen on desktops it won’t matter as we can then see more of the data without having to scroll on each row.

15

I think it is by the nature of the multirow table view where conflicting conditions on one column are ignored for valid reason. I believe is like in Excel or GSheet , where we can hide a column or show it. We have filter expressions for rows but not columns.

One option may be to have slice based on that columns show if conditions and hide that column in summary view based on the slice with

OR(
(“Ordered” = [Material Status]),
(“Cancelled” = [Material Status])

Of course in all app designs, it may not be advisabl,e if users have to browse two different views just so as not to see one column.

1 Like
16

thanks for your reply @Suvrutt_Gurjar