Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Copy a value to another attachment column from a roll up value.

Solved
Jump to Solution
146 1
cancel
Showing results for 
Search instead for 
Did you mean: 
hanstudios
4 - Data Explorer
4 - Data Explorer

the roll-up value consists of the image filename[image. jpg] and lmagelink[domain. com/image.jpg] now I want to create copy value that has an attachment-type column.

@ScottWorld and @kuovonne I'm a fan of you guys! or maybe someone knows the answer. 

Thanks!

Screenshot 2023-01-12 215640.png

1 Solution

Accepted Solutions

I found an old solution from @Florian_Verdon2 with this link https://community.airtable.com/t5/show-tell/native-url-to-attachment/td-p/116584. unfortunately, the data that I have is not a regular link which is why I used REGEX_EXTRACT({Job List Rollup (from Logo Image)}, "https.*", ")"). the result is perfect just that the URL has a close parenthesis on the last line  URL)

Screenshot 2023-01-12 232428.png

 

See Solution in Thread

1 Reply 1

I found an old solution from @Florian_Verdon2 with this link https://community.airtable.com/t5/show-tell/native-url-to-attachment/td-p/116584. unfortunately, the data that I have is not a regular link which is why I used REGEX_EXTRACT({Job List Rollup (from Logo Image)}, "https.*", ")"). the result is perfect just that the URL has a close parenthesis on the last line  URL)

Screenshot 2023-01-12 232428.png