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)

Sort by

Suggested answer

Leah Ju Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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 91 on at

Like (0)

Report
Copy link

Link copied!

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
Copy link

Link copied!

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
Copy link

Link copied!

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

CU27040929-1 8 on at

Like (3)

Report
Copy link

Link copied!
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

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July 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

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Women in Power Builds Momentum

Congratulations to the July Top 10 Community Leaders

Subscribe to this forum!

Select categories

Leaderboard > Customer experience | Sales, Customer Insights, CRM

Featured topics

Product updates