hi, working on a sound media archival project which includes photo documentation entered into a single field with each image separated by a semi-colon. i would like to write a calculation that will allow the user to open up all "; "-separated values in separate browser windows in one go when clicking on the field label (button). i will also use the calculation to list all the URLs related to a record on separate lines in an email to the owner of the archive materials documented in the record.

is this possible? i wrote a script that goes through the values, but i am hoping to find a simpler solution, without having to have a series of If calculations on each line (there can be from 1 to over 15 photos for a single media)

"www" & LeftWords ( Photos ; 1 ) & ".jpg"
"www" & MiddleWords ( Photos ; 2 ; 1 ) & ".jpg"
"www" & MiddleWords ( Photos ; 3 ; 1 ) & ".jpg"

thanks,
jef

--

.jef.chippewa.
mailto:[EMAIL PROTECTED] | http://newmusicnotation.com/chippewa/
.shirling.&.neueweise.
mailto:[EMAIL PROTECTED] | http://newmusicnotation.com

Reply via email to