How to copy an image from a photo field to the images_db table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2024 01:42 PM - edited 06-15-2024 07:10 PM
Hi,
Im trying to copy photo files of images that we get from a record producer
Im trying to use in flow designer to get the photo images from the sys_attachment then,
We want to create a new record in the images_db table from the photos to then get a public URL to save back to my custom field.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2024 11:00 PM
I found a way to update the Images in Flow Designer.
After all of yesterday and today trying to figure it out. If you change the Table in sys_attachment to ZZ_YYdb_image the images are now available without Authentication.
However, here is the Flow that I came up with to copy the image from the original record, Regex the Image name to remove the .iix, then create the image record. lookup and copy the attachment, the update the record attachment name and info and finally update the URL on the Wheels record with new public facing URL.
note: the image field only needs the sysID of the image from sys_attachment, but dragging the datapils by itself does not work. you will need to assign it to a variable and use Regex replace like \.iix$ and this should let you link up the image in Flow Designer. Very good learning experience.