Also I noted that FMGo is not working with URL with credential
when enter the URL in Safari I have a security warning page (phishing) that I have to accept before and in Chrome it go the the site.
Every day I keep bumping into other details that make it pain in the as... to do something simple and turn it into something complicated.
So that's working fine, unless employee connect to the database with is PC or Laptop at home and have the same IP range as we have at the office.
the script will think it's local and openurl with file:// command is not working as the network drive is not there.
Any other solution to find if user is local or remote.
You just need to get the right IP address. Run the "Insert from URL" script step on the client to a website like ipchicken.com and grab the IP address from there. Then you will have the correct external facing IP address, which in your office would be fixed. If it is not the same IP address as your office then you are remote.
A BIG thank you, this is perfect, we use a fixed IP in the office that will solve my problem.
I went and try to add this into my solution... once again FM can't have it easy!
Insert from URL need to have a field on the layout to insert to, then use it.
I can't use it in a "IF" calculation in a script
Maybe on the open script set a $$Variable once and use it later on calculation...
Since I'm already using ScriptMaster Plugin, there's also a function call GetURLasText
I registered the function and I can now use it in a calculation, but I can't run the plugin with FMGo... but since on mobile I always have a mobile IP, that's work fine for me.
So this is another alternative, but thank you for pointing in the right direction.
Hi, you can create a 'global' field that will hold the IP address. Your script can go to another layout, fill that field with the result from 'insert from url' and then go back to the layout you were on. From there you can use the global field in all your calculations. The user will not see the layout change if you put the 'Freeze Window' script step at the top of the script.