Search the Community
Showing results for tags 'loop'.
Found 15 results
-
Hi, fmforums team, I have an xml with two components: Descriptor and Substance. One Descriptor can contain many substances, yet, when I import using the Substance.xsl, it imports only the first substance for each Descriptor. How do I tell the .xsl to import the substances recursively? I'm...
-
Hi FMForums, I import one PubMed XML nine times, each time with a different XSL file, in order to capture all of the available content into it's corresponding fields and tables. Yet, it's very tedious to run nine imports. I'm thinking that perhaps there's a way of telling FileMaker which XML is... -
Hello! I need help with a script with looping to evaluate and mark records. I have four fields: Name_Global, NameA, NameB and Tag. I want to have a result in a field: Tag that is true when either NameA or NameB is a match with Name_Global, but not when that same condition is in the following record(... -
I am attempting to use the following script in a Database: Set Variable [$supplierCount; Value: ValueCount ( List ( Suppliers::UUID ) )] Set Variable [$month; Value: MonthName ( Get ( CurrentDate ) )] Set Variable [$suppliers; Value: List ( Suppliers::UUID )] Loop Set Variable [$i; Value:... -
I have a Value List "Quarter" with values: "Summer" "Fall" "Winter" "Spring" I planned to loop through these values and assign to a field using the various posts in the forum, but in testing the basic steps it's not working: Set Variable [$i; Value: 1] Set Variable [$quarters;...
-
I'm a dentist. I'm trying to generate written treatment plans for patients to have as a treatment estimate and for our records. People have 32 teeth, therefore I have setup a field (ToothNumber), displayed as a checkbox set utilizing a value list = 1 through 32. When I click my CROWN script but... -
Hi I have lot of simple comma separated text string than this here: -> Logo_ERNI;SMCStandardkabel;SMCStandardkabel_Z; -> SO8;SO8_Z; And I would like to convert to this: -> /L/o/Logo_ERNI.jpg;/S/M/SMCStandardkabel.jpg;/S/M/SMCStandardkabel_Z.jpg; -> /S/O/SO8.jpg;/S/O/SO8_Z.jpg;...
-
My cable company asked me to track programming to troubleshoot a problem. I have a single table file with just 29 fields and two very simple custom scripts. The "loopy" script that's a problem: Go to Record/Request/Page [First] Loop Duplicate Record/Request Insert Calculated Result [select TV...
-
pc Function with a loop, please help
gabbaymeir89 posted a topic in Script Workspace and Script Triggers
Hi im still a bit of a beginner with filemaker i have been trying to figure this out but need a little help. I have this function If (GetAsDate ( Date1) - GetAsDate ( Date2 ) < 0 ; Date1 + 28 ; Date1 ) What i need is to turn it in to a loop so that 28 is added to Date... -
Hello everyone again... and let me just start off by saying how HELPFUL this forum is!!! I have a form which has a OnLayoutEnter script which does as follows: Enters Find mode Show Custom Dialog box Performs find Is there a way I can loop the custom dialog box until the user actually ente...
-
in filemaker, i have a purchase order table that has a portal with items listed. i want to update the inventory table with the number of items on order for each item in the portal. i tried using a loop that ends with Go to Portal Row [select;Next;Exit after last], but the loop continually updates th... -
Hello,  I am new to FMP and learning the script steps. What I am looking to do is go through each field in one of my tables and if it equals 1 then I want to add a record to a seperate table and copy over some data. Most of these fields are checkboxes, so making them equal 1 was easy enough....
-
Greetings, I have a global field that is acting as a search bar to perform a find with the data stored in it. I have set an OnObjectKeystroke script trigger to the field to activate a script if the user presses the enter key while inside the field. Since most users are used to hitting enter on t...
-
Hi, Could someone help me with creating calculated field which filter my table twice and then take specific value as value for field for example: for ( field 1 = 1) for ( field 2 = 2) use field 3 How to create for loop in filemaker so i can nested Filter ( textToFilter ; filter...
-
If you have spent any time developing in FileMaker, or programming in almost any language, you will be familiar with the concept of a loop. When scripting your loops you probably have a favorite method that you use. This article presents and compares a number of looping techniques that can be used...
