Return information from next row down in datablaze table

Questions and Help
1

I've tried multiple solutions, including the one found here but I'm having zero luck with this.

I'm trying to read from a table of semesters and their important dates. When a staff selects the current semester, I want to return dates from this semester, and next semester (the next row). For example, it is the Fall 2024 semester which has deadline A. If a student inquires about scholarships, I want to return deadline A, as well as the Springs (next row) start date (start A) and deadline (deadline B). So, if they missed this deadline, I can tell them about the next one.

While I assume this could be achieved with multiple selections from the read table, I'd rather ask the staff to just select one semester, to limit clicks, if it all possible.

Does anyone have a way to accomplish this? Thank you for your help!

2

Hi @COREY_CHARLE, welcome to the forum. :slight_smile:

Are you available for a quick call to help you? If you're available now, please let me know, I'll send you a meeting link as a private message.

3

I found a solution that works well for this specific instance. This snippet always uses the first row, so I turned off the menu setting for the read table, allowed multiple selections, and set the response limit to 2. Now, I have all the information I need AND the user doesn't have to select anything. Couldn't be smoother!

2 Likes