Jump to content

Bit Based Checkboxes

This topic is 4374 days old. Please don't post here. Open a new topic instead.

Recommended Posts

by Matt Petrowsky



FileMaker, for all it's ease-of-use, does things in a particular way to make things easy - on purpose. Checkboxes are a prime example. When searching for information within a database, people typically search based on what they understand. The word "Customer" or "Vendor" makes sense, because that's the term you use.

However, there are times when storing things in a more optimized fashion is desirable. This is especially the case when you wish to disassociate the value displayed with what is stored in the database.

Since FileMaker will store the string value "Customer" within a field, when you decide to split customers into "Prospects" and "Customers" you'll need to do some data manipulation to break things out. Unless, you've used ID values or some other type of abstraction from the value shown vs. what is stored.

In this video, I present how you can use Bit based math in order to store the values of a check box (or any other number of items within a logical group). This works especially well when you want to emulate the OS native check boxes in the current versions of FileMaker.

Details: Released - 2/14/2011 / Size - 32.68 MB / Length - 22 min

View the full article

Link to comment
Share on other sites

This topic is 4374 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

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