Is the actual name of your value list "Valuelist name"?
If the value list is in the file you are evaluating the formula in,
ValueListItems ( "" ; "Valuelist name" )
should do the trick.
cC: It looks like this was one of the tests performed by OP.
I wonder if it's a permission issue?
Yes, I'm just guessing that maybe the value list is actually called something else, and that the real name may contain a clue.
It don't believe permissions would return a "?" - rather an empty result. As would errors in the value list name, btw.
It could be file corruption at some level as well?
I'm assuming the actual value list works when used on a layout etc?
Yes! My other thought was the SIZE of the field (on the layout) where the result is placed?
@sharon , do you have FileMaker Pro Advanced to test in Data Viewer?
Or perhaps the field on the layout needs to be taller?
Can you post a screen shot (or two) of what you are seeing?
Don't quote the
And are you trying to show just the "checked" values?
If so, then place the SAME field on the layout and do not show as checkbox, but plain edit box.
Anything you check/uncheck (in the formatted field) will change the values in the plain box.
If there is something else, please describe?
I've deleted the quote marks, but still get the question mark. I'm actually trying to produce a list of all the values in the Genre field, deduplicated and sorted alphabetically, to use in another calculation. I was trying to do this just to produce the list.
1 of 1 people found this helpful
Are you familiar with List of (summary field type)? I'm not sure that would help
I'm wondering if because you are using a field as the ValueList already, it may not be working.
How about ExecuteSQL():
[ ~query = "
SELECT DISTINCT \"Genre of confirmed acts\"
ORDER BY 1
; ~result = ExecuteSQL ( ~query ; "" ; "" )
]; If ( ~result = "?" ; "" ; ~result )
Sharon - can you perhaps include a screen shot of the field definition for the field that should show the unique list of selected genres?
As beverly says, you don't actually need to add a value list to get the list of unique, selected values (even if it is one of the ways of doing it).
However, unless I'm mistaken, since you have multiple values in the same field, using a value list may actually be easier than ExecuteSQL in this case.
I've got it sorted!
I turned on Indexing in the Value List field.
Terrific, sharon! Mark your own answer as correct, so others may know.