Dealing with imported checkbox

[kemotkd]

Hi, All

i am beginner in FileMaker.

i started my database which is imported from access database by excel cheet.

the original data base contains alot of checkboxes.

when i import the data from checkbox, the checkbox get me 2 checkboxes value in filemaker,

one is "0", which mean false and the seconed is "1" which mean True

i need to remove the checkbox which named "0" or false, and keep only one checkbox as in the original databse,

and change the other checkbox title "1" to another Tiltle.

Thanks

[LaRetta]

So:

If the field contains 0, change it to blank.

If the field contains 1, leave it alone.

And if the field contains 1 & 0? Change it to 1 only?

If correct, then you can fix the data this way: Show all records (back up first and do this when users aren't in the system) and place cursor in this checkbox field and then Records > Replace Field Contents > by calculation and specify something like:

Case ( checkboxField ; 1 )

Once the data is as you want it, containing a 1 or nothing, you must change the custom value list that the checkbox is based upon so it contains only a 1. Resize the checkbox so it is same width as height (in px) to hide the '1' and add your own label. Now you have a toggle on or off (1 or blank; true or false).