Is there any event in Application Studio to detect that a user clicked in a specific grid cell before editing it?

Kinetic ERP
1

I want to be able to retrieve information in Epicor when a user click in a specific cell. For example, in a timesheet app, when the user click in the monday cell for a specific job, it becomes editable and I want to retrieve the current labor notes for that date and show it somewhere in the page. That way, the user is able to recognize that labor entry and is able to change the hours if needed based on that information

It used to be possible in Classic because the old version of our app did this but I can’t find any event to hook it up to

1 Like
2

RowChanged

3 Likes
3

RowChanged will only trigger the first time I click on this row, no ? Because in my example, I could be clicking on monday, then wednesday, friday, etc. which means that I want the event to trigger 3 times and not just 1 time

1 Like
4

Yeah that won’t work then.

1 Like
5

Are all the cells in the grid the days of the week? Does your dataview have a week number or week ending date or something you can key off? If it does you could use the row changed event to pull all the data for the week?

Then just pivot it so it aligns with your other data.

2 Likes
6

I thought about the same solution and so far, it’s the only thing that would be working. However, it’s not something I love because that approach means a new grid but with multiple comments at the same time it will be hard to find the one applicable to the punch

Also, it might be hard to align exactly with the columns because the grids are resizable and there are a lot of columns in the one with the days of the week before we arrive to the days

I fear there is no way to do this!

1 Like
7

Well, you could make the contents of each grid cell a link. And then use a grd click event.

2 Likes
8

Throwing an idea out there… Not knowing how this would fit into your implementation…

You could add a combo box with the days of the week as a selector: Sun-Sat or M-F, then have events on your grid Row Changed and on your combo binding Column Changed to update the values you’re wanting to see/update

2 Likes
9

Good idea but I’m not sure it would be user-friendly. Right now, it’s a grid where people click on TAB or ENTER when they add or update labor entries. Adding the need to select a combo box with the mouse each time would break the flow

Most of the times, the rows will already be in the grid since there are ‘favorites’ that remains there each week with 0h each day of the week and the person only enter the number in the day he needs to add time

2 Likes
10

Yeah i saw that there was an event on that but I didn’t know it was only a link. I wonder if that would work somehow

1 Like