Hi jef
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"
You might transform the ";" separated list into a paragraph separated
list using a calc like
Substitute (theField ; ";" "<paragragh symbol here>" )
To open a URL for each picture use a script like
Set Variable ($list ; Substitute (theField ; ";" "<paragragh symbol
here>" ) )
Loop
Open URL ("www." & Getvalue ($list ; 1 ) & ".jpg" )
Set Variable ($list ; MiddleValues ( $list ; 2 ; 9999 ) )
ExitLoop If (ValueCount ( $list ) < 1 )
EndLoop
HTH
Ciao
G. Pupita
Certified FileMaker 8 Developer
FileMaker Business Alliance
