I’m sure there’s multiple ways to solve for this but I couldn’t find a solution in the gallery with my searches and hoping to leverage the collective brainpower here!
Problem to Solve:
We have a running list of meetings for a project of which there are clear actions identified from each meeting. Is there an easy way to surface those in a single filtered view if we’re tracking the actions as a bulleted checkbox list in a row for each meeting?
Example here, is there a way to filter just the highlighted (i.e. unchecked items)?
what you can do is create an additional column that checks if all check boxes are checked or not and filter on that column. You have to apply a bit of JSON. Steps in the blog below.
However an easier way is just one row and one checkbox, than everything is simple again.
@Christiaan_Huizer thanks for the reply and the share of the blog post. It was very easy to follow and got me half way there!
I’m not able to filter out those rows where everything is checked in that one column. Is there a way to apply this logic to showing just the unchecked item for the remaining rows when there are some check and unchecked in a given row?
Here’s what’s displaying now in the Outstanding Action Items table after applying the steps in your blog post at the Meeting Tracker table. Ideally, it would be just that last highlighted item that would display in that Outstanding Action Items view.
hi @Heather_Gomez1 ,
thanks for the compliment. We not often need this kind of logic and so I try to write for my future self that forgot already what happened previously
Via the function below you check if all items are checked in the column named Notes
