I have a survey to collect demographic data of collared ungulates. Each observation of a collared ungulate is stored as a separate row in the database. I am running into problems when there are multiple collared ungulates in a group because then the demographic data is repeated in the database. I am trying to come up with a way to easily filter out repeated demographic data when needed. I have a question asking if there are multiple collars in the group (name = multiple_collars) . If the answer is "yes", a relevant question appears asking if this is the first collar surveyed in the group (name = collar_no). If the collar is the first surveyed in the group, it is stored as a value of 1. If the collar is the second surveyed in the group, it is stored as a value of 2. What I would like to do is prepopulate collar_no with a value of 1 if there are not multiple collars in the group (multiple_collars = "no"). If there are multiple collars (multiple_collars = "yes"), then the user would define the collar_no value as 1 or 2 using the relevant question. I would filter the data by values of 1 for collar_no to prevent repeated demographic data. Does anyone know if this is possible?
I have attached the xlsx form of my survey
