Stefan Bender Posted February 11 Share Posted February 11 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! Quote Link to comment
JBenghiat Posted February 12 Share Posted February 12 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. Quote Link to comment
Stefan Bender Posted February 12 Author Share Posted February 12 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. Quote Link to comment
Recommended Posts
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.