5 posts in this topic
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
By Ali A.
I have a search field, a user types his customer number in it.
I want to when a user types his customer number and press inter-script run.
how can I do this work? I use on object keystroke but when I want to type number script run and user can't type phone numbers.
how can I fix this?
I have a php script that takes two PDF files and merges them into one file. I am using this in conjunction with the insert from URL script step.
The way the script works is it takes two PDFs in container fields and base64encode each files. Then, those two base 64 strings are POSTed via insert from URL.
I've tested the script forwards and backwards and it does combine the PDF files reliably. The issue is when posting from FileMaker. What typically happens is the first page is combined twice and that's my resultant PDF.
My php script checks that both inputs are different and throws an error is they are identical. I don't get any errors there.
Is there a way to POST a file from insert from URL?
I have a number of scripts that have worked perfectly for years in previous versions of FileMaker, however in FMP 15 they causse FM to crash. They only way I have found to avoid the crash is to use the debugger and to use the "step into" button. That of course is a very cumbersome workaround. You can see one of the culprits below. Anyone have any ideas what's wrong here?
IN my db I have the following fields
IMAGE (CONTAINS 14 FRAMES FROM A MOV FILES AS A JPG FILE)
FILEPATH (TEXT FILE AS FOLLOWS: file://Data/Videos/MVI_9887.MOV)
VIDEO A Container file where I would like to see the "file://Data/Videos/MVI_9887.MOV"
In the DB I have several different records how can I create a SCRIPT AS SUCH
GO TO FIELD VIDEO
I Don't want to keep the video file in the db but only look at it when needed
The various INSERT QUICKTIME, URL and so on require me to set the actual file path for each MOVIE file and this is time consuming as I have more than 1200 records, therefore 1200 movie path to insert
Thanks a lot