#Filemaker pro 10 delete found records how to
#Filemaker pro 10 delete found records mac os x

(2) but that if the Find determines that no records have field pa01a 'checked', a file called 'pa01a.php' is still created and written, but that it contains the text 'There are no entries in this category at present' only once. (1) that the script writes a file containing the contents of the field calcxONELINER of every record where the field pa0a1 is 'checked' into a file called 'pa01a.php' in the same folder as the Filemaker database In this example it is assumed that all of your checkboxes use 'Y' as the actual field value that is input when the checkbox is checked if different fields have different values you would have to do something slightly more complicated. You would have to NAME each checkbox-formatted field, in layout mode, as an object (click on field, bring up object info, type a name in the Object name field of the object info window): In FileMaker 8.5 you can abstract out what you're doing so as to not have to create a large number of separate routines, one for each checkbox. To also fill in a field with 'nothing has been found', just add that Set Field script step after the one where you set the 'appropriate checkbox value'.

However, my reading of the latter is, if the 'Find' returns an empty found set, the script will move to a new record, and I don't think that's what I want. Shades of MS-DOS come back to me, and I haven't mentioned that for a long while!!). (Not sure if I've mentioned this elsewhere, but I am stringing together a large number of these scripts with a 'Run All' script containing a PerformScript line for each script, so once I've got all the scripts running nicely I can run them as a batch with a single command. So my requirement now is that if FoundCount is zero, the file called 'pa01a.php' is written with the content of gThisCategoryEmpty as its content ONCE ONLY, but if FoundCount is more than zero, the file is written with the content as before (all the contents of the found fields for all records as one file).ДЄnd, in either case, the script then ends. I can create a global field called say gThisCategoryEmpty, and type into it 'Nothing has been found', which thus appears in every record, correct? Apart from anything else, I now realize that the file I need written should not be empty but should contain some text such as 'Nothing has been found'. I understand the 'Set Error Capture ' and 'If /End If' structures.

#Filemaker pro 10 delete found records how to

What I need is (preferably) that the Cancel/Continue/Modify question isn't asked, and (definitely) that an empty file gets written if there are no records with that checkbox-field checked (thus overwriting any existing file of the same name).ДЄll my experiments to try to find out what and where to add have been unsuccessful! Instructions on how to achieve the result I need would be much appreciated. Cancel/Continue/Modify' which is reasonable since it is true!! I can get the script to continue to the end by pressing 'Continue' each time, but no file is written for those occurences. On the 5 or 6 occasions where (at present) no records have a particular checkbox-field checked, the script stops each time with a message 'No records match this set of find requests. Running that does what you would expect it to do, and I would be very happy except for the following small problem. I created (by duplicating and editing) the 40 scripts I needed according to the format you gave me, one for each of the checkbox-fields I had created, and then I made a 'Run All' script which contains 40 lines, each saying 'Perform Script. Must be a failure of logic or understanding on my part (often happens!!).Д¬ould somebody please help me to get a working script. I have tried to create a script as follows :Д«ut the 'Perform Find' step always produces a dialog saying 'There are no valid criteria in this request. (7) Export the found, sorted records into a tab-delimited file. (6) Sort the found records (to get them in alphabetical order based on a non-checkbox field) (5) Click the 'Find' button, which finds every record which has that checkbox 'checked' (4) Click one of a number of fields which have checkboxes, so that the field becomes 'checked' I can achieve the following steps 'by hand', but I want to automate them:

#Filemaker pro 10 delete found records mac os x

I am trying to write a script using Scriptmaker in FileMakerPro 8.5v1, on an Intel iMac, under Mac OS X 10.4.11.