I have a database, which has two printable forms. One has been designed in portrait, and the other in landscape. Both of them are only ever printed using buttons tied to script steps, never manually. I was hoping that there would be some way to specify orientation via the script. However, after some poking around of my own and light Google searching I am thinking this may not be so easy.
I am able to go into Print setup to change the orientation just fine, however this sets it for the entire database which is not all around helpful. While specifying the options in the print step, I am able to change orientation. For some reason though, this changes the default orientation across the entire database. Not even while running the script, but just specifying it in the options of the script step. So now I'm at a loss.
If this is not able to be done, redesigning one of the forms wouldn't be that difficult. But if there's a way to do what I'm trying to do, any assistance would be greatly appreciated!
I currently have a form that contains a portal. In the portal there is a value that will either be "Accepted" or "Rejected". I'm wondering if there's a way to parse through this table to check if any related values have a "Rejected" or if they are all "Accepted". Then using that outcome, decide if the form should display Rejected or Accepted.
Please let me know if I need to provide any more information and/or images.
Thanks in advance for any assistance you can offer!
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.
My end goal is to have a button that, when clicked:
1. Opens a pdf form from my server
2. Fills in the form using data entered into FileMaker (I'm using FileMaker 10)
I'm on step one and and trying to use the "Open File" script, however it's not working. Can the "Open File" script be used to open non-Filemaker files, such as PDFs?
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.