Help

How do I limit the Linked Records options in a form?

Solved
Jump to Solution
1394 2
cancel
Showing results for 
Search instead for 
Did you mean: 
NYCEDU_Admin
5 - Automation Enthusiast
5 - Automation Enthusiast

I have an Event Check-In form that allows people to add an Event, which draws from the Event table.

EVENT CHECK-IN GRID
Screenshot%20of%20Google%20Chrome%20(9-25-19%2C%207-11-41%20PM)

EVENT GRID
Screenshot%20of%20Google%20Chrome%20(9-25-19%2C%207-13-08%20PM)

EVENT CHECK-IN FORM
Screenshot%20of%20Google%20Chrome%20(9-25-19%2C%207-13-56%20PM)

Screenshot of Google Chrome (9-25-19, 7-14-09 PM).png

While we only have two events right now, I can imagine this form getting very difficult to use when we have more and more events.

Is there some way to limit which linked records the form can link to based on a parameter like date of the event?

1 Solution

Accepted Solutions
JonathanBowen
13 - Mars
13 - Mars

Hi @NYCEDU_Admin - create a new view on your events table called “Future Events” and filter this where the event date is after “yesterday” (this allows for check-ins against today’s and future events):

Screenshot 2019-09-26 at 11.37.41.png

Screenshot 2019-09-26 at 11.37.48.png

Now, on your Event Check-ins table, on the Event link field set, limit the record selection to this future events view:

Screenshot 2019-09-26 at 11.39.57.png

Now your form on the Event Check-ins table will only show future events as options for the check-in.

JB

See Solution in Thread

2 Replies 2
JonathanBowen
13 - Mars
13 - Mars

Hi @NYCEDU_Admin - create a new view on your events table called “Future Events” and filter this where the event date is after “yesterday” (this allows for check-ins against today’s and future events):

Screenshot 2019-09-26 at 11.37.41.png

Screenshot 2019-09-26 at 11.37.48.png

Now, on your Event Check-ins table, on the Event link field set, limit the record selection to this future events view:

Screenshot 2019-09-26 at 11.39.57.png

Now your form on the Event Check-ins table will only show future events as options for the check-in.

JB

NYCEDU_Admin
5 - Automation Enthusiast
5 - Automation Enthusiast

This was so perfect. Thank you for such a simple solution!