Hello,
I have a kinetic dashboard I built that uses a checkbox to filter the records.
When I first run the dashboard, it returns all records instead of just the records marked false.
I am assuming the value for the checkbox is null or undefined.
How would I set that to be false from the start?
I am still learning so please be detailed if possible.
Any help is appreciated!
Have you tried an on form load event to set the field?
I am unsure on what to use to do that.
Are you talking about Window onLoad?
If so, what action should I use?
How do I set that action up?
Any help is appreciated.
Do you need the ability to view all the records on the dashboard, or do you only ever want to show the false ones?
If you only ever want false, then you probably want to change the event that loads the records to include that in the Rest call.
If you want to have both available, your best bet would probably be a couple views on the grid showing the results that show All or False records.
Give us some more details so we can guide you to the right solution.
I have puzzled out what I needed and it seems to work.
What I did was do a ‘row-update’ on the Window_OnLoad’ event.
Under row-update->Parameters->Columns: I set the column to:
After saving and testing, the values returned in the grid were all set to false as intended and when I checked the box, it updated the grid with all the true records.
This is exactly how I wanted it to work.
Hopefully this will help someone else in the future.
I appreciate you replying Cory. It helped set my thoughts on the right track.
Nice to see you got it resolved before I could get back to you.
This post is very helpful. My only issue now is trying to set multiple checkboxes as false at once. No matter how I make the row-update, it only does one. I tried adding another column to the row-update parameter, adding another parameter, and adding a new row-update entirely.
Hello,
I use Taming the Dashboard Dragons DashboardTemplate for new dashboards I create.
Not sure if they have anything special added in on the Windows_onLoad event.
I copied it and added 3 checkboxes.
Is set each EpiBinding to: SearchFilters.CB1, SearchFilters.CB2, SearchFilters.CB3
Before I set up the Windows_onload, I debugged to see if they were set up yet.
They were not.
I then added a row-update to the end of the Window_onLoad.
I then clicked ‘Parameters’ and clicked the plus sign to add a column.
Then I clicked the ‘Columns’ and clicked the plus sign add add the first check box.
I set the Epic Binding to: SearchFilters.CB1
Note that SearchFilters is the dataview name I use to hold the filter fields and CB1 is the Checkbox.
I then set the value to false.
I clicked the plus again and added the next as: SearchFilters.CB2
Set the value to false.
Same for the CB3.
I saved it and then previewed.
Now in debug when it loads it shows the 3 fields as false.
Using her DashboardTemplate has made life so much easier for me.
Weird, I did all of that and it still doesn’t work. Thank you though!
