Solved: Hide action button depending on another dataset fi... - Page 2

Jhun · 12-27-2023 08:00 PM

Dear Experts need help please, I'm new to the appsheet.

I have 2 dataset, tickets and attachments. Both containts an issueid as keyfield.
tickets dataset have a status field that holds the info if a ticket is new or ongoing.

I want the attachments add action(Fig 1) to be hidden once the tickets status is set to "ongoing".
I've tried so many expresions on show_if behavior but couldn't execute it correctly.

Fig 1

Fig 2

Here's my datasets

Thank you in advance.

Jhun

Update:
I just implement a workaround to meet the requirements.
What I did is...
1.) Create a slice from attachments dataset with read only update mode.
2.) Create a vitrual column with app formula referencing rows to the slice created.
3.) Add the virtual column to the views column order
4.) Lastly I added exresion to the show_if to dynamically hide or show the attachments column. "if status is new then the original attachement field show. if not, the virtual column is visible then the original will be hidden.

I don't know if this is the best practice but this workaround works perfectly in my case.
Regards

View solution in original post

Hide action button depending on another dataset field value