Link to home
Start Free TrialLog in
Avatar of notesrookie
notesrookieFlag for United States of America

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.
Avatar of SysExpert
SysExpert
Flag of Israel image

Sure.

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 !
ASKER CERTIFIED SOLUTION
Avatar of marilyng
marilyng

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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 !
Avatar of marilyng
marilyng

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!="";classroomfield1;"This list when classroomfield1 is empty")

--------------------------------------------------------------------------




Avatar of notesrookie

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.
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 !