Save the date! Join us on October 16 for our Product Ops launch event. Register here.
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:
Is there a way to achieve this using scripting or some other tool?
Solved! Go to Solution.
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!
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!
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?
Jul 20, 2023 10:12 PM
Nope, wouldn't need a script, just an "Update Record" action
Jul 23, 2023 09:15 AM
That worked. Thanks!