Jump to content

Search the Community

Showing results for tags 'variable'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Claris Engage Vendor Discounts

Community Forums

  • The New Claris 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 19
    • FileMaker Pro 18 Advanced
  • FileMaker Server Administration
    • FileMaker Server 19
    • FileMaker Server 19 (Linux)
    • FileMaker Cloud
    • FileMaker Custom SSL Certificates
    • oAuth and External Server Authentication
    • Zabbix Server Monitoring
    • Previous Version Server Discussions
  • JavaScript Integration
    • Java Script and the Web Viewer
    • Carafe.FM
    • Widget Studio
  • Brain Food
    • Security Concepts
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • Hardware & Networking
    • Product Ideas
  • FMForums Affiliates & Sponsors
    • Productive Computing Support Forums
    • 360 Works Official Product Support Forums
    • Geist Interactive Product Support Forums
    • FileMaker Vendors
    • FileMaker Training Resources
  • FileMaker Classifieds
    • Announcements of FileMaker Product, Services or Resources
    • Classifieds
    • Tools Of The Trade
  • FM Forums Operations
    • FM Forums Feedback & Site News
  • FileMaker Friday Night Chat's Topics


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • 1-more-blog
  • Productive Computing
  • Geist Interactive
  • Soliant Consulting


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

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

  1. I'm surte this is quite a simple task ... for someone expert I see I can export Record content using a Variable as the new filename for the exported file. I have more than 1200 records in my db and I hope to export 3 fields using one [fieldname: Title] as a filename. The path for my db is as follows file:/Macintosh HD/Users/Claudio/Documents/Synch Test Copy Copy.fmp12 Thanks a lot
  2. 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 o
  3. I am trying to create a button that deploys a script that opens a corresponding server folder based on the value in a particular field of the current record card. Here is what I have so far, but I can't figure out why it is not working: Set Variable [ $jobno ; Value: Project File Server Locations::_4_digit_Job_No. ] If [ $jobno ≤ "100" ] Perform AppleScript [ "tell application "Finder" activate make new Finder window set target of Finder window 1 to folder "Projects 0001 - 0100" of disk "TRG Projects" end tell" ] Else If [ "100" < $jobno ≤ "200" ] Perform
  4. Hi, I have a field called 'mytournament1'. I also have a field called 'mytournament1played'. With a form, I create the variable $tournament to bring 'mytournament1' to my results page. $tournament = $_GET['tournament']; I'd like to force the results page to search for the field 'mytournament1played' for each record by using the variable $tournament and combining the word 'played' or the variable $played. $played = 'played'; $tournamentplayed = $tournament . $played; $tournamentplayed2 = $record->getField('$tournamentplayed'); (I want it to deliver) $re
  5. Hi All, I can never seem to get my head around file paths and even more so when we need to use variables. Can any of you help me with the following please? What I have is an inventory system that has been adapted from the starter solutions, I have created a new field called colour. I have a folder system set up with lots of different colour folders i.e. black, blue, yellow etc... I would like to add a button that performs a script that goes to the correct colour folder so that I can select the correct part. The folder path containing these colours would be "/Users/USERNAME/
  6. I am using a custom function to format a number into currency format ( two decimals ). RoundDecimals(11.0) = 11.00 The problems occurs when I use a variable: $amount = 11.0 RoundDecimals($amount) = 11.11 Similarly, I get the same error using a string: RoundDecimals("11.0") = 11.11 Is there any tricks to get around this issue ? This is the custom function that I used (I replaced the comma for a dot and defaulted second parameter to 2): https://www.briandunning.com/cf/974
  7. I am sure this is one of those simple ones… that has me bamboozled for nearly 2 days now. I need to limit access of my users viewing only a limited set of "Company" records after they log in. The companies that they are allowed to see are listed in each respective user's profile. My opening script goes to the user's profile and creates a global variable for each company that they are allowed to view. When I go to the "Manage Security > Edit Privilege Sets > Records > Custom Privileges > Limited > Script", and use any of those variables (e.g. $$Company01"), the rec
  8. I have a button on a portal that calls a script "Show_Container": Line 1: Set Variable [ $Param ; Value: Get ( ScriptParameter ) ] (name of container field is passed thru script parameter) Line 2: Set Variable [ $Path ; Value: Get ( TemporaryPath ) & GetContainerAttribute ( $Param ; "Filename" ) ] Line 3: Export Field Contents [ Table::Field ; ""$Path"" ; Automatically open ] Wanting to reuse this script in multiple places, I need to be able to replace the "Table::Field" in line three with a variable, but can't see how to accomplish this. Any i
  9. I'm trying to collect the correct answers from a test exam. For example, 35 questions, a, b or c as possible answers. I've made a script with a variable into a loop that collects the data such as: $Var [ question number & "space" & correct answer & "carriage return" & $Var ]. With it I get something like this: 1. a) 2. c) 3. a) 4. c) 5. a) 6. a) ... Is there a way I could make this appear in columns? Like 1. a) 4. c) ... 2. c) 5. a) 3. a) 6. a) or 1. a) 3. a) 5. a) ...
  10. Newbie. OK, here goes... • When I make a new entry into a portal, the cursor automatically enters a text field. • This text field triggers a script. (or whenever I enter it) • I had hoped that script would set a variable called "$$todo", with the value being the record's Primary Key, which i had thought it would have grabbed with the following script... Set Variable [$$todo; Value:GetField ( ToDo_Pk )] • But I just get a "?" So in other words, I'm trying to set a variable called "$$todo"... of the record that holds within it a text field I had entered. Obviously there is something w
  11. Friends, I have had it for today... can't seem to get it right... I'm writing an Excel sheet using the MBS plugin. The plugin let's me set FORMATS so I can underline or center cells etc. For every FORMAT I declare a variabel i.e. that gets a value from the plugin $$Format1 = 89 $$Format2 = 90 I pull data from FMPro and 'filling' up an Excel Template with field values. Some of these field's need formatting. Since all data is dynamic, my script needs to handle this accordingly. I 'build' the excel sheet row-by-row, therefore pulling data from FMPro, row-by-row. A VARIABLE
  12. Hi, I'm having problems with an applescript that tells Phone Amego to initiate a phone call. I've got it to work with a phone number hard coded into the script, but I can't get Filemaker to insert the field's content (phone number) into the script. Table name: PhoneAmego test Telephone number field (text): PhoneNumberGen Mac OSX Mountain Lion Filemaker 11 adv. The plain applescript is: tell application "Phone Amego" getURL "tel:555-555-xxxx" end tell I tried to write a calculated applescript: "tell application "Phone Amego"¶ getURL "tel: (PhoneAmego te
  13. Hi all, I'm stuck, I hope you can help me. On the internet I came across a great tool called ; Dynamic Portals in Filemaker Pro (
  14. I’m tying to make a script that creates x number of records. That number relays on a variable. Is it possible to populate a variable directly? I mean is it possible to make that the script asks me... how many records do you want to create? and let me enter a value, or do I need a field (so a table-layout) to set the value to populate the variable? Thank you.
  15. Hi, I just started using this function, it's very helpful. I have a calculation that returns some transactions for this year. ExecuteSQL ( "SELECT n_transactionAmountGross , t_transactionModel , t_FirstName frmt FROM Transactions WHERE FamilyID_CustomerID = ? AND c_transDate_frmt = 2013 " ; " : " ; "" ; FamilyID ) ) I'd like to substitute the current year for the hardcoded year by using a variable, however this doesn't work. Let ( [ _yr = GetAsNumber (Year(Get(CurrentDate)) ) ] ; ExecuteSQL ( "SELECT n_transactionAmountGross , t_transactionModel , t_FirstName frmt FR
  16. I am trying to use FM Go to initiate a payment procedure with a financial app. Through callback I want to get the result of the transaction back into FM Go. This process works fine, except for the fact that I do net get the result back into FM. I have used the barcode solutions I have found on this forum as an example. I have tried both the get script parameter and the variable option. Also tested both FM Go 11 and 12. Here is an example of the URL I generate (in the application it is properly URL encoded, here I have used the original characters to improve eligibility). The Adyen
  17. Hi Everybody, I am newbie with FM and I have a global variable that contains several values in different lines. I would like to insert automatically these text values in a field as a value list with checkboxes, could anyone help me to solve it? Thank you very much, Wardiam
  18. Looking for a hero. I have searched for an answer to this online and if one already exists, please point me to it. Otherwise, I'm hoping there's a FMrock star out there capable of identifying what I'm doing wrong. Am trying to create three levels for conditional value lists to identify the location of assets. Consider this a library inventory sytsem that tracks: multiple locations where items are held, multiple aisles within each location, and multiple shelves on each aisle. The goal is to enable users to enter an asset record and select from a value list of LOCATIONS. That's a straightfor
  19. I am having trouble sending out automated email reminders. I currently have a script run overnight for a particular database. The goal of the script is to gather email addresses of people who are responsible for items that need work performed to them in the next 2 weeks. So it needs to go to a layout perform a find, a sort and a loop to gather the email addresses into a variable and then exports the list of items due and email it to each employee.. The script goes into the file, performs 2 different finds, one for 7 days and another 14 days and then performs a sort. It then
  20. Hello I have some buttons which allow me to define some values which will help choosing the kind of report which should be created. The button sets a variable value (for instance to "details", "daily", "monthly") and the script acts accordingly. My questions: • is there a way to show the value of the variable on the current layout? (found it after a much needed coffeebreak... ) • would it be wiser to use a global to store the choice? Thank you for your short answer. Cheers
  21. I'm sure there is a way to do this more efficiently than I am doing this. An outside application is passing data back into FMP on the clipboard. This data needs to be massaged before it can be used and the way for me to do this is in a script variable. The current solution is to 'paste' the data from the clipboard into a global field and then to set the variable to that global field. Is there a way, some function I am missing, to set the contents of the data directly into the variable without having to use a global field as a staging area? Thanks in advance for the forum's tho
  22. I have searched all over the forum and internet for and answer and I have not been able to find one yet. Hopefully, someone here can help. I have created a massive filemaker database/program that I am in the process of converting over to HTML and PHP using Filemaker PHP API. I have a script that takes certain field variables in a layout and sets them as global variables so that I can reference those variables in scripts that will be run within the main script. Basically, the script takes a unique record identifier ($$) and if it is still AM ($$) and it runs through different scripts to d
  • Create New...

Important Information

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