- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 19, 2023 04:55 PM
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?
Solved! Go to Solution.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 19, 2023 08:14 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 19, 2023 08:14 PM
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!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 20, 2023 09:08 AM
That does seem like a good solution, but it would require scripting, correct? Do you know what that script would look like?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 20, 2023 10:12 PM
Nope, wouldn't need a script, just an "Update Record" action
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jul 23, 2023 09:15 AM
That worked. Thanks!