Master/Detail disable field submit

David_Kimz · Post by **David_Kimz** » Sun Mar 12, 2017 8:28 pm

Hi I have a field which shouldn't appear on Master/Detail editpage because its a computed column. How do I disable it not to be part of the insert statement.

have tried this in PageRender of detail list page, it hides the field but still the get an error in SQL where the column is being inserted with a NULL value:
if ($this->getCurrentMasterTable() == "Sale"){
$this->SaleStatusID->Disabled = TRUE;
$this->SaleStatusID->Visible = FALSE;
}

Thanks in advance

mobhar · Post by **mobhar** » Mon Mar 13, 2017 8:58 am

Just remove that code, then disable "List" from "Fields" setup -> "List Page", and regenerate ALL the script files again.

David_Kimz · Post by **David_Kimz** » Tue Mar 14, 2017 4:51 am

Problem is I need that field to display on list page of Detail table, so I used your idea and unchecked the list option for SaleStatusID then created a custom field <DummySaleStatusID> taking the SaleStatusID in Expression and now works as required.
Thanks