I have an app with 2 fields: List Lookup AvailableColors and Table Lookup ColorSupplier. AvailableColors lists all colors in the spectrum (RED-PURPLE), but some Color Suppliers specify that they only support a subset of colors (e.g. BLUE, YELLOW, GREEN). I want my users to select one available color, but only if it’s one provided by the chosen ColorSupplier.
I believe I can validate this via logic block to guarantee that they’ve only selected an acceptable color. But is there a way to limit the options on-screen? I looked into Dependent Lookups but it looks like those are only for List Lookup A controlling List Lookup B, which doesn’t fulfil my need.
Not to my knowledge, currently static per application. I wouldn’t surprised if there is an existing idea out there for that and if there isn’t we should get one entered.
I don’t think there’s a great built-in way to seamlessly do this. Assuming this is a UI use case I would try something like the following:
user selects a supplier
on Field Value Change of supplier, the supplier record is fetched and then in logic, loop the subtable or multi-select list lookup which defines which colors are allowable for that supplier
display the available selections in a work-subtable (can even be a pop-up mini app that is queued as an app link), where each row with a color in it has an action button on it or selection box allowing the user to select one of the rows, that then gets persisted into the selection field
The help page Control available list lookup values addresses this and clearly states that it is not possible as I’m imagining today. I’ll try Ian’s approach or see if I can get creative with Dynamic List Lookups and mapping in values from the table lookup.
