FileMaker Forum

2answers

Compare Lists Boolean?

I have the result in a return separated list (it came from ExecuteSQL) something like this:

DOC000000095

LNK000000080

LNK000000081

I also have another list

DOC000000081

DOC000000088

DOC000000089

DOC000000090

DOC000000091

DOC000000093

DOC000000094

DOC000000095

DOC000000096

What is a way FileMaker can say if any of the values in List 1 exit List 2 evaluate as true? I was trying to use FilterValues ( ) Inside of PatternCount () but it went sour and I forgot the whole plan.

Chris Johnston

3answers

Progress Chart

I have a field in my database called progress. This field for now is a checkbox set that has the choices, “Un Started” “In Progress” and “Complete”. Eventually I want an elaborate way to start determining the progress of certain tasks. For now this is a start to understand the way I will construct it. Is there a way to construct a chart that would take (let’s say) 8 tasks and average there progress field and summarize it to show an average bar of where there over all progress is. So I mean on a scale of 0 – 100 with 0 being “Un Started” 50 being “in Progress” and 100 being “Complete”. I also would like to know if you would have to use a script to show the found set of 8 (8 is just a number of tasks or a particular job could be 5, or 11) or is there a way to only chart for related records.

Chris Johnston