Hello Tiana,
It's possible to auto-fill. it might be more difficult since you are still using Build, however if you switch to XLSForm, the auto-fill can be accomplished in following steps
- Make a CSV list with District, HF and Sub-count (only code)
e.g. -- 101 -- District one -- 10101 -- Health Facility one -- 1010101 (This is the sub-county code)
- Add the questions to your form, and set the Sub-country to read_only
- In the sub-county calculation, put this formula "pulldata('a', 'b', 'c', d)" where
a: is the fille name you gave to the CSV
b: is the column value to return from the CSV
c: is the corresponding look-up column from the CSV (in you case the code to the health facility)
d: is the look-up value from user inputs (in this case the current user selection on Health F question
the final formula will look like this "pulldata('CSV_File_Name', 'Sub_county_column_header_from_csv', 'HF_Column_header from csv', ${HF_Variable_name})"
Please note that it's recommended to use CSV file as attachment to your forms when dealing with long lists of options like administrative zones
Hoping this helps
Cheers, JR