We help IT Professionals succeed at work.

Possible to get available selections from a field

notesrookie
notesrookie asked
on
180 Views
Last Modified: 2013-12-18
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.
Comment
Watch Question

CERTIFIED EXPERT
Top Expert 2007

Commented:
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 !
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
CERTIFIED EXPERT
Top Expert 2007

Commented:
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 !

Commented:
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")

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




Author

Commented:
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.

Author

Commented:
Can I then get this selection list in List classroom (not selected items) from another database? Thanks.
CERTIFIED EXPERT
Top Expert 2007

Commented:
Sure, just use DBCOLUMN or DBlookup in the formula.

I hope this helps !
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.