Hi, i have nerver used plugin in FM but now i'm trying to apply an xsl file in a xlm. I'm searching some examples or help about this plugin.
have you ever use it?
I use it daily. What's your question?
Hi Michael, i don't know if this is the right plugin for me.
In a table there are records with the path of an xlm file. I would like to open these files in a webview using a spreadsheet (xsl file).
In this link you can download an xlm file and the xls file.
The only problem I see is with this part:
In a table there are records with the path of an xlm file.
The Base Elements plugin can read external XML files - but the supplied path must be an OS Path, not a Filemaker path - see a detailed explanation here:
Notes about File Paths – BaseElements Plugin Help Centre
Once you have the OS path, it should be pretty simple - see the attached demo file.
Thank you Michael!
Sorry, i'm here again...
I don't understand if is possible convert Windows path write in a filed (ex. \\192.168.6.1\folder\file.xlm) to a correct path for Filemaker..
If I use the button created with BE_FileSelectDialog it write the correct path (ex./Volumes/folder/file.xls), but is possible to convert it whit a script or function?
If Path contains "\\192.168.6.1\folder\file.xlm" then =
Substitute ( Path ; [ "\\\\192.168.6.1" ; "/Volumes" ] ; [ "\\" ; "/" ] )
will return "/Volumes/folder/file.xlm".
Retrieving data ...