MAKE EXCELLENT DATA: LIMITING ACCIDENTAL DATA ENTRY IN FILEMAKER MOBILE SOLUTIONS
From our experience with the Codifi projects we know there are many things to consider when you’re designing a database that’s going to be deployed in the field. Data entry by the user should be kept in mind – as a developer you need to think through all the ways that your users will want to input data, and when and if those conditions are appropriate for your solution. The easiest way to solve this, thanks to FileMaker 13, is the “hide object when” function found in the Data Inspector.
With this tool (accessed in the Data Inspector in FileMaker’s Layout Mode) you can specify the exact conditions users can see and interact with all the data fields in your solution, using a simple bit of scripting. As Matt Petrowsky of FileMaker Magazine points out, using a simple
not IsEmpty (field)
calculation pointed to the specific field will actually hide the field in question if there is not data present in it — which brings up other points of maximizing layout space and data presentation that will be covered in future blog posts.
For other solutions that incorporate an ‘editing’ capability or button for their layouts, using invisible layout object to effectively ‘block’ users from entering field data when not in ‘edit’ mode is a very effective way to prevent accidental data entry in the field as well, just apply the script to the invisible layout object instead of the field itself.
An example of this technique is demonstrated below:
Make sure in your Edit script there are 2 parameters, (1 and 0) for editing mode enabled and disabled respectively. Now when creating your layout object (the red box), it’s important to add the correct scripting to Hide the object, in this case:
Layout::gEdit=1 or not IsEmpty (Layout::Fieldname)
Now this scripting firstly makes sure that the red box shows when ‘edit’ mode is NOT selected in the database (you wouldn’t want that box to display when users are edit and inputting data).
And when editing mode is enabled, the red box disappears and data is able to be entered:
But what about after you enter data, you certainly don’t want that red box obscuring your or the user’s great work! That’s what the second part of the hidden object script does:
not IsEmpty (Layout::Fieldname)
ensuring that the box only displays itself when the field in question (Locus) has no data present in it.
So there you have it, using Hide Object When to prohibit access to the underlying fields and only ‘displaying’ when the fields have no data, or when editing mode has not been enabled on the record you’re browsing.
Go forth and protect your data!
Author: Michael Ashley
Due to the heavy rainfall this winter, California State and National Parks and Heritage Sites are under threat of serious structural damage, mud slides and land erosion. The Ghost Town of Bodie is among these.read more
Freelancer Developers can be an affordable option for small teams or projects with a tight budget. CoDA tested out Upwork, an online hiring platform, last year and worked with a few freelancers, some better than others! Here are 5 things we learned and how you can get the most for your project on a budget of any size.read more
Three organizations team up to explore possibilities for international exchange and increase impact of world heritage and archaeology. Great news! These three organizations have started a collaboration through a Memorandum of Understanding to establish a cooperative...read more
For the ancient Polynesians, folklore was shared by word of mouth, today the most popular platform for telling stories are movies. Moana, Walt Disney Studios’ latest film, tells the story of a young girl raised to become chief of her people who comes to discover she...read more
The Hawaiian people built a rock enclosure in a shallow depression in a volcanic ridge in the mountains above Kapolei, in an area now known as Pālehua.read more
This course is a cross-disciplinary exploration of Cultural Heritage on a global and local scale through discussion, debate, in-class activities and team-based research projects.read more
Six Fundraising Lessons from the world most successful fundraisers at the 2016 “Nonprofit Fundraising Masters” event in San Franciscoread more
Looking back on the process, Kodak PCD conversion almost seems easy. If you are at the beginning of your zip recuperation journey, these steps may not be obvious, but they are very doable. The only solution available which will keep images high-resolution, convert and maintain original metadata, and save you a LOT of working hours is PCD Magic!read more
At the Lowest Place on Earth, on the South-East shores of the Dead Sea, nestled in the Ghor es-Safi and a short turn off the Dead Sea highway, you’ll find a little museum with a big mission and big stories to tell.read more
The Lifeways of Ancient Africans offers an overview of the archaeological heritage of Africa, from the emergence of modern humans to the beginnings of European colonization.read more