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.
Juggernaut

Need help with exporting using Get(DesktopPath)

Featured Replies

Howdy, all:

I know this topic was covered elsewhere (for FM 6), but this has a different twist on it and is needed for an FMP v10.x. runtime, so my apologies if it seems like a dupe.

I'm having a little trouble phrasing a script step so the records exported from a file (alpha.fp7) always ends up on the end user's desktop. I've attached a .jpg of the Output File Path List but don't know how to phrase the statement that goes in the box. I tried plugging in Get(DesktopPath) but FMP just laughed at me. What should I use using the Windows platform?

TIA for your help!

Rich

export.jpg

You need to set a $var to the path, then enter $var in the Output File Path dialog.

Set $exportPath to "file:" & Get (DesktopPath) & "filename.ext"

where "filename.ext" can be a field value and so it wouldn't be in quotes.

  • Author

Ah. Thanks! I've attached a .png of the coding so others may benefit from your help; I hope you don't mind.

export.png

Edited by Guest

[color:brown]I am somewhat confused by what is going on with your solution. Can you elaborate? Thanks.

You need to set a $var to the path, then enter $var in the Output File Path dialog. [color:red]This seems straight forward.

Set $exportPath to "file:" & Get (DesktopPath) & "filename.ext"

[color:red]Where did the variable [color:blue]$exportPath [color:red]come from?

where "filename.ext" can be a field value and so it wouldn't be in quotes.

Sorry, Ron. Rather than a non-descript name for the $var, I named it $exportPath.

So, you set $exportPath to "file:" & Get (DesktopPath) & filename

Sorry, Ron. Rather than a non-descript name for the $var, I named it $exportPath.

So, you set $exportPath to "file:" & Get (DesktopPath) & filename

So, are you saying that $exportPath and $Var are the same?

Yes. I use $var to stand for local variable.

It works great. Thank you for your clarification.

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.