Jump to content

Search the Community

Showing results for tags 'loop'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type

Community Forums

  • The New FileMaker Platform
  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Platform
    • FileMaker Interface Features
    • FileMaker Schema & Logical Functions
    • FileMaker Go for iPad and iPhone
    • FileMaker and the Internet
    • FileMaker Pro Advanced 18
    • FileMaker Pro Advanced 17
    • Legacy FileMaker Platform Discussions
  • FileMaker Server Administration
    • FileMaker Server 18
    • Zabbix Server Monitoring
    • FileMaker Server 17
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Bar Codes (Printer, Scanners, Software)
    • Hardware & Networking
    • OS Level Database Automation
    • Product Ideas
  • JavaScript Integration
  • FMForums Affiliates & Sponsors
  • FileMaker Classifieds
  • FM Forums Operations
  • FileMaker Friday Night Chat's Topics


There are no results to display.

There are no results to display.


  • White Papers
  • Infographics
  • Samples
  • Solutions
  • FMGo
  • Plug-Ins
  • Tutorials

Product Groups

  • Workplace Innovation Platform
  • Site Advertising
  • Development & Hosting

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start







Website URL




OS Version

Found 11 results

  1. 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 their keyboards to perform a search and it's much quicker, I've adopted this method as opposed to a search button. I would like to prompt the user with a warning dialog if they press enter while inside the search field, but happen to leave the field empty. The custom dialog would tell them to type some search criteria in, instead of leaving the field empty to avoid performing a blank search. So far most of the script I came up with works, but for some reason it gets stuck in a loop during the last simple steps and I can't get out of it. I'm trying to have the following occur: - Exit the search field, and make it lose the focus. - Show a custom dialog telling the user of the error and prompting them to press "OK". - Upon pressing OK, enter the search field again and bring it into focus to set the cursor in the field so that the user can retype a correct value. The default FileMaker field validation that is found in the field's Options settings performs something very similar to what I described above. I'm trying to achieve a similar effect, but using a script instead to have more custom control and flexibility with the warning dialogs. Any help much appreciated. Custom validation - Search field.fmp12.zip
  2. 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 TVSeries::Date Show; TVSeries::Date Show +7] Go to Record/Request/Page [Next; Exit after last] End Loop Go to Record/Request/Page [First] The purpose of this script is to create and maintain a unique list of shows for each week. The previous week's shows are duplicated and the newly created week's list of shows gets modified manually. The list is printed weekly for the cable company. Problem: out of 34 records on a list layout it duplicated 25 records without a problem it skipped the 2nd, 11th, 16th, 19th, 20th, 21st, 23rd, 32nd and 33rd records there's nothing different or special about the skipped records I just can't see why it's not duplicating all 34 records. Can someone tell me what I'm missing here?
  3. 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; I managed to reach away this point: -> /Logo_ERNI.jpg;/SMCStandardkabel.jpg;/SMCStandardkabel_Z.jpg; -> /SO8.jpg;/SO8_Z.jpg; I don't know how to continue. Please let somebody help to solve this problem, if necessary, I send the partial solution. THX
  4. 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 enters a search or if the search didn't find any records matching the query? I ask this because I have some users who are extremely computer illiterate and some times the cursor is no longer in the textbox and they don't realize and they hit enter and of course it gives them the common error message.
  5. 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 button, it opens a selection window wherein I choose the tooth number from said field (1-32), the material the crown is to be made of (porcelain, gold, zirconia, etc.), whether I want to use lab-processed temporary crowns, and so forth. If I have only one tooth number checked and run through my nested IF statements, which looks up the official description for the type of crown, the ADA code, the fee, the time required, etc., it all works fine. If I have more than one tooth number selected in the checkbox set, it only returns one line for the first tooth checked. The IF statement looks something like: If TOOTH NUMBER = 2 and CROWN MATERIAL = porcelain and LAB TEMP CROWN = "Yes" then it adds a line on the treatment items table which looks up appropriate description, ADA code and fee, so the patient has a copy and so do we. And we're both on the same page regarding what they want to accomplish. Am I using the wrong method for displaying and relating my selections? If so, what's the best way to accomplish this. Also, I want to avoid repeating the same sequence for each tooth number, i.e., I'd rather LOOP to advance through tooth 1 through 32. Any ideas?
  6. 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 Date1 until Date1 is higher than Date2 I have tries and testes let function and loop, if any one could help Many Thanks Meir
  7. 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; Value: ValueListItems (Get (FileName); "Quarter") Set Variable [$count; ValueCount ($quarters)] New Record/Request Set Field [Program::ProgramQuarter; GetValue ($quarters; $i)] The field ProgramQuarter is not being set to any value....
  8. 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.  To give more detail - I have a customer table. Each customer has a room(table), and each room has a ScopeSheet(another table. The scope sheet is basically a form with a bunch of checkbox fields. These scope forms are filled out, one for each room. All these tables are related through relationships with keys.  What I want to do essentially, is go through each field in the scope sheet for a room, see if the field was changed (or if it equals 1) and if it was, put it on a report.  As I have been going through the FTS, my approach to the above has been this:  Set up a new table called "Changed Fields" with a foreign key linked to the Scope form. So that each scope form can have one report, but a report can have come from multiple scope forms.  Set up a new script - the script it launched from a layout that is linked to the customer table.  You can see the script attached, but basically my idea was:   save the primary key of the scopeOfWork record into a variable  go-to my Report Layout - linked to Changed Fields table "currently called scope report" Loop (currently set to 10 for deubbing purposes) through the fields of my scopeOfWork Record if the field is empty, go to the next field Otherwise add a new record to the scope-report table - keeping the name from the field in the Scope Of Work  I am just completely lost on how to finalize this. My main points of confusion are this:  Am I even on the right track with how to go about this? Is there a way simpler option? After I create the new record over on my ScopeReport, how can I get back to the same spot where I was on my other table? How can I even make sure I am going back to the same record of that same table - and then get to the next field from where I left off? When it comes to "Navigation and Context" I am just lost. I understand that the current layout is what sets what table you are working with. But I have a hard time connecting which record I am working with when designing a script. How to know if I have the right record "selected" and how to get back to that record, etc. Its all just a bit confusing to me I guess.  I know this is a complicated question so anyone who is willing to try and help me get on the right path I REALLY appreciate any help you can provide. Thanks.
  9. 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 ; filterText ) twice to filter table content and get field 3 as a result. Any ideas? Thanks!
  10. 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+1] Exit Loop If [$i > $supplierCount] New Record/Request Set Field [Month::Month; $month] Set Field [Month::fk_Supplier; GetValue ($suppliers ; $i )] End Loop When I run it, however, it creates zero New Records within my "Month" database. I'm not sure what the issue is. My only hunch is that the List function isn't properly creating a List of the "Suppliers::UUID" field, and is causing the ValueCount taken of it to return 0. Please let me know of any additional information I can provide, and thank you in advance for any assistance you can offer!
  11. 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 the quantities for each of the items in the portal, rather than updating one and moving to the next. what step am i missing? Thanks!
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.