I am experiencing an issue with the Household Code field. When I enter "001", it is being saved twice (e.g., duplicated in the dataset). Please see my code below. Could you please advise why this is happening and how can I fix it?
HH Screening_duplicate.xlsx (602.5 KB)
I was not able to replicate your issue. I submitted two entries and the data was not duplicated. The household code matched what I entered. Your form requires the user to input the correct household code. If the user inputs “001” twice, then it will be in the output data twice.
(above) the two surveys and (below) the output data
1 Like