Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×
The Claris Museum: The Vault of FileMaker Antiquities at Claris Engage 2025! ×
  • entries
    516
  • comments
    6
  • views
    36,044

Cleaning Input Data


Attachment Size
package-x-generic.pngCleaningInputData.zip 273.33 KB
By Matt Petrowsky

Download Video

Users make mistakes. There’s no doubt about that. When given the opportunity, they’ll enter characters and text strings you never expected.

The easy solution to this problem is to simply control the result of what they’ve input. When capturing the input, there may be a variety of rules regarding how you want the data stored.

Do you want to store “4 pm” or 16:00:00? Is the user entering suffixes such as Jr. or Sr. into the last name field or the first name field? Should the input be super simple for an iPad and just happen within one field?

Making the input process easy, yet conforming to your storage rules is often desirable. So is performance! Do you know the performance impacts of that auto-enter calculation versus simply using a script trigger?

This video is all about cleaning up your data input. As a user adds data to the database, you can take the necessary steps to make sure it’s exactly what you want - the low impact way.

Tags: 


View the full article

0 Comments


Recommended Comments

There are no comments to display.

×
×
  • Create New...

Important Information

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