Hello Gliders! I am building an app for a restaurant which has 10 locations and each location has three areas where employees work: Kitchen, Lounge and Office. The manager of each location will assign employees and work hours in each area using a Data Grid component. All locations are using the same glide table called Scheduling. In the layout, the manager selects his location and then sees the scheduling in 2 data grids: Kitchen and Lounge. The first column of each data grid is the name of the employee and it is a choice component so that the manager can choose among employees only of that location and area. But the problem is that there is NO FILTERING option in the data grid columns (please see image attached). How can I solve this issue?
Create a Query column, use the selected location as a filter, and use that as the source of the choice column.
Hello Darren thanks for your comment. But tried that already… the source cannot be a query column, it does not show as an option in the configuration window.
It does for me…
BUT… in my testing the Choice option doesn’t work at all in the Data Grid, in the sense that it can be configured but nothing can be selected. So something is not right. I’m going to do some more testing.
@mbraunperu - after doing some more testing with this, I have identified a bug (which has been reported). You can select a Query column as the source for a choice column in a Data Grid - as long as it is a multiple match Query. BUT… there is a bug in the Data Grid that doesn’t allow you to select any items.
So until that bug is fixed, I think you are a bit stuck.
One possible workaround would be to use a helper table to construct a list of options based on the selected location, and then use that as the source. That’s a bit fiddly, but I expect it would work.
Update: I tested the above workaround, and it does work.
Thanks a lot Darren! Based on your experience, how long do reported bugs take to get fixed, approximately?