Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

(0) Share

Report

Posted on by Siddhant Singh

518

Hello all,

Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

Thank You

Siddhant

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Khurshid Wali 928 on at

Like (0)

Report

RE: Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

Hi Siddhant Singh,

Yes, we can change the Value using X++ method. but we have to refresh the form to update its value on form.

regards,

Khurshid wali

Was this reply helpful? Yes No
André Arnaud de Cal... 299,860 Super User 2025 Season 2 on at

Like (0)

Report

RE: Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

Hi Siddhant,

Can you explain your scenario? Possibly an edit method on the form would be an easy solution.

Was this reply helpful? Yes No
Siddhant Singh 518 on at

Like (0)

Report

RE: Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

Hi Andre,

Previously forced to “No” the property “AllowEdit” of both ShippingDateRequested and ReceiptDateRequested of SalesTable datasource on SalesTable form.

We are now asked to let the user modify those data if bfpSalesType.field is activated for the sales type of the specific order then user can modify those 2 dates.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

If the original AllowEdit:No in the table fields is something you have done, why not just remove that change and allow user to edit those fields. Then on form level you can set AllowEdit to No if your condition is not met.

If that's not feasible you have to use an edit method, or a dialog to let the user change the value.

Was this reply helpful? Yes No
Siddhant Singh 518 on at

Like (0)

Report

RE: Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

Hi Nikolaos,

AllowEdit:No is on Form Level.

I have written this code on Data Source level.

and then called it on modified method of the field.

public void enableFields()

{

SalesTable_ds.object(fieldNum(SalesTable, ShippingDateRequested)).enabled(bfpSalesType.Field);

SalesTable_ds.object(fieldNum(SalesTable, ReceiptDateRequested)).enabled(bfpSalesType.Field);

}

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

RE: Can we edit a field on a form if its allow edit property is "No" on the data source table of that field using code.

Ok, then just set AllowEdit:Yes on the form level and change AllowEdit of those fields based on your criteria.

Please note that it's not enough to call your logic in the modified method of the field. You also need to call it in the active method of the data source. This way the logic is run every time the user selects another sales order.

Was this reply helpful? Yes No