Jiwa

Hi All

Is there a way to lock or even hide custom fields in the sales order screen under specific conditions such as until an order has been saved?

Hi Stuart,

The FormatCell methods of the CustomField and CustomLineField classes can we used to lock cells or hide rows.

Attached is an example.

The important bit is shown below:

Code: Select all

public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue)
    {
      if ( CustomField.PluginCustomField.Name == "Test")
      {
         // lock custom field if sales order not saved yet
         var salesOrder = (JiwaFinancials.Jiwa.JiwaSales.SalesOrder.SalesOrder)BusinessLogicHost;
         if (salesOrder.InsertFlag)
         {            
            GridObject.ActiveSheet.Cells[Row, Col].Locked = true;
         }
      }
    }

Mike

Hi Mike,

Thanks for the help and the example to lock the field, after a little investigation and for the sake of completeness, the row can be hidden by changing

GridObject.ActiveSheet.Cells[Row, Col].Locked = true;

to

GridObject.ActiveSheet.SetRowVisible (Row, false);