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, 201016 yr by Guest

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

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

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.

Count() will do all that in one.

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} )

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} )