I’m trying to use a set column action on a button press to dismiss a notification. I have the notification set up in one sheet (Notifications) and on button press (“Mark as read”), the action is to increment -1 so that the visibility condition kicks in and the notification goes away (this works 100% fine). The problem that I’m having is that the notification tab uses the User Profiles sheet and there’s no way to modify the visibility condition without somehow changing a setting in a column on that sheet.
I successfully created the relation between the two tabs but when I change the button actions to include set column, it doesn’t do it. I’ve tried changing the column type between text, numbers and boolean and I’ve spelled true and false three different kinds of ways (TRUE/FALSE, True/False, true/false).
I think I read a few topics that detailed similar issues but there doesn’t seem to be a consensus on how to solve it. Does it sound like I’m doing something wrong? Or is there another way to change the value of one tab based on the value of another WITHOUT using set column?