I’m using a test set of data to understand how to conditionally format a set of repeating group numbers that will be representative of target met or not met status for the day.
What I’m looking to do is to get the drop-downs to pull only the data for the month and year from that set, and then display whether or not the corresponding day’s target was met. There will be multiple production lines for the set I’ll be working with in the future, so what I’m trying to figure out right now is how to filter just the Autoline 1 data out with the month and date, and then if the day’s target was less than 5.0 it’s red, or equal to or greater than 5.0 it shows green.
I’m still fairly new to this, so if there’s not enough information here to get you a good idea of how I have this set up to know what to do next, let me know and I will get you more screenshots.
there are a few ways to populate data. You can actively push data into the repeating group by setting its source based on actions, or you can configure the repeating group to “do a search” on its own.
I dont fully understand what you are trying to do but it sounds like filtering.
In the case of filtering one strategy is to have a workflow that contains a step which represents every type of filter you can have. Each user interface element triggers that same workflow when it changes.
the first step in the workflow would be a basic do a search for to get your base data and push it into a “custom state” which is really just a variable. I like to keep my custom states at the page level so they arent hidden all over. You can set your repeating group source to be that custom state. When the custom state changes, then the repeating group will automatically change.
Subsequent steps would be element->set states where you get the existing list, filter it based on whatever criteria, then set the state. Typically you would only do it when the particular dropdown or whatever has data in it so you know that filter is active.
this video is a bit long and tedious but goes into the method
Thank you. I figured it would be based on filtering, but it looks like the way I need to display it is a convoluted means of filtering it…but alas, that’s what I have. I will watch the video and see how much it is able to answer for me.
So essentially what I need is for it to show me April 1st as Green instead of grey (Line 1 = 5.2, target met), then April 2nd as Red instead of grey (Line 1 = 4.8, target not met), and all other days remain grey because they have no data. And if I were to change either the Month or Year drop-down to any other option within those drop downs, the numbers would revert back to grey because there is no data in that set to match up with.
The day numbers in the repeating group are just an Option Set of numbers 1 through 31. And the Month and Years are their own individual option sets doing the same with Months having an attribute of a month number, and Years having an equivalent attribute number value to the year. In that Data set pictured above, the Month and Year types are both from their same respective Option Set.
