grouping radio buttons

[myriapod]

Hi to all

i need help about modifing and reordering a filemaker database..

what i don't understand is how to group some radio button values ... i mean

- i have 20 radio buttons , they are unchecked as default

- i need to add another button which reports if , for a selected record, any of these button are pressed, simply reporting "yes" or " none"...

Any idea to do this?

thank you very much

Edited January 8, 2010 by Guest

[bcooney]

Welcome to the Forums!

Are the twenty radio buttons a value list for one field? If so, then you can check if that field is empty (non-selected).

However, 20 radio buttons is unusual, and hints of a poor data model.

Barbara

[myriapod]

Hi Barbara thank you for your reply...

"Are the twenty radio buttons a value list for one field? If so, then you can check if that field is empty (non-selected)."

No they are not a value list for one field...

Can i create a new value list using these radio buttons and then checking if empty or not?

"However, 20 radio buttons is unusual, and hints of a poor data model."

Yes you're right, this database was build very long time ago, now i have to reorganize it and in a future migrate it to PHP/SQL

anyway thank you

[bcooney]

Well, then, you could create a calc field using List ( ) of all the radio fields. Then check this calc to see if it is empty. If not, something's selected.

[comment]

Count() will do all that in one.

[myriapod]

thanks for your support...

Let's make a real example please...

Considering 20 radio buttons called seminario A/1, seminario A/2....

i create a new field in Database (i called it CalcField) , flag it as Calculation Field (my filemaker is not in english -D) , and from the next window setup a Count() formula in this way:

CalcField = Count ( field {; field...} )

But when i try to insert some fields (my radio buttons) it returns an error:

i wrote:

Count ( {seminario A/67},${seminario A/68},${seminario A/69} )

what's wrong with it?

thank you

note: trying with only one radio button it works!

Count ( {seminario A/67} )

[comment]

The correct syntax is:

Count ( field1 ; field2 ; field3 )

There is an additional complication here because your fields have improper names, so you would need to use:

Count ( ${seminario A/67} ; ${seminario A/68} ; ${seminario A/69} )