Skip to main content
Solved

Automate replacing attachment and moving old attachment to a different field

S

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?

Best answer by TheTimeSavingCo

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!

View original
Did this topic help you find an answer to your question?

4 replies

TheTimeSavingCo
Forum|alt.badge.img+18

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!

Adam, Consultant @ The Time Saving Co
S
  • seanwhitcomb
  • Author
  • Participating Frequently
  • 5 replies
  • July 20, 2023
TheTimeSavingCo wrote:

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?

TheTimeSavingCo
Forum|alt.badge.img+18
seanwhitcomb wrote:

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

Adam, Consultant @ The Time Saving Co
S
  • seanwhitcomb
  • Author
  • Participating Frequently
  • 5 replies
  • July 23, 2023
TheTimeSavingCo wrote:

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


That worked. Thanks!

Reply


Most helpful members this week

Terms & Conditions