If you are ok with keeping the information publicly accessible, you can create formulas based on fields to pre-fill the form. So if you have a contacts base, each record in the base (each contact) has their own generated form prefill link, so when yo...

You can show the result of a formula by pre-filling a single line text field in the form with an automation. You could use this tool Airtable App: Generate Links to Prefill Forms in conjunction with that automation to a single text field to generate ...

can’t you combine the lookups with an array formula or am I missing something? You can also look into a linked record and link the lookup. So you can get all the lookups you need in every table and combine them with a formula field

You don’t need to specify the tags, simply have 1x create record, and within there, add the value from the first step in a new tag or name field in the other table.