Update 2018 Sept 21, 12:10 Pacific: Bad news: While writing a companion Custom Function to handle setting values with dots chars in the keys, I realized that the technique used in these Custom Functions will break whenever there is a numeric value in the JSON which contains a decimal point. (The escaping mechanism used to
As you may know the FileMaker Server comes with a copy of apache web server software. You can use the apache web server to host and deliver files for download. So if you copy a file to /Library/FileMaker Server/HTTPServer/htdocs/ folder on your server, you can than point to that file with the URL of your server with folder and file name attached.
I am trying to access a REST web service where the keys have dots in the name. FileMaker interprets a dot in a key name to indicate a sub-element. Is there any way to escape the dot so that FileMaker treats it literally instead of as a separator? For instance, if I have JSON like this: { "value1": "Red",
I trying to get to this construction: some website handles new orders step A: when a new order is created, the website wants to send over a small chunk of data, in JSON format, to announce that a new order is available for the Filemaker db to do further stuff with it step B: after receiving the signal, Filemaker will call an endpoint on the
How to choose which one to be used? in my opinion, it's quite similar, the only difference is global field can only be used in a specific table. But if related table, that's totally same. Am I right? If i am wrong, any pros and cons when choose them?
Hi folks, Another day, another question. How can you calculate (convert) a UNIX timestamp "1537476113" to an FMP understandable timestamp without using any timezone conversion. The timestamp is from New York so I don't want to convert it to my local time here in Belgium. I tried, without success: GetAsTimestamp ( (GetAsNumber
For some reason I'm not grasping the right syntax in my SQL calculation. Here is what I have that is working fine as far as giving me a total count. ExecuteSQL ("SELECT COUNT ( DISTINCT \"RentalData\".\"SerialNumber\" ) FROM \"RentalData\"" ; "" ; "") When ever I add the WHERE statement I either get a "?" which tells me I made a
After reading so many pages about best practice for choosing a PrimaryKey...need to check if I am in a safe way What I have done until now is: a) not visible to the users b) do not use an auto-generated serial number (need to update next serial number settings and not unique throughout the database) c) numeric value (faster sorting) d) do not
