Hello, I am working on an app that has a repeater table, with rows that increment when the user gives 2 specific dates and a message (I will refer to these as rules). On the same page, the user can select another another date (outside of the repeater), and if this date is between any pair of dates of the rules, the specified message that applies to that rule should be returned in a seperate text box. I cannot figure out the logic to link a specific cell in the repeater (the message) to a text box without filtering the table and effectively removing all other rules on the page. Please lmk if anyone knows how i could do this
You need to check if a selected date falls between the start and end dates of any row in the table (or repeater). If so, you return the message corresponding to this rule in a separate text box.
Have a look at the attached. You can put the logic in an onItemLoad event and then use a clear filter event to re-evaluate. I have it on a button, but you could also do it on text change of the date field, or on lost focus on well.
I also have an event that for the first item will set the message to “not found” so that if nothing is found that message will display. The not found message gets overwritten by the second event if there’s a match.
You’d obviously have to figure out if you want to handle multiple messages.
RepeaterDateCompare.rp (51.2 KB)