Hi,

All I want to do is have other check box(es) automatically checked ("y") when I check another, specified box. Sounds so easy. Is impossible!

All I can find in the FMP help script section is how to insert a calculation. Not relevant as far as I can see.

Although I'm a pro at creating layouts, obviously I'm a total dummy when it comes to automation and scripts. Help!!!

Karen

Hi Karen,

It depends upon your needs. For instance, if you want a checkbox to have a check if certain conditions are met and you don't want Users to be able to change this checkbox, then a calculation is the way to go.

Create a calculation (number, index ON) with your criteria. For instance, if another field contains data and you want the checkbox checked, something like: Case(not IsEmpty(YourTextField), 1) will 'check' if data is in the field and will 'uncheck' if the field is blank.

You then need to create a Value List based upon this calculation and format your field through field format to use a checkbox and point to this new Value List. Redraw your checkbox field so only the box shows. You don't need the 'Y' to show - checked always means yes! You can add regular text next to the checkbox that says (for instance) 'Proposal mailed' or whatever.

I used a '1' because it's just a bit simpler. You can use the 'Y' and let it show next to the checkbox if you wish.

If you could explain exactly how this checkbox will be used, we might be able to give other ideas, but try it ... I think you'll find a calculation may be what you're looking for. And if you provide the specific criteria for the 'check' we'll help with that too! We need to know the field names, conditions necessary and the fields' datatypes.

LaRetta

Hi LaRetta,

> if you want a checkbox to have a check if certain conditions are met and you don't want Users to be able to change this checkbox, then a calculation is the way to go.

It's only me using the DB. And it's simply to automate a function (checking the other boxes when a certain box is checked) that I now have to do by hand (and sometimes forget).

> Redraw your checkbox field so only the box shows. You don't need the 'Y' to show - checked always means yes!

Yeah, that's the part I'm good at <s>.

> If you could explain exactly how this checkbox will be used, we might be able to give other ideas

This now applies to 2 databases I'm using for my business, and in each case it's the same: When one box is checked, I want that to automatically trigger checking another box(es) (or in one case, changing a radio button field).

> but try it ... I think you'll find a calculation may be what you're looking for.

I will try it, thank you, following your instructions above.

And if you have any other ideas of how this might be accomplished...I'd love to hear them.

Karen