Different values/labels for radio buttons

[Hammerton]

I want the responses to radio buttons on a layout to read "yes" or "no" but enter "1" or "2", like you can do with an http radio button. Is this possible in FM?

Thanks

[Fitch]

If you resize the field so the radio buttons stack vertically, you can simply resize it so the labels (1 and 2) don't show. Then put your own text labels (Yes and No) on the layout.

For more flexibility in placement, make two value lists, the first will be "1" and the other "2" and then make a copy of the field so you have two of them on the layout. Now assign one of them the "1" VL and the other the "2."

Then do as above: shrink the fields so their value labels don't show and put your own labels there instead.

[mr_vodka]

You can always size the box so that it will not show the 1 and 2 value of the Value list. Then put the Yes & No next to the Radio buttons.

[KirkR]

I have a similar situation.

A horizontal value list (radio buttons) with manually entered value list text for each button.

I need to do a math calculation based on the average of the numeric equivalent of the position within the value list.

I also need to ignore the N/A response - the last radio button.

Initially, I had used a value list of numbers, formatted to the background color, overlaid with text on the layout. The problem with this was clicking on the button brought the value list to the front, obscuring the overlaid text - not good for user input. SO, I changed the list to the textual value, and now need to calculate based on the numeric equivalent.

Suggestions? I am not sure where to start looking.... maybe the LET function?

[comment]

Why don't you use something like shown here:

BTW, this is the third time you are posting more or less the same question:

 

[KirkR]

Here is part of what I have for a solution

Let (

[

C_04SelfApp=1;

C_09SelfApp=2;

C_12SelfApp=3;

C_16SelfApp=4

];

Average ( C_04SelfApp; C_09SelfApp ; C_12SelfApp ; C_16SelfApp ))

This approach is wrong, as the calculation is using the LET values; using the assigned number in the LET function (the average is ALWAYS 2.5, regardless of data input). What I need is the response in these fields to have a numeric value to average.

SO.... I substituted ....

( [

No Confidence=1

; Very Little =2

; Some =3

; A Lot =4

; Complete Confidence =5 ]

;

But this (the value list items in rank order with numeric values assigned) does not work, either - NO data is shown. I was hopeful that this would work, and by excluding N/A (the 6th radio button value) from the list, it would not be part of the calculation.

Trying to do this too late at night for functioning brainpower, so I am going to hang it up 'till tomorrow.

Still missing how to exclude IF one or more of these responses is N/A.......

[KirkR]

1) with numeric value list, answered by averaging across fields. Broke in display, as value list click obscures overlaid text.

2) with the DB restructured as one question per record. For reasons to numerous to get into, this approach is being tabled for potential later use. The complexity of the calculations for the various display and report constraints made is unmanageable, at this in the time (or knowledge) I have available. Instead of a couple stumbling blocks, a large number seemed to pop up.

3) the current iteration: back to DB structure as in 1, but with textual values in the value list, and attempting numeric averages. The prior thread answer included that N/A was NOT numeric (the other values were), so it was excluded. But because of a display / presentation issue, the value list contents have been changed. (what is the average of "Some" and "Very Little" :-)

I'll take a look at the threads provided.

Thanks - Kirk

[KirkR]

Tried a CASE function - it works, testing for the value list text string, to create a relative numeric value. However, I'd like to simplify the repetitive entry.

I am making the [rash?] assumptions here, that the case calculation must be in a different field; attempting to replace the contents of the entry field with a numeric text value, when the value list are text string entries, will negate the current display of the radio button value list, as the replaced values are NOT in the list.

SO, I would guess that I need another field to perform the calculation in. As I have 59 questions that a single value list, ranging from no confidence ... complete confidence to N/A, I would prefer to come up with a calc that can just be copied.

I have been attempting to get the fieldname, but am unsure as to the command. I was then going to do a leftwords function against whatever returned fieldname (I tried SELF), so that the base fieldname would reference the contents of the source field, not the copied one. (leaving the default copied field as FIELDNAME COPY, the leftwords would be FIELDNAME, where the textual value list answer resides.) But the SELF function does not return the fieldname.

Then, I could do a case function on the value list contents for the source field, using the CASE function to return a numeric equivalent of the position within the value list (No Confidence = 1, some confidence = 2, etc. and N/A = "" ) so that I can do an average on a set of fields.

Am I headed down the wrong path here? The goal is just to get the numeric equivalent of a textual value list entry AND be able to do that 59 times without entering a different calculation 59 times. (I can do it manually, selecting the field name, but trying to minimize devtimes).

--Kirk