Jump to content

Checkboxes


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

Recommended Posts

Hi guys.. got a fairly simple question but i just can't seem to find an answer to it...

What do i do to prevent a person from checkin a checkbox more than once.

Eg.

I have 2 checkboxes. "new" and "renew" how can i prevent users from checkin both of them at the same time...

Logic will be, a record status can be either new, renew or none, but record cannot be both new and renew.

Please advise... Thanks

FileMaker Version: 6

Platform: Windows 95/98

Link to comment
Share on other sites

Another solution would be to make a simple script for each checkbox that checks for the status of the field before setting that checkbox. If "renew" is already checked the script will uncheck it prior to checking "new" and vice versa...

Link to comment
Share on other sites

Alternatively, a field validation with a calculation

not (PatternCount(YourField,"Yes") and PatternCount(YourField,"No"))

But again be aware that scripts by-pass field validations, so I'd too rely on scripts as Shadowdoc suggested.

FileMaker Version: 6

Platform: Mac OS 9

Link to comment
Share on other sites

I *hate* how multiple radio buttons can be shift-clicked! It's the most stupid and unnecessary violation of a basic interface element!

Link to comment
Share on other sites

Ugo DI LUCA said:

Alternatively, a field validation with a calculation

not (PatternCount(YourField,"Yes") and PatternCount(YourField,"No"))

But again be aware that scripts by-pass field validations, so I'd too rely on scripts as Shadowdoc suggested.

Hi guys...

Thank you so much for your help. I already did the script mention by Shawdowdoc and i manage to prevent the user from checking both boxes with the use of the field validation function. I set the field with a maximum character validation, so if both boxes are checked, the value will exceed my maximum number of characters and will prompt an error message.

I chose the easy way of doing it.. Not sure will i experience problems in future.. Do let me know if you guys see any possible flaw in this method...

grin.gif

FileMaker Version: 6

Platform: Windows 95/98

Link to comment
Share on other sites

"I set the field with a maximum character validation, so if both boxes are checked, the value will exceed my maximum number of characters"

All you have to check for is the presence of a "

Link to comment
Share on other sites

This topic is 6492 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
 Share

×
×
  • Create New...

Important Information

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