Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Export Field Contents for Found Set

Featured Replies

  • Newbies

I am having trouble with a script. I have a layout that has a container field. I use the container field to reference to resumes located on a server. I want to be able to take a found set and export the resumes for each record. Ultimately I want to attach said resumes to a new email in OS X Mail client.

I want to at least be able to export the resumes to a set folder. Which I can then automate further.

At this point I can export only one record at a time.

One record at a time it needs to be - but you can have a script loop among the found records and do it for you. See here:

http://www.fmforums.com/forum/showtopic.php?tid/179603/post/218603/#218603

Note that since you only want the found set, you should leave out the first step that shows all records.

  • Author
  • Newbies

That script appears to rename each file. Is there a way to keep the current filenames?

I could reference a name on the corresponding record but some of the files differ in extension. Some are .docs, .txt, and .pdf

You can get the file name and extension from the container field. If your files were inserted as 'file, reference only', the calculation GetAsText ( ContainerField ) will return the file's relative and absolute paths. To extract the file name and extension and append it to the desired path, you could use something like this (untested!):)

Let ( [

paths = GetAsText ( YourContainerField ) ;

len = Length ( paths ) ;

fileName = Right ( paths ; len - Position ( paths ; "/" ; len ; - 1 ) )

] ;

"filemac:" & Get ( DesktopPath ) & "ExportedFolder/" & fileName

)

  • Author
  • Newbies

Unfortunately I am unable to understand the scripts. From what I can tell I need to use both but i'm not sure how

I am not sure what you mean by "both". There is only "one" in my post here, and it's not a script: it's a calculation. You would use that in the SetVariable[] script step to calculate the desired value of $filePath.

Create an account or sign in to comment

Important Information

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

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.