I have two tables. One produces and logs messages โNotification Logโ. The other produces and logs responses โResponse Logโ. The problem i have is getting one view to stop showing a button โGot the messageโ after a response log is generated.
I have a form โnew messageโ that logs in the โnotification Logโ table.
I have users viewing this list of messages - from the notifications log table. The use clicks a button โGot the messageโ to let the admin know they received the message.
The problem i have is, i cannot figure out how to make that action button do several things:
What have you tried?
I tried setting it up as:
Data - add a new row to another table using values from this row - see image
After this i am un sure of how to make the view ONLY show unclicked rowsโฆ
One approach would be to make your slice filer expression something like this:
ISNOTBLANK(
FILTER(
"Response Log",
AND(
(USEREMAIL() = [Useremail]),
([_THISROW].[Key] = [Key]),
("yes" = [Read])
)
)
)
Over time, however, this approach will cause the app to get slower and slower.
Do you have any other suggestions?
I donโt.
In your images, its looks like you might have the assignment of Message and Message Key switched?
You have:
I put this expression on my slice - filter. It stopped showing any messages. Meaning - without this expression - the user can see the message and click on โGot the Messageโ. But when i add this expression - all the messages go away.
I used that expression in the action behavior. It doesnt show any action buttons. So, now there is nothing for the user to click on.
Here are the two different data tables:
I switched that - but it still doesnโt work correctly.
I think there might be logic error in the expression, Instead of ISNOTBLANK I think you want ISBLANK.
The idea is to show the message row (or show the button) when there are NO rows that indicate the message has been read.
By the way, if your intent is to hide the ROWS once the message has been acknowledged, you do not need to place this same logic in the condition for the button.
Ok. I want to do exactly what you said. I want that action button to go away after the user has clicked on it. I may be putting this logic in the wrong place. I put it on the action button:
โonly if this condition is trueโ
Ah, Message Key is the name of the column in your Response Log table so you need to change this:
([_THISROW].[Key] = [Key]),
to this:
([_THISROW].[Key] = [Message key]),
i moved that logic on the slice. It now shows the action button no matter if i clicked it or not. So it shows them, but they never go away. I checked my data - and it is populating correctly in the table.
This is the logic i used:
ISBLANK(
FILTER(
โResponse Logโ,
AND(
(USEREMAIL() = [Useremail]),
([_THISROW].[Key] = [Key]),
(โyesโ = [Read])
)
)
)
My Lord you guys are so smart. That worked perfectly. Thanks again guysโฆ
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |