# Kinetic Dashboard Grid - How to create editable fields? (boolean, number field types...) **URL:** \ **Category:** Kinetic ERP\ **Tags:** dashboard, kinetic\ **Created:** [October 7, 2022, 6:09pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174 "2022-10-07T18:09:50Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![yluo](https://www.epiusers.help/user_avatar/www.epiusers.help/yluo/32/56696_2.png) [@yluo](https://www.epiusers.help/u/yluo)\ **Post date:** [October 7, 2022, 6:09pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/1 "2022-10-07T18:09:50Z")
Hello, In my dashboard, I added a grid. The grid is binding to a BAQ. It looks like I cannot change the property of BAQ columns to be editable. I tried to go to **Grid Model** → **Columns** , and check “ **editable** ”, but it did not work. This is my dashboard, ![image](https://www.epiusers.help/uploads/default/original/3X/1/4/14db4545f4cf766098bd1f91e139449013eedf01.png) The first column called “Select” is editable because I mark it as a Selector, but for the other two columns, I could find a way to make them editable. Yixin ---
**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\ **Post date:** [October 7, 2022, 7:20pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/2 "2022-10-07T19:20:57Z")
You gotta tell it what to do. It’s not smart enough to wire it up for you at this time. Create a view to hold the data for the update. ![image](https://www.epiusers.help/uploads/default/original/3X/b/1/b19621312f850a38cfab09c75b879be04886468c.png) Set the column(s) as editable after adding them to the grid model in Panel \> Grid Model \> Columns ![image](https://www.epiusers.help/uploads/default/original/3X/1/a/1ac1755c4b59859ad2cab6296cdea96c88841644.png) ![image](https://www.epiusers.help/uploads/default/original/3X/f/3/f35df0c068f597c75e7fd9bb450a0102636362e7.png) Set the view and the BAQ ID on the provider model. ![image](https://www.epiusers.help/uploads/default/original/3X/7/d/7dc0e142e23b76a31a3ae255fc65586c126af14f.png) Create a save button for your BAQ panel grid. Chose any icon you want from here: [Material Design Icons (pictogrammers.github.io)](https://pictogrammers.github.io/@mdi/font/3.9.97/) The syntax is mdi + whatever the code is in that link. So it’ll always be something like `mdi mdi-ghost` or `mdi mdi-whatever-else` ![image](https://www.epiusers.help/uploads/default/original/3X/6/b/6b036d7e7b930748a7881cca9cb0faf54fc7385e.png) Create an event for that save button. ![image](https://www.epiusers.help/uploads/default/original/3X/4/1/41129e72d8b4b9a8a64ff4d0a7b6b87414c2fcd3.png) Have it call the erp-baq widget. ![image](https://www.epiusers.help/uploads/default/original/3X/7/d/7d84c2d4ab0e013af065abace3feb1fefb98d1cc.png) Set the update options. ![image](https://www.epiusers.help/uploads/default/original/3X/3/b/3b12a7103a0d598f47ea6a2f7fc8a38a353b373e.png) You should probably wire up a refresh as well; I did not do that here. My uBAQ displays the top 10 ‘Purchased’ records. You can see that when I update 10055 to ‘Manufacture’ and refresh, it disappears off of the list confirming the update worked. ![UBAQ_Kinetic](https://www.epiusers.help/uploads/default/original/3X/f/0/f09834d9a0098ad0bf4c4c62fa1e57db965ad0c3.gif) * * * Here–throw a refresh in there too. ![image](https://www.epiusers.help/uploads/default/original/3X/c/9/c950fe35a0c19bd91632007861b34407e28ec738.png) ---
**Author:** ![utaylor](https://www.epiusers.help/user_avatar/www.epiusers.help/utaylor/32/64664_2.png) [@utaylor](https://www.epiusers.help/u/utaylor)\ **Post date:** [October 7, 2022, 7:24pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/3 "2022-10-07T19:24:16Z")
When does Epicor start paying you per post? You deserve at least $100 a post where you describe, document, and demonstrate it… ---
**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\ **Post date:** [October 7, 2022, 7:24pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/4 "2022-10-07T19:24:59Z")
Who says they’re not? 😃 \*\*\* Epicor… if you’re listening. I take Venmo or direct deposit. 🙂 ---
**Author:** ![TDray](https://www.epiusers.help/user_avatar/www.epiusers.help/tdray/32/42812_2.png) [@TDray](https://www.epiusers.help/u/TDray)\ **Post date:** [October 10, 2022, 4:28pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/5 "2022-10-10T16:28:12Z")
Hannah is one of the most helpful people on these forums and is never condescending or rude to the people who ask questions. Instead, posts are always helpful responses filled with tons of information. ---
**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\ **Post date:** [October 10, 2022, 4:29pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/6 "2022-10-10T16:29:38Z")
![](https://media.giphy.com/media/j2Z8ktYcHlTplAuIQf/giphy.gif) ---
**Author:** ![yluo](https://www.epiusers.help/user_avatar/www.epiusers.help/yluo/32/56696_2.png) [@yluo](https://www.epiusers.help/u/yluo)\ **Post date:** [October 10, 2022, 4:32pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/7 "2022-10-10T16:32:53Z")
Thank you Hannah! I really appreciate your time and detailed screenshots for my question. ---
**Author:** ![phoenix](https://www.epiusers.help/letter_avatar_proxy/v4/letter/p/0ea827/32.png) [@phoenix](https://www.epiusers.help/u/phoenix)\ **Post date:** [October 27, 2022, 8:34pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/8 "2022-10-27T20:34:21Z")
> [@hmwillett](#): > > You gotta tell it what to do. It’s not smart enough to wire it up for you at this time. What if I don’t want to populate grid via Provider Model i.e. because I can’t set there BAQ parameters or my refresh is linked to another stand-alone field? In that case I would like to 1. Populate custom view with data in separate event 2. In the grid provide only EpiBinding (to my view) 3. Still be able to have some (not all) columns editable? I found out that in above scenario when whole grid is not mark as editable and only some fields are mark as editable then I still can’t edit them. From the other hand when I will mark whole grid as editable then I can’t make particular columns as read only. Do you have any hint or solution for that? ---
**Author:** ![hmwillett](https://www.epiusers.help/user_avatar/www.epiusers.help/hmwillett/32/93207_2.png) [@hmwillett](https://www.epiusers.help/u/hmwillett)\ **Post date:** [October 31, 2022, 6:56pm UTC](https://www.epiusers.help/t/kinetic-dashboard-grid-how-to-create-editable-fields-boolean-number-field-types/95174/9 "2022-10-31T18:56:44Z")
> [@phoenix](#): > > What if I don’t want to populate grid via Provider Model i.e. because I can’t set there BAQ parameters or my refresh is linked to another stand-alone field? You should be able to do all of that. Still set the binding to your view in the Provider Model, just leave out the BAQ ID at the bottom. Create an event to populate the BAQ Data initially. > [@phoenix](#): > > Do you have any hint or solution for that? ![image](https://www.epiusers.help/uploads/default/original/3X/b/e/befa46e4be14e2379142c7a75c1ef530cdcab1ba.png)