Jump to content

Search the Community

Showing results for tags 'global fields'.

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

  1. All files/tables in this discussion are fmp12 using FM 17 and both files are opened when initiating the app. "logging" is opened as the primary file and "claims" is opened as an external data source. I have a table called "newclaim" in "logging" which contains mailing address information including a USPS zip code. I have a table called "lu_ZipCode" in "claims". There is a relationship set between "newclaim" and "zipcode" on a field called "COID" (company ID). This field is automatically populated in both tables with "DCSI". This is an old method (used in Fm6) of establishing a simple relationship so that global fields can be used to pass parameters into scripts for zip code lookup and verification. In the parent script (in "logging") I set the related field "lu_ZipCode::_gZipCode" with (for ex) "12345" with the intent of calling a subscript in "claims" then using "12345" to do the lookup. However when the subscript is called the "_gZipCode" field is empty. As a workaround I called the subscript passing the "12345" as a parameter which of course works as one may expect. After setting the parameter to a local variable in the subscript I'm able to do the lookup then populate the global fields "lu_ZipCode::_gCity" and "lu_ZipCode::_gState" while still in the "claims" file. Yep, sure enough when I go back to the parent file the global fields I just populated are empty. It's worth pointing out here that prior to yesterday "zipcode" was a separate file and the methods described above worked like a charm. This effort is being put forth to consolidate this old FM6 solution with 40+ files into just a few files. I imported "zipcode" into the "claims" file then copied and modified the scripts anticipating that this would be a quick little project to get rid of one more file. I know there are better methods (ie JSON) to get this done and I will probably go that route. At the same time I'm left scratching my head on why this tried and true method doesn't work. Why would global fields I can populate from one side of the relationship not be populated when viewed from the other side?
  2. Hi, I'm not sure if this is the correct place to ask this. But I have a issue. Basically, I have a layout which shows an Estimate. Each Estimate layout has a related table for (main estimate, descriptive, other). Each of those related tables has their own fields with detail and pricing. I have those as portals on the Estimates main page. My client needs to print out an invoice that shows all the estimates from the related tables in a line item type of view. I was thinking to create a table with all global fields. The script will loop through each related table and transfer that to the new global table by adding new records. Then it will loop through next related table and trasnfer those. This way all table data will be in one list. Then I will print from the new global table with list view. Afterwards, I'm assuming I will need to delete the records in the global table? Is that the correct way? Will creating and deleting new records in a global table be an issue with other users? I thought of making just one table initially to hold all estimate data, but that will not work. Hope this is easy to understand.
  3. Hi guys.I have a room allocation database. I have made a global number field, and when a room is allocated, it reduces the available number of rooms by one. Very simple and It works fine, but the number does not match for other shared users. I want the number to match for everyone. I thought global would do it. Any suggestions? Thanks
  4. I've got a table with three global fields; one a text field, the other two numeric fields. The database is hosted by Filemaker Pro 11. So far, no problem. But I've noticed that a change to any of these three fields is not updated by either a) guests if the change is made on the host computer, or the host if changes are made on guest computers. I've never seen any behavior like this in Filemaker before. In every other instance, a change made in one record is updated everywhere as soon as the change is committed. I can't imagine there's a database setting that would allow for this sort of behavior. Anyone have any ideas?
  5. I'd like to know if there is a way to generate a window identifier. My goal is to be able to open two identical windows and then have conditional formatting or calculated fields appear differently to the two windows according to selections made by the user. If I use conditional formatting based on global fields then they will be set across both Windows. Addendum: OK. I did find this post, which talks about using a custom window title, which I've considered. That's a little messy.
  6. Hello, I have a FileMaker file that connects to an Oracle database via ODBC to display some data. I have a global field set up for searching out serial numbers. I had defined an auto-enter calculation that replaces the existing value in the field, using the Upper() function. This works just fine. However, someone discovered this morning that if they hit the Return key after entering the serial number (thus adding a newline (carriage return) into the field), they would get a different result from the database. So, I went back and changed my calculation to Upper (Trim(SerialSearch)) . This doesn't remove any hard-returns from the end of the input. I have also tried the Substitute function, but this doesn't work, either. I even tried LeftValues (SerialSearch; 1), but FM seems to consider the entire field as one value, even with the LF character in there. What gives? Any ideas? As an alternative to calculations, is there any way to disable the Return key in an input field, so that newlines can't be entered? (P.S. - What's the code to enter a pilcrow here?)
  7. The main database I work with contains thousands of records - one for each customer we have ever worked with, and a new record is created for each new customer. And there are dozens of layouts similar to the one I am working on now - all available for, and unique to, each customer record. The portion of this layout I am working on is much like an Excel spreadsheet, with a header row of values across the top, a column of ages down the left side, and a grid of values each calculated based on the value above it and the age to the left of it. See the attached example. I make use of repeating fields for every row on the grid to avoid having to create hundreds of individual calculation fields. To do this, I have a repeating global field (let's call it g_Benefits) that contains a list of numbers: 10, 20, 30, ..., 100 for the example shown. The header row is another global repeating field that calculates values by multiplying the values in g_Benefits by 1,000 and displaying the results as dollar amounts. Each row below that is another repeating, but non-global, field that calculates and displays values based on the values in g_Benefits, the number displayed to the left of that row, and other variables specific to the customer in that record. So, while the header row and the Age column seen in the attached example remains the same for every record in the database, the non-bold values in the grid will differ from record to record. But, now I need to allow for the possibility of entering a number in a custom value field that will replace the corresponding value in g_Benefits. (10 repetitions in g_Benefits means there will be 10 custom value fields.) And the custom value must be constrained to the record it is entered in (so g_Benefits can no longer be global). If I entered 25 in the 2nd custom field in one record, g_Benefits would change to 10, 25, 30, ..., 100; while the other records (and any newly created records) would keep the original values. And 2nd column of values in this layout's grid for just this record would change based on the custom value entered. This creates two issues. 1. I need to configure g_Benefits so it populates with the default list of values whenever a new record is created and keeps those values in all existing records. 2. And I need to configure g_Benefits so that, if a value is entered into a custom field in one record, the corresponding cell in g_Benefits changes for only that record. I've been working with the Get ( CalculationRepetitionNumber ) function, but I haven't been able to get it to populate any more than the first repeating field. Even then, I'm not sure that would allow me to replace values with custom values. This is all done in Form view. There are no portals involved, no scripts, no virtual lists, and no related tables. Any thoughts? Screenshot attached.
  • Create New...

Important Information

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