Customer experience | Sales, Customer Insights,...

Unlock fields in editable grid

(1) Share

Report

Posted on by John Mongol

Hi,

Is it possible to make every field editable in editable grid? for example I have created a custom field and on the editable grid it shows as locked.

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Leah Ju Microsoft Employee on at

Like (1)

Report

Unlock fields in editable grid

Hi Partner,

Yes, this is by-design.

There are certain restrictions on inline editing based on the type of products in the subgrid:
- If the product in the subgrid is an individual product and an existing product from the product catalog, all fields except the Quantity and Discount are locked for editing.
- If the product in the subgrid is an individual product and a write-in product from the product catalog, all fields except the Product Name, Quantity, and Discount are locked for editing.
- If the product in the subgrid is a product bundle or an optional product of a bundle, all fields except Quantity and Discount are locked for editing.
- If the product in the subgrid is a required product from an existing product bundle, all fields in the subgrid view are locked for editing.

Was this reply helpful? Yes No
John Mongol 89 on at

Like (0)

Report

Unlock fields in editable grid

My question is not about the design, but if its possible to make them not restricted somehow?

Was this reply helpful? Yes No
Suggested answer

Leah Ju Microsoft Employee on at

Like (1)

Report

Unlock fields in editable grid

Hi John,

Because it's by-design, it's impossible to change it.

Perhaps you could add another editable sub-grid yourself, rather than using the OOB sub-grid, , then you can edit columns in the new subgrid:

Was this reply helpful? Yes No
Leah Ju Microsoft Employee on at

Like (0)

Report

Unlock fields in editable grid

Hi Partner，

Was my answer helpful?
If it was helpful, can you verify it?
If you have any questions, please feel free to contact me.

Regards,

Leah

Was this reply helpful? Yes No
Suggested answer

Community member 8 on at

Like (3)

Report
Unlock fields in editable grid

Hi John,

This can be done with Javascript.

In your js file , copy this function :

function lockUnlockFields(executionContext,fieldName,lockunlock) { var formContext = executionContext.getFormContext(); let objEntity = formContext.data.entity; objEntity.attributes.forEach(function (attribute, i) { if (attribute.getName() == fieldName) { let attributeToDisable = attribute.controls.get(0); attributeToDisable.setDisabled(lockunlock); } }); }

Then, create a function to unlock a list of fields of your choice , for example :

function unlockMyFields(executionContext) { var formContext = executionContext.getFormContext(); var fieldNames = ['unit','discountpercentage'];//put here the logical names of the fields to unlock for(i=0;i < fieldNames.length;i++) { lockUnlockFields(executionContext,fieldNames[i],false); } }

Now, you have to qo to the opportunity form , select the subgrid of the products and in the events tab , choose the event 'OnRecordSelect' and put your function there (unlockMyFields).

Regards,

Mounir

Was this reply helpful? Yes No

Join the conversation

Community site session details

Unlock fields in editable grid

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates

Community site session details

Unlock fields in editable grid

Helpful resources

Quick Links

Responsible AI policies

Pallavi Phade – Community Spotlight

Congratulations to the September Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates