Limit Linked Field Form Options?

I’m building an event registration form in Softr, connected to Airtable. Here’s what I’m trying to do:

  • A parent logs in and sees a registration form.
  • The form includes a linked record field for selecting a child to register.
  • I want to limit the options in that form question to only show children that belong to the same household as the logged-in parent (not all children in the database).

In Airtable, each child record has a linked “Household” field, and each parent belongs to that same Household.

Is there a way to dynamically filter the linked record options based on the logged-in user’s household?

Thanks in advance!

1 Like

@nocoder I’ve been trying to do the same thing. I don’t believe it’s possible, and don’t know if it is on the roadmap. This would be a great feature not just for Airtable but for all datasource, especially Softr’s new Databases.

Have you found a workaround? Thinking of emailing a link to family members so when they click it they can join or something using URL parameters.

No, I haven’t found a work around. URL parameters might work, although I can’t speak to it as I haven’t explored that functionality in Softr yet. I imagine it will be possible in the coming months with the release of workflows, but even that will require extra work and maintenance. It would be great if it was natively built in.