Select multiple products in embedded view to ask for details

[Robert_Matysze2]

Hello,

I have an embedded database of products and each product has a button and form to ask for more details. It’s using and sends an email to a specific account manager and cc to the client.

it works well but customers can ask about one product each time. How to select multiple products and ask for them?

Each product might have a different account manager - email.

How can i achieve that?

[Databaser]

Hi @Robert_Matyszewski

How is your base set up? A table with your products and a separate one for the incoming forms?

[Robert_Matysze2]

Yes, exactly separate tables in one airtable base
products
companies
requests

So is this possible? @Databaser ?

[Databaser]

First thought: make a linked record field between your “products” and “requests” base. That way, they can select multiple products via the form if you add that field (which is in the “requests” table I imagine). The e-mails to the managers could then be done via the automations (eg via the “find” action).

So they click on the button in 1 record to open the form and then can select some more. The product they clicked on could be already filled via a prefill.