How to Conditionally Hide a Tab in a Form Based on a Custom Field in Another Form

Hi ​@RKarunarathne51 ,
Try with RowSelecting or RowSelected event. If you need to handle changes to the InventoryID field then try below code on FieldUpdated event.

public class AMProdOrderEntryExt : PXGraphExtension<AMProdOrderEntry>
{
    protected virtual void _(Events.RowSelecting<AMProdItem> e)
    {
        if (e.Row == null) return;
        
        var prodItemExt = PXCache<AMProdItem>.GetExtension<AMProdItemExt>(e.Row);
        if (prodItemExt == null) return;

        // Query the InventoryItem record
        InventoryItem inventoryItem = PXSelect<InventoryItem,
            Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
            .Select(Base, e.Row.InventoryID);
        
        if (inventoryItem != null)
        {
            // Get the extension for InventoryItem
            var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventoryItem);
            if (inventoryItemExt != null)
            {
                // Set your custom field based on the InventoryItem's custom field
                prodItemExt.UsrCustomField01 = inventoryItemExt.UsrYourStockItemField;
            }
        }
    }
}

Hope it will work .

Hi ​@noorula77 ,

I tried using the RowSelecting and RowSelected event handlers, but they were not suitable. Then I tried using the FieldUpdated event handler, but it was not invoked. I need to show or hide a tab for different production orders. When the user changes the prodOrdID (by using a selector or by clicking Next and Previous), this event handler should be triggered. What event handler is suitable for this?

Hi ​@RKarunarathne51 ,

The key points about this solution:

1. RowSelected is the right event because it:
   • Fires whenever a row is selected, including when changing records via selectors or Next/Previous buttons
   • Used SelectSingle instead of Select for better performance since we only need one record
   • Replace "YourTabName" with your actual tab name from the ASPX page
   • Replace UsrYourStockItemField with your actual custom field name from InventoryItemExt

public class AMProdOrderEntryExt : PXGraphExtension<AMProdOrderEntry>
{
    protected virtual void _(Events.RowSelected<AMProdItem> e)
    {
        if (e.Row == null) return;

        var prodItemExt = PXCache<AMProdItem>.GetExtension<AMProdItemExt>(e.Row);
        if (prodItemExt == null) return;

        // Query the InventoryItem record using PXSelect
        var inventoryItem = PXSelect<InventoryItem,
            Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
            .SelectSingle(Base, e.Row.InventoryID);

        if (inventoryItem != null)
        {
            // Get the extension for InventoryItem
            var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventoryItem);
            if (inventoryItemExt != null)
            {
                // Set your custom field based on the InventoryItem's custom field
                prodItemExt.UsrCustomField01 = inventoryItemExt.UsrYourStockItemField;

                // Get the tab item
                var tab = Base.TabView.Items["YourTabName"];
                if (tab != null)
                {
                    // Set the tab visibility based on your condition
                    tab.Visible = prodItemExt.UsrCustomField01 == true;
                }
            }
        }
    }
Hope it will work.

Hi ​@noorula77 ,
In the RowSelected event handler, modifying the value of a field directly is not allowed. Therefore, the following code line cannot be executed. This is why I mentioned that RowSelected cannot be used.

prodItemExt.UsrCustomField01 = inventoryItemExt.UsrYourStockItemField;

Do you have any suggestions for changing the value of the field using an alternative method?

Hi ​@RKarunarathne51 ,
 

This solution splits the responsibilities:

1. RowSelecting: Handles the data modification before the row is added to the cache
2. RowSelected: Handles only the UI updates after the data is loaded

   protected virtual void _(Events.RowSelecting<AMProdItem> e)
       {
           if (e.Row == null) return;

           var prodItemExt = PXCache<AMProdItem>.GetExtension<AMProdItemExt>(e.Row);
           if (prodItemExt == null) return;

           // Query the InventoryItem record using PXSelect
           var inventoryItem = PXSelect<InventoryItem,
               Where<InventoryItem.inventoryID, Equal<Required<InventoryItem.inventoryID>>>>
               .SelectSingle(Base, e.Row.InventoryID);

           if (inventoryItem != null)
           {
               var inventoryItemExt = PXCache<InventoryItem>.GetExtension<InventoryItemExt>(inventoryItem);
               if (inventoryItemExt != null)
               {
                   // Update the field value in RowSelecting
                   prodItemExt.UsrCustomField01 = inventoryItemExt.UsrYourStockItemField;
               }
           }
       }

       // Handle UI updates in RowSelected
       protected virtual void _(Events.RowSelected<AMProdItem> e)
       {
           if (e.Row == null) return;

           var prodItemExt = PXCache<AMProdItem>.GetExtension<AMProdItemExt>(e.Row);
           if (prodItemExt == null) return;

           // Get the tab item and update visibility
           var tab = Base.TabView.Items["YourTabName"];
           if (tab != null)
           {
               tab.Visible = prodItemExt.UsrCustomField01 == true;
           }
       }
   }

Alternatively, if you need more control over when the field value changes, you could also consider:

[PXDefault(typeof(Search<InventoryItemExt.usrYourStockItemField,
    Where<InventoryItem.inventoryID, Equal<Current<AMProdItem.inventoryID>>>>))]
[PXUIField(DisplayName="Custom Field", Visible = false)]
public virtual bool? UsrCustomField01 { get; set; }

OR

[PXFormula(typeof(Selector<AMProdItem.inventoryID, InventoryItemExt.usrYourStockItemField>))]
[PXUIField(DisplayName="Custom Field", Visible = false)]
public virtual bool? UsrCustomField01 { get; set; }

If possible please share screen shot of the screens.

Hi ​@noorula77,

Thank you for your help. Following code lines cannot be executed. 

var tab = Base.TabView.Items["YourTabName"];

tab.Visible = prodItemExt.UsrCustomField01 == true;

Specially the Base.TabView.Items["YourTabName"] and tab.Visible lines. 

Do you have any suggestions? Thank you

The correct way to hide a tab is to set View.Cache.AllowSelect = false as ​@aiwan showed; you may be able to use the events that ​@noorula77 suggested to execute this.

Hi ​@darylbowman ,

I created two tabs using two custom views. When I use the View.Cache.AllowSelect = false statement on one view, both tabs are hidden. Three out of the four DACs used in both views are the same, and only one DAC is different. Do you have any idea why this happens?

I believe it is likely that you will experience inconsistencies in this case because of how Acumatica handles the cache. I can’t explain the reasons behind it because it’s not something I understand that well.

​@Dmitrii Naumov - Am I right? Does he need an alias DAC or is that just for multiple joins in the same view?