Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Automate replacing attachment and moving old attachment to a different field

Solved
Jump to Solution
1213 4
cancel
Showing results for 
Search instead for 
Did you mean: 
seanwhitcomb
4 - Data Explorer
4 - Data Explorer

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?

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

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!

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

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!

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

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

That worked. Thanks!