Yes. Just make sure the field is layed out large enough to show all options.
1 of 1 people found this helpful
I think Tammi wants only the selected value to appear in Bold within the radio value field.
I don't see how this can be done.
Yes, that's what I want. But I can't see a way to do it.
I think I've come up with a workaround, but it's not dynamic, so if the value list were to change, the layout would need editing. Here it is:
Create text blocks for each of the value list posible choices, and place each text block,so it sets directly on top of the matching value in the radio button list.
Then use custom formatting on each one to make it Bold if the value in the radio button field = the specific text used in that block, by hardcoding the IF as RadioValueChoiceField = "Green" (if the matching value list has "Green" as a possible value.
You might also want to make these text blocks have NO color value as a background, and set the color background to match the field's background (not transparent) if the match is made, along with Bold, so the original text won't show through.
Not perfect, not simple, but might be made to work.
A little bit of trickery. I'm sure there are many better ways to accomplish this.
Value list in a second table, a calculated field for labels that uses the Substitute and text formatting.
1 of 1 people found this helpful
I like that!
I tweaked your layout samples a little so that the user need not click directly on the radio-dot portion of button, but can also click on the value in the final example.
Expanding on what Stephen is suggesting. If you use the following as the basis for a formula for conditional formatting, you may get what you want:
lst = ValueListItems ( Get ( FileName); "Listname" );
Contents::Type = getvalue(lst;1))
The "Listname" shouldl be replaced with the name of your list.
The number in the getvalue() function determines which member of the list to compare to.
What this does is put the valuelist into a local variable and compare the current value of the field to a specific value in the list. You would have to set this up for each item in the list. To a degree this would be dynamic. You can change values in the list and it will still work. If you add values you would need to add additional panels and formulas.
or just use ordinary script button ojects, script parameters corresponding to the VL values, anc CF on the buttons
in the german Technet we just had the same question. I suggested a calculation-field that shows the values in the layout.
The calculation could be (I'm sorry some of the english function-names I have to guess, I'm using german FM)
List = ValueListItems ("Filenname"; "Name of the value-list" );
Field = Name of the Checkbox-field;
line1a = getValue (List; 1);
line2a = getValue (List; 2);
line3a = getValue (List; 3);
line1b = If (PatterCount (Field; line1a); FontColour (line1a; RGB (0; 190; 0)); line1a);
line2b = If (PatterCount (Field; line2a); FontColour (line2a; RGB (0; 190; 0)); line2a);
line3b = If (PatterCount (Feld; line3a); FontColour (line3a; RGB (0; 190; 0)); line3a)];
line1b & ¶ & line2b & ¶ & line3b)
It only works with three lines or as much as you define (line 1--3). You could use a custom-function for n lines
David & Stephen, THANK YOU!!!!!!!!!!! I will be putting that into place this weekend.
it's only now that I see, you had not only a quite similar solution as I had, it's even better. thank you from me too.
But I don't like having an extra table, an extra relationship and the useless constant-field. So I "married" our two ideas and that makes me happy now (with the getValueListItems or how it is called in english. Why didn't you use it? Am I forgetting about something again?). Your altered example attached.
No, not completely happy. It only works with radio-buttons. No Checkboxes, what our original question was. But I think this thread is fine now. (Is it allowed to answer finished threads?)
I think it might be much easier to use the color red to mark the selection. That would be hard to miss.
Also, you can use a plug-in such as SimpleDialog to show the radio buttons and then confirm the selection in another dialog.
agnes b. riley . filemaker and web development
FileMaker Business Alliance . FileMaker Technical Network
T 201-299-6223 (NJ) .
FileMaker Certified in 10 and 11
people + products + events + todos + invoices + documents = productivity
As I said in my posting - one of several ways to accomplish the trick. This is the joy of FileMaker. This was definitely a quick and dirty solution, but it worked and only tool a couple minutes to put together.
Using the value list commands would have done the same thing.
Glad that it worked for you (or some variation on my technique).