Counting Data for a checklist

Need help
1

Hey bublers, not posted in a long time.

I’m working on a new project, and in this project I’m trying to work out how to count each item from a persons checklist and then display that in a repeating group. Essentially I want it to track how far someone is with there checklist and display a counter i.e. 2/12 or 11/12.

The way my data is structured at the moment is I have a data type for each person, and a datatype for a checklist so each person has their own checklist and the thing that links them all together is the name.

How would I go about counting each data item in the checklist as a single item that totals up, the data in the checklist is based on yes if they have it or no if they don’t.

image

Here’s a screenshot of how it looks at the moment, the 10/15 is a placeholder text.

image

Here is the data type. I haven’t fully fleshed it out because I wanted it in working state first.

Thanks all!

2

Simpler would be to save a checklist in a single table below.

(1) The 12 items in the checklist, that I presume don’t change should be set up as an Option Set.

(2) For each item completed by the user, make an entry into a table with two columns: User name | Checklist item

Should simplify counting the items completed as well.

3

This topic was automatically closed after 70 days. New replies are no longer allowed.