Add dynamically attachment to send mail

[updates]

Hi,

I need to select some files and add them automatically as attachment to the email sent from the website.

I make a db table where temporary are stored the location of the files like

/files_storage/01/namefile.pdf

then I set up a mail action.

When going to add the attachments I got only the following:

Moreover, I suppose the location of the files must added as array if I am not wrong.

Any idea or procedure?

Thank you

Roberto

[s.alpaslan]

Use single query or {{query1[0].fieldname}}

[updates]

thank you… and what if I have to attach multiple files?

[s.alpaslan]

Is it seperated table for your attachments ?
You can use split and join formatters

[updates]

When I select the file, I add the location to a separated table like below:

Sincerely speaking I m not so skilled to follow your suggestion, can you please make me an example ?

[updates]

{{query1[0].fieldname}} for a single file works very well.
But if you could make me an example for multiple files would be great …
thank you
Roberto

[Hyperbytes]

You need to place the query inside a repeat to expose its contents in the picker

So

becomes

The you will see the query contents

[updates]

Dear Friends,

thank you for your help.

At the end I discovered that there is no need to have any special form. Just having the query selection only the files location and in the Send Mail action select {{query1}}

thank you to @s.alpaslan and @Hyperbytes