December 5, 2006
I assume you have missed something or have something complicating your
result, because I can go up and down the row and it changes every time I
enter "Y" in a new button.
P1F4 formula
IF (P1F5 = "Y")
OR (P1F6 = "Y")
THEN "" ELSE "Y"
ENDIF
P1F5 formula
IF (P1F4 = "Y")
OR (P1F6 = "Y")
THEN "" ELSE "Y"
ENDIF
P1F6 formula
IF (P1F4 = "Y")
OR (P1F5 = "Y")
THEN "" ELSE "Y"
ENDIF
I have done this in some data bases with the alternative to "Y" being
"N" rather than a blank. It's quite flexible that way.
As well each of them is set to "Initialize at Create/Save/Change", so it
changes immediately a choice is made. After the first record, that means
that Radio button 1, P1F4, is initially selected, but then another
selection returns that to blank.
The first button I touch in the first record, I can put anything in it,
and get "Y". Thereafter, buttons will only accept a "Y".
To make a change after a record has been saved, you have to go to edit,
which means your first key stroke won't do anything.
Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM
Michael Iannantuoni wrote:
Thanks Don,
That works OK up to a point: the problem I have is that if P1F6 is set
to "Y", it must be unchecked before either of the two can be checked
or am I doing something wrong?
Michael
Don Codling wrote:
December 5, 2006
If by radio buttons you mean fields in which if one is on the others
are off, it seems fairly simple to me, perhaps because I deal in
simple structures.
I have created a test database which has U1 fields P1F4, P1F5 and P1F6.
Each of them has a formula associated with it, in this form (for P1F4)
IF (P1F5 = "Y")
OR (P1F6 = "Y")
THEN "" ELSE "Y"
ENDIF
these are set to change when modified.
If you enter anything in any one of them, it reads "Y", and the
others switch to "".
Don Codling
WP 12.0.0.602
DP 2.6x
Windows XP home, SP2
512 MBytes RAM
Michael Iannantuoni wrote:
Hi Brian,
I have a sort of solution for radio buttons:
Each of my check boxes are U1 fields.
To their right is a label field which has a "]" & the response
Question Wording and to the right of that a GZ field which is 1 if
the U1 is "X" otherwise 0. Another field sums the GZ's to keep a
tally of how many boxes have been checked.
To the left of the U1 fields is a conditional A1 field which is
either ASCII 249 or "[".
If the selection is multiple option, any available boxes can be
checked.
If the option is Lickert, once a box has been checked, the "["
associated with the other boxes turn to ASCII 249 so no further
entry is possible.
If the user changes their mind, they must uncheck the checked box
which then changes all the other conditional A1 fields back to "["
thus allowing any to be selected again.
OK, not quite Radio Buttons but only one check box is allowed as per
Lickert.
What do you think?
Michael
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
_______________________________________________
Dataperf mailing list
[email protected]
http://lists.dataperfect.nl/mailman/listinfo/dataperf
