Jump to content

Update file references of container field


haseebiqbal
 Share

This topic is 2910 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hi

My question is about moving files that are linked in a container field.

Our company has recently restaructued shared network drives.

I have moved all of the linked.pdf or linkd.doc files to new folder structure, the link in the container field still points to the old location.

 

I have created a Calculted Text field to retrieve the patch using

GetAsText ( Document container)

 formula

i.e. filewin:/G:/XXXX Syd/ARCHIVE/XXXX SHARED/XXXX ONLINE/XXXXXXscreen/XXX Clearances/Correspondence with rightsholders/XXXXXXX16102012.pdf

 

Is there a way to update the container link to the new folder location?

Should be replaced to newer path.

 

Thanks

 

FileMaker Server 10

FileMaker Client 11

Link to comment
Share on other sites

  • 2 weeks later...

Following script resolved my issue:

Update FilePath
Go to Record/Request/Page [ First ]
Loop
Set Variable [ $old; Value:GetAsText ( Table::Document container ) ]
Set Variable [ $new; Value:Substitute ( $old ; "/old folder/" ;"/new folder/" ) ]
Insert File [ Table::Document container; “$new” ][ Reference ]
Go to Record/Request/Page [ Next; Exit after last ]
End Loop
Link to comment
Share on other sites

This topic is 2910 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.