grab a files path

[grumbachr]

I'm trying to insert a picture into a container (which works) at the same time grab its path and store it in another field.

here is my script it works for inserting the picture but only inserts the path to the filemaker db file.

Go to Field [table::container_field]

Insert Picture [Reference]

set Variable [$$Location; Value:Get (FilePath)]

Insert Calculated Results [select; table:text_field; $$Location]

Any advice is greatly appreciated.

[AudioFreak]

Make a Calculated field and use

GetAsText(container_field)

Michael

[Raybaudi]

Go to Field [table::container_field]

Insert Picture [Reference]

Set Field [table::text_field ; GetValue ( table::container_field ; 3 ) ]

[grumbachr]

now how can i stripe off the beginning of the path. all files will be stored on a server so i don't need the "imagemac" and whatever the equivalent will be on the PC.