Okay, this is totally doable in Glide.
I don’t have time right now to describe in detail, but I’ll give you the high level steps…
- You’ll need to use a Custom Form so that you can do the “search” before the form is submitted.
- I’d recommend using a single row Helper Table to drive your form. This table should have a series of User Specific columns - one for each of your form inputs.
- Add a relation or query column to this table that targets your Global Suppliers table and filters by your matching criteria, using “This row” values from your User Specific columns
- Then create a custom submit action with two conditional branches:
– If the relation/query is empty (supplier not found), then Add a Row to your Global Suppliers table, as well as a row to your link table
– If the relation/query is not empty (supplier found), then just add a row to your link table
Hopefully that’s enough to get you started.