Interacting with Table Rows

[Anonymous]

So here's a request I got from some users....

They typically leave their QV app open on one screen that has a pivot table with open orders that contain errors that they are investigating in order to fix in our ERP system, which is open on their other screen. They would like to have a quick (one click) way to mark each order in the table as having been fixed. They understand that QV doesn't write data, they are just looking for a visual aid while they work. I showed them that they can right-click and use custom cell formatting to change the color of a cell. This would work but that's too many clicks - they need to work faster than that. I thought about using an inputfield in the table but that seems to be a little awkward and doesn't seem to work well with pivot tables. Does anyone have any suggestions how I might be able to accommodate this request?

[#2]

dirty but maybe usefull??

[Anonymous]

Interesting. Can you explain what's happening when the macro fires?

[#4]

it''s a very Quick and Dirty document

but it is concatinating rowno's in a variable (string) So value variable = old value || chosen rowno(). Based on this string background color is filled for dimension with index() function.

[Anonymous]

That might actually work. If I could get it to work more like a toggle - color on, color off - and not select the cell value when clicked. I don't know if there is anyway to do the latter though.

[#6]

the toggle function has to be possible

i will have a look tomorrow!

[#7]

Now with toggle function

[Anonymous]

That may work. I'll run it past my users tomorrow. Thanks for your help!