Preventing Duplications of Submission

User Support Form Building
,
1

Dear all, I will be glad if you can help me with this issue that seems to be problematic for me.
I have given specific numbers/codes to each questionnaire entry in order to control or avoid duplication. But I think the double submissions still occur.
Kindly check my survey and choices sheet codes to see what might be wrong.

type name label calculation required required_message relevant choice_filter constraint constraint_message
start start
end end
today today
deviceid deviceid
phonenumber phonenumber
select_one enumerator_list enumerator_name Enumerator Name yes
text enumerator_pin Enter your 4-digit PIN yes ${enumerator_name} != ‘’ string-length(${enumerator_pin}) = 4 Incorrect PIN for ${enumerator_name}! Contact the supervisor if you forgot yours.
calculate pin_correct if(${enumerator_name} = ‘ENUM01’, ${enumerator_pin} = ‘9012’, if(${enumerator_name} = ‘ENUM02’, ${enumerator_pin} = ‘5768’, if(${enumerator_name} = ‘ENUM03’, ${enumerator_pin} = ‘1324’, if(${enumerator_name} = ‘ENUM04’, ${enumerator_pin} = ‘3645’, if(${enumerator_name} = ‘ENUM05’, ${enumerator_pin} = ‘7980’, if(${enumerator_name} = ‘ENUM06’, ${enumerator_pin} = ‘8228’, if(${enumerator_name} = ‘Other’, true(), false)))))))
note pin_success ✓ PIN verified successfully! ${enumerator_name} != ‘’ and ${enumerator_pin} != ‘’ and ${pin_correct}
note pin_error :cross_mark: Incorrect PIN! ${enumerator_name} != ‘’ and ${enumerator_pin} != ‘’ and not(${pin_correct})
select_one pin_help pin_help Need help with PIN? yes You must address the PIN issue ${enumerator_name} != ‘’ and ${enumerator_pin} != ‘’ and not(${pin_correct})
text supervisor_override Enter supervisor override code yes Get from supervisor ${pin_help} = ‘yes’ ${supervisor_override} = ‘GHA2024’ Invalid override code!
text enumerator_other Please specify your name yes Please specify your name ${enumerator_name} = ‘other’
begin group section_a Section A: About You
select_one region region Region yes
select_one district district District yes region=${region}
select_one school_code school 1. School yes district=${district}
text instrument_number Questionnaire Number yes Enter the questionnaire number (e.g., 001, 002, 003) ${school} != ‘’ regex(., ‘^[0-9]{1,3}$’) Please enter 1-3 digits only
calculate padded_number substr(concat(‘000’, ${instrument_number}), string-length(concat(‘000’, ${instrument_number})) - 2, 3)
calculate survey_instrument_code concat(${school}, ${padded_number})
note display_code Survey Instrument Code: ${survey_instrument_code} ${school} != ‘’ and ${instrument_number} != ‘’
note dupicate_check :warning:IMPORTANT: You MUST check your paper records to ensure ${survey_instrument_code} has NOT been entered already for this school! ${school} != ‘’ and ${instrument_number} != ‘’
select_one code_verified code_verified Verification: I confirm that ${survey_instrument_code} is NOT in my records for ${school} and is a UNIQUE code yes You must verify that this code is unique before proceeding ${school} != ‘’ and ${instrument_number} != ‘’
calculate school_level if(${school}=‘SFDA’ or ${school}=‘DRCS’ or ${school}=‘MSBS’ or ${school}=‘AFBS’, ‘basic’, if(${school}=‘ALAV’ or ${school}=‘DPSH’ or ${school}=‘ASHS’ or ${school}=‘ADAS’, ‘shs’, ‘’))
select_one class_form class_form 2. Class (Form) yes ${school} != ‘’ school_level = ${school_level}
select_one age_group age 3. Age (years) yes
select_one gender gender 4. Gender yes
select_one transport get_toschool 5. How do you get to school? yes
text get_toschool_other Please specify your mode of transport yes Please specify your transport ${get_toschool} = ‘other’
end group
list_name name label region district school_level assigned_PIN
enumerator_list ENUM01 ENUM01- Kenneth Keteni 9012
enumerator_list ENUM02 ENUM02-Victoria Keleve-Dey 5768
enumerator_list ENUM03 ENUM03-Bert Dey 1324
enumerator_list ENUM04 ENUM04-Albert Ayidzoe 3645
enumerator_list ENUM05 ENUM05-Mensah Amuma 7980
enumerator_list ENUM06 ENUM06-Bright Dey(Researcher) 8228
enumerator_list Other Other (Supervisor override)
pin_help yes Yes, I need supervisor assistance
pin_help no No, I have entered my PIN correctly
region volta Volta Region
region accra Greater Accra Region
district hohoe Hohoe Municipal volta
district ketunorth Ketu North Municipal volta
district accrametro Accra Metro accra
district adaeast Ada East accra
school_code SFDA St. Francis Demo JHS ‘A’ volta hohoe basic
school_code ALAV Alavanyo Senior High/Tech. volta hohoe shs
school_code DRCS Dzodze R/C Demonstration JHS volta ketunorth basic
school_code DPSH Dzodze Penyi Senior High School volta ketunorth shs
school_code MSBS Mamprobi South 3 Basic School accra accrametro basic
school_code ASHS Accra Senior High School accra accrametro shs
school_code AFBS Ada Foah D/A Basic School accra adaeast basic
school_code ADAS Ada Senior High School accra adaeast shs
class_form jhs2 JHS 2 basic
class_form jhs3 JHS 3 basic
class_form shs2 SHS 2 shs
class_form shs3 SHS 3 shs
code_verified confirmed ✓ Yes, I confirm this code is unique and not previously used
age_group 10below 10 years or below
age_group 11_12 11-12 years
age_group 13_14 13-14 years
age_group 15_16 15-16 years
age_group 17above 17 years or above
gender male Male
gender female Female
2

@bridey28, this post discussed previously should help you solve your issue (by exploiting the dynamic data attachment feature):

3

Your example seems to show sensible information: security codes for staff. Better remove it here?

4

Thank you very much.

5

Thank you very much for your guidance.

6

Hint: In your example, You might have sensible information which seems sfnsible and might be misused e.g. … if(${enumerator_name} = ‘ENUM03’, ${enumerator_pin} = ‘1324’, …

Maybe, better delete it here,please.

1 Like
7

Hello @wroos, kindly help me with the deletion please. I have tried to delete the details but there is no option to do a delete.
I’ll be glad if you can help me delete it.
Thanks