Script in automation to fetch Linked Table options and select the one with given criteria

[fms]

Hi AT community,

I'm trying to get around a script (as part of a larger automation, first step being a form submission) in which I want to:

1. Grab the options available of a "link to another record" column (especially the id)

2. Cycle through the ids and see if the "Email" from the form is contained in any of the ids

3. Select all linked ids that match the condition before

Not posting any details, since I want to understand the syntax approach and then implement it myself.

Thanks!