convertDropboxURL ( theURL )

Converts dropbox shared link URLs into Filemaker friendly URL paths that can be inserted into container fields.

Average rating: 4.5 (24 votes) Log in to vote

Kenneth Durrum - Show more from this author
Released Solutions
https://releasedsolutions.net

Sample input:

convertDropboxURL ( "https://www.dropbox.com/s/964mvf9f2i5433/DSC_0294.jpg?dl=0" )

Sample output:

https://dl.dropboxusercontnet.com/s/964mvf9f2i5433/DSC_0294.jpg?raw=1

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

/* ============================================
#
# Purpose:			To Support convert dropbox shared links into URLs that can be imported in container fields.
#					Your drop box URL must be formatted as follows (example) : https://www.dropbox.com/s/964mvf9f2i5433/DSC_0294.jpg?dl=0
#
# Arthor:				Kenneth Durrum  - Released Solutions
# Creation date:		05/30/2015
#
# Note:				Handy little tool we use it with our ecommerce website clients that utilize dropbox as a way of sending us images 
#					
#					
#
=============================================*/


Let (
	[
		URL 	= theURL 
		
	] ;
		"https://dl.dropboxusercontent.com" & 

Middle ( URL ; Position (URL ; "/" ; 1 ; 3 )  ; Position (Middle ( URL ; Position (URL ; "/" ; 1 ; 3 )  ; 1000 ) ; "?" ; 1 ; 1 )  ) & "raw=1"
)

Utilize this custom function to convert dropbox shared URLs into URLs that can be inserted into a container field. The result of the action will store the image into the database.

Comments

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

convertDropboxURL ( theURL )

Comments

Support this website.

Support this website.