Kinetic Dashboard Grid - How to create editable fields? (boolean, number field types...)

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 ModelColumns, and check “editable”, but it did not work.

This is my dashboard,

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

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.

Set the column(s) as editable after adding them to the grid model in Panel > Grid Model > Columns


Set the view and the BAQ ID on the provider model.

Create a save button for your BAQ panel grid.
Chose any icon you want from here: Material Design Icons (pictogrammers.github.io)
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

Create an event for that save button.

Have it call the erp-baq widget.

Set the update options.

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


Here–throw a refresh in there too.

4 Likes

When does Epicor start paying you per post?

You deserve at least $100 a post where you describe, document, and demonstrate it…

2 Likes

Who says they’re not? :smiley:

*** Epicor… if you’re listening. I take Venmo or direct deposit. :slight_smile:

2 Likes

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.

5 Likes

1 Like

Thank you Hannah! I really appreciate your time and detailed screenshots for my question.

2 Likes

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?

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.

image

1 Like