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?
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
Thank you so much for your detailed explanation.
What I mean is that if a user enters the same household code (for example, “001”) more than once, the form currently allows both entries without showing any error.
I would like the form to display an error message or validation warning when a household code that has already been entered is entered again, in order to prevent duplicate household codes in the output data.
Thank you again for your support and guidance.
You can use Entities to prevent duplicates.
For example, this is a form snippet from the share choices across forms tutorial that prevents duplicate site codes. You can do something similar with households.
Well noted, and many thanks for your guidance. I’ll try using Entities in the same way to prevent duplicate household codes. I really appreciate your support!
