How to disable/hide menu items in worksheets?

[Stefan Bender]

If a worksheet cell is referring to a PIO record field of type kFieldPopup, the user sees all popup choices if they click on the cell and the pull-down menu is shown. However, depending on other PIO settings, sometimes not all menu choices are possible so they should either be hidden or disabled. How can we do this? Imho this should be possible either in AllowWorksheetEdit or in another (non-existing?) function that is called directly before the menu actually is displayed and would allow the plug-in to disable/hide unnecessary options. Thanks for any help!

[JBenghiat]

I believe these values come straight from the data record, and we do not have a way to hook into the process between the record and the worksheet display. If you just want to limit the available fields, you could eliminate the values from the value list and just add them to the menu in Object Info, but I don't think there's a way to have the values changed based on other data.

[Stefan Bender]

Hi Joshua, thanks a lot for your response! Yes, these values come from the data record, but there should be a way for the PIO to filter out unnecessary options when users actually click on the menu thus opening it. We don't intend to alter the choices list, but we need to prevent users from selecting one that is not available atm (both in OIP and worksheet cell). Imho this is a severe limitation/bug.