Jump to content
Developer Wiki and Function Reference Links ×

How to disable/hide menu items in worksheets?


Recommended Posts

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!

Link to comment

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.

Link to comment

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.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...