Automate replacing attachment and moving old attachment to a different field

[seanwhitcomb]

I will be using Make to update a table with information gathered in the field. This includes new photos of assets. There should be only one photo in the attachment field, with all old photos stored in a separate field. I don't want to just replace the original attachment, as these photos are still needed. I want to be able to do the following:

1. Upload the new photo into an attachment field ("Photo") using Make.
2. Once the photo is uploaded, the previous attachment is moved to the "Old Photos" field. This field can have more than one photo stored in it.

Is there a way to achieve this using scripting or some other tool?

[TheTimeSavingCo · Accepted solution]

Hm, if you have three attachment fields:
1. New Photos
2. Photo
3. Old Photos

Then you could use Make to put the new photos into "New Photos", and have an automation that'll trigger whenever "New Photos" is not empty.  It'd then run an "Update Record" action to update the triggering record:
1. Add the current attachments in "Photos" into "Old Photos"
2. Put the current attachments in "New Photos" into "Photos"
3. Clear the "New Photos" field

Works in theory!

[seanwhitcomb]

That does seem like a good solution, but it would require scripting, correct? Do you know what that script would look like?

[TheTimeSavingCo]

Nope, wouldn't need a script, just an "Update Record" action

[seanwhitcomb]

That worked. Thanks!