Jump to content

Search the Community

Showing results for tags 'set variable'.

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 6 results

  1. Hi , I am really new to FMP 13 I wonder if someone can help me to figure how to put the TEXT in a Layout like in the picture I attached, by SET VARIABLE. I want to put it appear on the screen (print text on layout).  Can I make a script single script to get all those data or I need to make every single variable ?  Please help my seniors. Â
  2. Hi. I seem to find variating answers to this topic, so here I try again. How do I use a variable to perform a find in a script? I want to use the field contents of the current record to search for similar records. Background: We send a lot of people out to different countries and I want to make a script that makes an excel sheet with various data based on the country field of the current record. Hence, if the current record is going to France, I want to see everybody that we currently have in France etc. However, we have two return dates so I need to do two searches: 1. Country+ departure date <=// + arrival date >=// 2. Country+ departure date <=// + Extended arrival date >=// Is it really true that perform find cannot handle a variable? Hope you can help.
  3. Hi I am trying to use Set Variable to capture a date. Then I want to take that date, add one day to it and perform a find for a date range. My script looks like this Set Variable [$$Inv_date; Value:Inventory_Date::LastUpdate] Enter Find Mode Set Field [Date; ($$Inv_date)+1 &"..."& g_search_date] Perform Find It works some of the time but not consistently and I think the problem is that when I defined the variable it says "calculation result must be text" How do I get it to say "calculation result must be date"? Thanks in advance
  4. When I set a variable this way: Set Variable [$StudentIDs = ""] the actual value of $StudentIDs is 0, not empty or blank. So it fails the IsEmpty test. Is this by design, it is a bug or am I doing something stupid? - Brad
  5. Aloha All, DISCLAMER I'm not a programmer nor a technical writer and also is ESL. So my writing is tailored to me or someone like me aka noobie as F* (toward me not you). Detail and step by step and as clear as possible. Please let me know if i’d missed something or grammar correction. System: As of 04-20-2016 (not potting around) macOS 10.11.4 (yeah I’m using macOS name form now on instead of OS X), iOS 9.3.1, Filemaker Pro Advance 14.0.5 and GO 14.0.4 OBJECTIVE Make merge variable to show the slide control panel's object name (the name of the front most slide panel). So when the file is open the merge variable will show the name of the from most slide control panel letting you know which slide you're on. ISSUE Merge Variable does not show value on open first window. Please read entirety below. WORKAROUND Although it's a lame hack that I prefer not to use but it does the job. I'd included these two ugly steps in the script Go To Object [ Object Name: "Panel2" ] then Go To Object [ Object Name: "Panel1" ] to have the merge variable show Panel1 name on opening of the file. # the number symbol or the hashtag is to comment as a note to yourself and others about the script line(s) (ignored when the scrip is performed functional line). Set Variable [ $$panelName; Value:GetValue ( Get ( TriggerTargetPanel ) ; 2 ) ] #The "2" is the result value which is the name of the objectName that you gave it in the inspector panel. Number "1" will return the number of the panel. As in 1 (which is the first) of 3 panels or 2 (which is the second) of 3 panels or 3 (which is the third) of the 3 panels. Go to Object [ Object Name: "Panel2" ] Go to Object [ Object Name: "Panel1" ] #Refresh Window will work the same but I think it'll refresh the whole layout. FYI: "MVpanelName" is the object name of the merge variable "<<$$panelName>>." Refresh Object [ Object Name: "MVpanelName" ] ENTIRE HOW TO Create a new file. Choose File menu > New Solution… https://www.filemaker.com/help/14/fmp/en/html/create_db.8.5.html Enter Layout Mode. Choose View menu > Layout Mode or press COMMAND + L keys. https://www.filemaker.com/help/14/fmp/en/html/fmp_basics.3.7.html Insert Slide Control. Choose Insert menu > Slide Control https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.42.html Name the each slide panel. Choose View menu > Inspector or press the COMMAND + I keys. Choose Position tab > Enter Name field. Press the Enter/Return key to commit the name to the object. http://help.filemaker.com/app/answers/detail/a_id/6147/~/naming-objects-in-filemaker-8.5-and-later Choose the next slide and repeat. Create a script with the above script. Choose Scripts menu > Script Workspace… Type or copy and paste the script in the code box above in the the WORKAROUND section of this post. https://www.filemaker.com/help/14/fmp/en/html/create_script.14.3.html Choose Insert menu > Merge Variable. Name it the EXACT same as the name use in Set Variable objectName ($$panelName). https://www.filemaker.com/help/14/fmp/en/html/create_layout.9.35.html#1064499 Set File Script Triggers. (not a 100% sure this is needed) Choose File menu > File Options... Choose Script Triggers tab > click checkbox OnFirstWindowOpen > click Select button > choose your script > click OK button > click OK button. Set Layout Script Triggers. (not a 100% sure this is needed) Choose Layouts menu > Layout Setup... Choose Script Triggers tab > click checkbox OnLayoutEnter > click Select button > choose your script > click OK button > click OK button. Set Object (slide control) Script Triggers. (this is a must) Right click on the Slide Control Panel object > select Set Script Triggers... Click checkbox OnPanelSwitch > click Select button > choose your script > click OK button > click OK button. Enter Browse mode. Choose View menu > Browse or press the COMMAND + B keys. SEEKING HELP Please reply if you have a better solution to this terrible workaround. Mahalo All!
  6. I once remember reading that it is unreliable practice to use Copy / Paste in scripts. I have a looping script that copies data from one table and paste it in another as it as it creates 150-200 new records. I notice that here and there, a few records are missing their pasted data. Should I replace 'Copy' with 'Set Variable' (Using only one $ for that script?) and should I replace all the 'Paste's with 'Set Field'? Or is there a more reliable way to do this? Thanks so much and a very happy new year to you!
  • Create New...

Important Information

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