I am getting fustrated with an issue i am having during development. as i name the filenames different during each stage as to allow me to return when i f#$K up . Sorry, Make a typographical error.
However in a html address lookup i want to insert the filename. which i have set as a $Variable as well as a field.
var uri = 'fmp://$/<<FileName>>.fmp12?script=(0923) Private.GoogleSearchResult';
Is there a way to insert it into this line of code?
If that's supposed to be the current file's name, why not simply use the Get( FileName) function?
--
P.S. You'll probably want to wrap it in GetAsURLEncoded(), too.
Because I can't insert that function into the middle of the var uri. I already have the filename but need to insert it into the middle of a Java script.
<script type="text/javascript">
function storeData() {
// Set up base URI. You need to modify host-ip, database name and script name
var uri = 'fmp://$/get(Filename).fmp12?script=(0923) Private.GoogleSearchResult';
// Add form fields as parameters to the URI. These will be $variables in your filemaker script
uri = uri + getParameter('street_number');
uri = uri + getParameter('route');
I am afraid you have lost me. Where exactly is this code? Is it in a FileMaker field? Or are you constructing this in a calculation window? And where/how it will be executed?
This is how I do it:
**FileName** in the JS code is substituted via a calculation field or the web viewer calc dialog with the actual file name.
IN my calc field:
Substitute (HTML::JSFunction ; "**FileName**" ; Get(FileName) )
Sorry Michael,
I have used an addon kit to allow users to lookup the correct address and have it formatted correctly and insert into the filemaker project.
The Kit uses google API via a javascript addon in an HTML field.
Thanks Jeremy but how ti i do it for 2 fields as already doing it for the APIKEY
Substitute ( TO_02____PREFERENCES | MODULE MAP::html ; "<<APIKEY>>" ; TO_02____PREFERENCES | MODULE MAP::APIKey )
Did think of trying to do it this way until about 5 minutes after i posted question and tried a few different things but nothing worked.
Actually i have sorted it out.
Re reading the Manual said can be done using [ ] for each substitution.
Substitute ( TO_02____PREFERENCES | MODULE MAP::html ; [ "<<APIKEY>>" ; TO_02____PREFERENCES | MODULE MAP::APIKey];[ "<<FileName>>" ; TO_02____PREFERENCES | MODULE MAP::FileName] )
You can easily do many substitutes in a single function call:
Substitute (
HTML::JSFunction ;
[ "**FileName**" ; Get(FileName)] ;
[ "<<APIKEY>>" ; TO_02____PREFERENCES | MODULE MAP::APIKey ]
)
You can find more details on how to use Substitute in Help: FileMaker Pro 17 Advanced Help
You got it!
This is my full calc for the work I've done with Web viewer integration stuff
yes thanks, David, had to read the manual a few times to actually see it correctly, hate it how mind jumps to conclusions without reading things in full.
And Jeremy, you nudged me in the right direction to look a bit harder. allowed me to figure it out myself with some guidance.
For reasons of readability more than anything else, I've started to try and "declare" all the placeholders as variables at the top of the JS.
That way, the FileMaker "funny stuff" is all in one place, and I can easily find all my placeholders.
So
var fileMakerFileName = fileMakerFileName ;
var mapAPIKey = mapAPIKey ;
and then the reference to the FileMaker file names etc are simply references to JS variables throughout the rest of the document.
Sure.
But the set up I did now 3 years ago is still very readable.
Now that I'm better at JS, I do the same. Just haven't updated all the work I did from 3 years ago.
Yep, basically the same thing here! Though I'm just less bad at JavaScript, not yet better ;-)
Jeremy, it looks like you have created a cheat sheet for these type of functions. great Idea. Think i need to do something along those lines myself.
I am a very newbie, although played with fm11 and fmp12 when there came out only now getting back into it as finding more of a use for it and ability to achieve what I want.
Hence why i have 100 and 1 questions on basic stuff.
Ask away.
Check out the file I took a screenshot of: ADV004 - Web Viewer Integrations - Jeremy Brown
Also you may want to explore: The FileMaker WebViewer Bridge.
These will give you 5483 more questions.
You can easily do many substitutes in a single function call:
Substitute (
HTML::JSFunction ;
[ "**FileName**" ; Get(FileName)] ;
[ "<<APIKEY>>" ; TO_02____PREFERENCES | MODULE MAP::APIKey ]
)
You can find more details on how to use Substitute in Help: FileMaker Pro 17 Advanced Help