GetDownloadsPath

Calculates the system download folder by modifying the document folder path.

Average rating: 4.8 (25 votes) Log in to vote

Mike Beargie - Show more from this author
MainSpring, Inc.
http://www.gomainspring.com

Sample input:

GetDownloadsPath

Sample output:

/SSD/Users/username/Downloads/

Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

Let([
  docpath = Get ( DocumentsPath ) ;
  c1 = If ( Right ( docpath ; 1 ) = "/" ; 1 ; 0 ) ;
  slashcount = PatternCount ( docpath ; "/" ) ;
  adj1 = If ( c1 = 1 ; Position ( docpath ; "/" ; 1 ; slashcount - 1 ) ; Position ( docpath ; "/" ; 1 ; slashcount ) ) ;
  trim = Left ( docpath ; adj1 - 1 )
];
  Case (
      c1 = 1 ; trim & "/Downloads/" ;
      c1 = 0 ; trim & "/Downloads" ;
      "0"
      )
)

JBante tweeted a request that there be a native Get(DownloadsPath) function. In the meantime I figure I'd toss this together as a way to calculate the path. This will probably need updated for things like iOS and such, but the jist of it is to take the documents path, slice off the "Documents" part of the name and append "Downloads" in it's place.

I could see this being expanded to use get(systemversion) and get(systemplatform) as well to account for differences in windows file paths and for iOS. But for now, at least in the most recent OS versions, this functions appropriately.

Comments

		Adam Glick, HelpDesk, Inc. Aug 17, 2015
nifty and handy. thanks! using this to dump exported container files to the logged-in user's downloads folder and automatically view them.

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

GetDownloadsPath

Comments

Support this website.

Support this website.