Is Customizable Flag

apollo7
apollo7 used Ask the Experts™
on
This was posted on the Forcaya blog (http://www.focaya.com/blog/?p=73) and reviews using a simple update query change ISCUSTOMIZABLE to 1 from 0 to allow you to make changes to forms and views that are not normally shown.  See below:

update ENTITY
set ISCUSTOMIZABLE = 1
WHERE NAME = 'ProductPriceLevel'

My problem is that whenever I make a change (like add a field or enable an onload event), I get an error when trying to publish the change.  I assume (and some of this is discussed in comments to the post) that because the entitiy was not intended to be be customized in the first place, that certain changes are not going to be published.

I am trying to add a text field and populate it using an onload event for productpricelevel.  Has anyone discovered the problem I am having (for any entity) and, more importantly, devised a workaround to allow changes to be published in these normally non-modifiable forms?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Chief Technology Ninja
Distinguished Expert 2018
Commented:
Hi apollo7, 

Generally when I need to make such changes I prefer using JS and then inject my change into ASPX pages rather than going from Database side.
So in you case what'd I do is I will find the ASPX responsible to display desired data and at the end of it I will put a script that will inject a textbox or any other DHTML control with the value I want.
We can retrieve values with the tricks we discussed earlier.
Regards,
Chinmay




Author

Commented:
Chinmay

That sounds workable for me.  I will give it a try and let you know if I have any problems or questions.

Thanks very much
The previous comment qualifies as an unsupported customization and you will not be able to upgrade Microsoft CRM or get support because of it. I would discourage other members from using this type of a change.
The rule of thumb is:
If you manipulate the database directly or change any web files on the server, you are no longer supported.
Chinmay PatelChief Technology Ninja
Distinguished Expert 2018

Commented:
Hi preitmeyer,
I appreciate your effort to bring this to notice but in my 3 years+ deployment of CRM 4.0 Solutions[Was part of TAP 2 :)] I've NEVER EVER deployed a single solution that doesn't have unsupported customization.
Its not that I was not aware of a particulare feature of CRM its just businesses are demanding. And boy they are creative.. I have catered from : I want a color code on title bar of my contact form... to customized Advanced Find dialogues and even a Workflow Wizard that makes your life easier when you have to add 100+ dyamic fields.
Also defintion of Support sometimes is : Whether you as a developer take the responsibility to stand by the code you have developed.
In my case,If I am providing a solutoin that is unsupported I let my client know about it and I take gurantee to support it from my side and you can always remove that piece of code and take it to Premiere support.
I never recommend making changes to the database but ASPX and Scripts are always fun to play with :)
Regards,
Chinmay

Author

Commented:
I think that what chinmay said about "support" is well taken / when you work for large business.as I do it is not always possible to do it by the book / that is why you need to find an expert like chinmay that stands by his work and informs you any risks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial