jjgarner

Calculating a Category Variable for Groups of Records

Discussion created by jjgarner on May 27, 2016
Latest reply on May 27, 2016 by erolst

Hello everybody,

 

I am trying to improve a database so that FileMaker identifies "Family Type" for each person in each family in our database.

 

The database looks like this:

person_IDfamily_IDgenetic_ID
11None
21Genetic Disorder A
31None
42None
52Genetic Disorder B
63None
73None
83Genetic Disorder C
93None
104None

 

In English, I want my FileMaker calculation to basically do:

"For each group of records with the same family_ID value, output the Genetic Disorder type (A,B, C, etc) if there is one; otherwise, output "Typical Family"

 

I was thinking of doing a "for loop" strategy but I wanted to see if anyone in the community had a better idea or any tips - I am not sure how to code this!

 

Thanks in advance!

Outcomes