How to Efficiently Set "Read" State for Rows in a Repeating Group on Page Load?

prosto.duda · 2025-01-26T21:55:17.666Z

I have a table of requests where users can mark a request as “read.” I also track whether a request is marked as read and apply conditions like changing the row’s background color or hiding the “Mark as Read” button.

Currently, I can implement these features, but the process feels inefficient since the same checks and operations repeat every time the page refreshes. Is there a way to perform these checks once (e.g., when the page loads) and persist the “read” state for each row in the repeating group without recalculating constantly? I’m looking for a more professional and performant solution.

jonathan.baxter1991 · 2025-01-26T22:01:26.417Z

Hey, so when you press mark as read do you update the repeating group field in the database? Also how are you currently hiding the “Mark as Read” button and changing the rows background color?

prosto.duda · 2025-01-26T22:04:45.751Z

Yes, I create a record in a separate table like User Request Action. Currently condition if Current Row is in User Request Action (with action Read) I hide button or make background color as default.

jonathan.baxter1991 · 2025-01-26T22:08:53.607Z

Ok, it would probably be quicker if you added a field to the repeating group database called "Marked as read? yes/no and then make your conditions IF current field’s marked as read is yes then hide the button or change the background. With your current set up you have to search two databases instead of just the one.

prosto.duda · 2025-01-26T22:12:39.190Z

Yes, but 1 request can be mark as read by different users, also I have other actions as bookmark, hide, etc.

jonathan.baxter1991 · 2025-01-26T22:14:54.987Z

Ah I see. How are you currently doing the search for the User Request Action?

prosto.duda · 2025-01-27T17:19:31.383Z

Do search User Request is current user and is read

prosto.duda · 2025-01-27T17:45:23.249Z

image1313×595 60 KB

jonathan.baxter1991 · 2025-01-27T21:13:36.324Z

I see, one thing you could do is put that search in a hidden variable. Create a popup called hidden variables, add a repeating group and do the search for all of that users request actions and then in your main repeating group you can change the condition to be check this if current rows search request is in that row. This would mean your only search for the users request actions once and they are found on the page load.

image1297×477 31.8 KB

system · 2025-04-06T21:56:13.430Z

This topic was automatically closed after 70 days. New replies are no longer allowed.