How to avoid multiple attachments with same file name

[Kai_Muscher]

Dear Community,

I hope someone can help me with the following issue...

I have an automation sending out an email for a record ("shipment" table) with attachments.

The attachment(s) come by lookup from my "inventory" table.

Now, as some inventory items may have the same attachment (eg. an invoice covering several inventory items/lines) I consequently get several same attachments pulled to the "shipment".

How can I tell airtable or my automation to ignore files with same filename when sending out email for a record ("shipment" table) with attachments.

It's hard to explain, but I hope someone will see my issue. 🙂

Kai

[Kai_Muscher]

Dera Lom,

at a first glance this is exactly what we I need. If that works as described then we are golden!!! Let me have a closer look ... :excited: ...

K

[Kai_Muscher]

Okay, in principle the script does what it should do: it creates the unique attachment(s) in a separate attachment field. So far so good. Opening up the field and view the unique attachments online with the Airtable viewer is okay, BUT the created files come without file extension, eg. ".pdf", and that's causing inconvenience when attaching to an email by automation. I guess you see what I mean. May you amend the script to keep the initial file extensions?

Thanks a million!

K

[Lom_Labs · Accepted solution]

Hello @Kai_Muscher! Thank you for your purchase and your invaluable feedback!!

The script has been amended to keep the initial file extensions as you requested. Please regenerate your script so that you have the new functionality! You can do so here: https://www.lomlabs.io/airtable/scripts/unique-attachments

Thank you for your support and let me know there is anything else I can help you with 🙂

[Kai_Muscher]

Hi! That's it. Thank you so much!

Just one little thing: is it possible that I cannot run the script and send out the email with attachments within the same automation? It indeed creates the uniqueAttachements but somehow same are not attached to the email which is being generated by 2nd action, right after the script being executed. If I run a separate automation to generate the email with attachments then everything is fine as it looks like.

Automation looks like this:

TRIGGER: When a button is clicked

Action#1: Run a script

Action#2: Outlook - send an email with attachment(s)

Action#3: Update record

Best regards,

K

[Lom_Labs]

Hello @Kai_Muscher ! Please add a Find record action that looks for your original record below the Run a script action and then utilise the record data from that Find record action in your Outlook - send an email with attachment(s) action!  

New automation:

TRIGGER: When a button is clicked

Action#1: Run a script

Action#2: Find record

Action#3: Outlook - send an email with attachment(s) utilising the record data from the Find record action

Action#4: Update record