Hi Everyone,
A small doubt, I have created a screen on Request tables where only those rows are show when the New Requests comes, if all the requests are completed and no new request is there, there is rich text with must show that no new request, now the problem is when I am setting the visibility of rich text, it only takes the value of 1st row of table not the current row where status of request is stored(NEW), any idea how it can be resolved,
Thanks,
Trying to reword your post to see if it clarifies the problem.
Hi everyone,
I have a question. I made a screen that shows only the rows from my Request table where there are new requests. If all requests are completed and there are no new ones, I want to show a rich text message that says “no new request.”
The problem is, when I set the visibility for the rich text, it only checks the value from the first row of the table, not the current row where the request status is “NEW.”
Does anyone know how to fix this?
Thanks!
I don’t think it matters (the current row’s status) when you’re looking at a list of requests from what I understand.
You should:
- Build your screen of top of the users table, filtered to the signed-in user’s rowID/email.
- Add a query to the Requests table, filter by status = New.
- Show the collection powered by the query.
- Show a rich text component if the query is empty.
1 Like