7 posts in this topic
I want to create a Dropdown List of numeric options to select a range of records. For example, the Dropdown list would contain:
Each option would select the next 5;10;20;50 or 100 records to the right. A Checkbox would be populated (with an X) in the selected number of contiguous records; Then, a Find Selected Checkboxes would return the selected records. The contiguous selection should be independent of whatever the current state of Found (Sorted/Unsorted) is.
Any help will be gratefully acknowledged.
By Peter Wagemans
Yesterday, I tried to move a script that creates a PDF ( and mails it ) to a server side script, as the "save records as PDF" script step is now supported in server side scripts.
It did not work correctly, and generated an error 800 (file could not be created on disk) in the server log. Rather generic error.
I changed the script to point to a blank layout instead. No more error. A nice blank PDF was created.
I put a text box with "test" in it on the layout, Arial 12 point. -> error 800
I removed the text box and put a png graphic on the layout -> OK
I put a text box in a font that I was sure of the server did not have -> OK!
I tried this several times, 2 several fonts, and the results and errors were consistent. So if during the PDF creation, the server replaces the font reference by its own replacement font reference, it is able to save as PDF. If a reference lik "Arial" is used, it fails and the server reports the generic error that it can not create the file on disk (800).
I'm using MacOS 10.12.4 as client and Window Server 2012R2 as the server. Maybe there is a cross platform issue here? As always, more testing is required.
Can anyone confirm similar issues? Any workarounds that are known? Any thoughts and insights?
I have several reports that use Google Charts displayed through a web viewer to display a "'gas gauge" type of chart. This is a very popular style for our dashboard reports to the point where it is a requirement.
I originally started using them in FileMaker 14 and they worked great. When FileMaker 15 came out they wouldn't work at first but then did after an update to the code.
I'm now testing Filemaker 16 and they're back to not working properly.
They do display on the screen just fine but if you try to print preview, print, or Send to PDF they do not show.
Does anybody have experience with this or know if a setting changed in FMPA 16 that could be causing them to not print?
FileMaker 16 introduced a collection of built-in functions for manipulating data serialized as JSON. This makes it easier for FileMaker applications to interact with many web services. This will also make JSON the de facto standard format for scripts within FileMaker to pass parameters and results to each other, improving code sharing within the FileMaker community.
JSON does not have a broad palette of scalar data types to choose from: text, number, boolean, and null. Even with those, FileMaker's JSONGetElement function always returns a text result, even when the serialized JSON value is a number or boolean. So I made a handful of custom functions and scripts for sending and receiving typed data with JSON.
The module is hosted on GitHub, or you can download it directly.
I am working on a layout that auto-populates a bunch of data from related fields. One of the fields is called district_number which has the numerical 1-12 value, depending on the district. I am trying to get a script to read the district number, then based on the value have it populate data in another field.
I started by setting the district_number as a variable, $DistrictNumber
Then I have the If statement:
If[$DistrictAddress = "01"]
Insert Text [Select;xxx::district_address_label; "District 1 P.O. Box 3700 blah blah blah"]
Else If [$DistrictAddress = "02"]
Insert Text [Select;xxx::district_address_label; "District 2 P.O. Box 3700 blah blah blah"]
Else If [$DistrictAddress = "03"]
Insert Text [Select;xxx::district_address_label; "District 3 P.O. Box 3700 blah blah blah"]
But ti doesn't work. Any help on what I am doing wrong is much appreciated!!
Thank in advance,
here is an image of how it looks