notesrookie
asked on
Possible to get available selections from a field
Is it possible to get what the selections are in a field and use those selections. For example, I have a field called Classrooms and it is an editable dialog list that contains the following selections: 2A, 2B, 2C, 3A, 3B and 4A. Can I get this list to show up as a selection list in another field? Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I may have misunderstood, bt I think that notesrookie wants to use only the Selected options of a list to show up in a second list of options.
notesrookie - Please correct me if I am wrong.
marilyng is correct in that, as I mentioned, you can simply use the computed, formula:and tell it to use the classroom field which is just what you selected.
I hope this helps !
notesrookie - Please correct me if I am wrong.
marilyng is correct in that, as I mentioned, you can simply use the computed, formula:and tell it to use the classroom field which is just what you selected.
I hope this helps !
Sorry, sysExpert, that's not what you said. Of course, I have no idea what you were saying. But it wasn't a way to use selected options.
Here's what you should have said, if that's what you mean:
-------------------------- ---------- ---------- ---------- ---------- ---------
If classroomfield1 has options: 1,2,3,4,5,6,7,8,9
And the user selects: 1,2,3,4,5; or 1,3,5
Provided that you check the Refresh Options when document is refreshed, and Refresh Fields in the classroomfield2 options, and then add a formula:
@if(classroomfield1!="";cl assroomfie ld1;"This list when classroomfield1 is empty")
-------------------------- ---------- ---------- ---------- ---------- --------
Here's what you should have said, if that's what you mean:
--------------------------
If classroomfield1 has options: 1,2,3,4,5,6,7,8,9
And the user selects: 1,2,3,4,5; or 1,3,5
Provided that you check the Refresh Options when document is refreshed, and Refresh Fields in the classroomfield2 options, and then add a formula:
@if(classroomfield1!="";cl
--------------------------
ASKER
I was looking to find what selections are available in a particular field, not the items already selected.
marilyng - I'll give what you suggested a try. Thanks.
marilyng - I'll give what you suggested a try. Thanks.
ASKER
Can I then get this selection list in List classroom (not selected items) from another database? Thanks.
Sure, just use DBCOLUMN or DBlookup in the formula.
I hope this helps !
I hope this helps !
classrooms(0) .. classrooms(n), should contain your selections.
Depends on how you defined the lower linit, it may start at 1 , not 0.
In another dialog listyou can simply tell it to use your Classrooms field as the list of options.
I hope this helps !