Global Utility Fields
Global fields in FileMaker Pro are a staple of how you define what your user interface can do. Without global fields, your ability to present variable scenarios of data is almost impossible - or - at least, unrealistic. You would be limited to using calculated fields and/or extra data fields, and this can make things really slow, REALLY quick.
Global fields are the linchpin to makings things work well, as desired and efficiently within your FileMaker UI. Without knowing how to take advantage of global fields, your UI/UX abilities suffer.
In this video, we take a look at some of the most critical uses for global fields for common core functionality. From creating related records, to showing whatever data you need to present, it's critical you take advantage of global fields. There are also situations where your current data model simply won't allow you to present the data you want to show. However, using global fields you can create "temporary" relationships to the data you need to present to the user. This video and technique file will deliver some of the critical know-how.
Comments
Errors in to attached file
Hi,
There are some error in your file "Global Utility Fields.fmp12" example.
- In the windows title I have the following text : "? * Line 1, Column 1"
- On the load tab, the counter show 3 records (for instagram) but there is only 1 name "Garfield Eaglen"
SQL Errors
Getting the "? * Line 1, Column 1" type of response is a SQL error/issue. I only worked and tested this file within FileMaker 19 and higher. You'll need to debug the SQL within the SELECT Global script.
You can also add code in the event that you do not get a successful SQL result from your requested records. There is no error handling on the script. This is something which would be added based on the desired implementation.
-- Matt Petrowsky - ISO FileMaker Magazine Editor
You were about to say....?
You were about to say what to do about entering 20k records into LOAD... but didn't finish your thought.
What were you going to say? Very Curious.
Dave17