Auto filling a linked record from a date field

[HannahS]

I need my company logo to appear in every record in a table so that I can have it appear on the sales brochure I create in extensions (unless someone can explain how to do this using the static element there but I can't find a way to attach it there).

Is there a way (possibly an automation?) to have that field auto-fill with the attachment whenever a new record is created? 

Thank you

[TheTimeSavingCo · Accepted solution]

I'd suggest having a table that contains all your attachments:

And you'd have an automation that triggers whenever a new record gets created in your main table and links it to the Logo record in the "Images" table:

Resulting in this:

Link to base

[HannahS]

fantastic, thank you so much!