Combine Lists with Dereference and ability to Add or use text

Hello, I may be asking too much but shooting for it anyhow. I have obtained each of these goals separately but I cannot find a  way to do them all. When I change the configuration to accommodate another requirement it looses a function elsewhere.

I need to be able to:

  1. Have a single drop down with combined lists: (I have this setup)
    a. Suggested Values: Custom.Locations[Location Name]+Locations[Location Name] (produces list and allows "Add to custom location" but not "Use", allow other values is selected.
    b. Problem: Can't Dereference items from the added locations table . (could use lookup instead of dereference for all?)
  2. Dereference the selected location to obtain Lat/Long, etc :
    a: Works w/ the references list, Doesn't with the added list, shows broken links (yellow triangle)
  3. Add a new location to the custom locations table: (this works, listing only as a need)
  4. Use entered Text instead of adding or selecting from the list.
    b. (works when the column type is text, not when it is enum even w/ the option selected)

 Table 1 (Custom Locations) + Table 2 (Locations)

Dropdown: Shows search only, no "add" or "use", breaks referenced links w/ the added list

ZOCO_Unlimited_2-1675219320973.png

Please let me know what additional info you may need. Thank you in advance for all of your help

 

 

 

 

 

 

 

 

 

0 4 279
4 REPLIES 4
Top Labels in this Space