Ok, my topic for this post is editable grids. Microsoft do have such a beast but it only works on the main entity’s, not custom entity’s.
What are the solutions? Firstly we need to decide what you want it for and what kind of CRM developer you are, in the next few lines I will develop a profile with you to help make a decision on the direction you can go based on the answers. Ps I hope I don’t offend any one with my terms or analogy’s its all in good fun. 🙂
1st Question: What do I need a grid for and where in CRM will I use it?
Grids are fantastic for quick repetitive data input of child records, clicking in to a form, waiting for it to open and edit, then close is quite unproductive.
Ok, question time! Grab some paper and keep score. I will have a chart at the end to help you decide on your grid solution.
- Do you need a solution with no Coding ?
- Are you ok to hard code the grid ?
- Do you just need a grid on one entity ?
- What is my budget ?
- Do I need advanced features in the grid like option set or lookup fields ?
- Do I need just basic Text, Numbers and calculated fields ?
- Do I know how to use Java script and I mean more than hide a field, do you understand Objects and arrays ?What is the time frame for this grid ?
- Do I want something with backup support or I will do the support ?
Ok that’s about all we need to decide what way to go.
If you answered YES to question 1 there are some grids out there, some are brilliant most come with a big price tag but time is money and you get what you pay for.
Well the tutorial series are probably not for you but hey we all start somewhere so feel free to dive in and learn as much as you can it’s what I do.
If you answered YES to question 2 then the tutorial series could be just what you need. Also some of the more advanced features in the paid grids do need this skill. So check out the tutorials. If you find them interesting that’s great!
If you answered YES to question 3 this tutorial series will help you create a grid for a single entity. The code can be reused but each grid for each entity is hard coded into its own web resource. This can be time consuming if you needed 20 grids.
If you answered “not much lol” to question 4 Ok if you don’t have thousands to spend and just need a cheap option with no ongoing support fees this tutorial series is not for you.
If you answered YES to question 5 this basic tutorial series will not contain these features so look at the paid grids for now I will offer more advanced tutorials at a later date.
If you answered YES to question 6 this basic tutorial series will cover this and the basic CRUD Create, Retrieve, Update and Delete as well as calculate totals.
If you answered NO to question 7 then look at the paid grids or use this series as a learning tool but you will need to skill up on Java script. A good place to start is Treehouse they have good basic tutorials to Java Script.
If you answered no hurry to question 8 then stay tuned this tutorial series will take some time to complete, alternatively paid grids is your option.
If you answered YES to question 9 this is not for you this is offered as an educational tutorial to help more people understand the power of JQgrid and CRM2015/2016 SKD Rest end point and has no support.
Ok now we know where we are at let’s get started with the first tutorial it will be understanding the OData SDK endpoint file.