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:
- Upload the new photo into an attachment field ("Photo") using Make.
- 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?