Since I’m working on this I thought I’d post progress in case anyone else has similar needs or any more ideas…
Thanks to jsanzone for their nugget in https://bobj-board.org/t/116974 of
I’ve now used this to build
=If(Substr(DrillFilters([Sub Business Unit]);1;1)>" ";Max([Area Office]);If(Substr(DrillFilters([Business Unit]);1;1)>" ";Max([Sub Business Unit]);If(Substr(DrillFilters([Company]);1;1)>" ";Max([Area Office]);If(Substr(DrillFilters([Group]);1;1)>" ";Max([Business Unit]);"Drill Path?"))))
This gives me the value of the Section at any point in the Drill except the first one, i.e. which Drill Path my user has taken.
I can then pass that value into an openDocument.jsp code.
I’m still stuck on identifying which Drill Path, which is the main thing I need to know.
Actually, reading the above back, I don’t know if I’ve made progress or not
Neil Phillips (BOB member since 2002-08-22)