Hi all,
@yanokwa and @Snvssh4a2017 this is the sample that can be useful for the baseline data collection with pre-loaded information.
this is xlsform
Sample_Baseline_2017.xlsx (42.7 KB)
this is the csv form
hhcensus_data.csv (2.2 KB)
please look at the calculation field for the pull data and make sure that yours is the same way.
explanation of the first calculation field.
pulldata(‘hhcensus_data’, ‘total_victim’, ‘hhid’, ${hhid})
type= calculate
name = total_victim
calculation = pulldata(‘hhcensus_data’, ‘total_victim’, ‘hhid’, ${hhid})
4 .‘hhcensus_data’ is the name of the csv file. (hhcensus_data.csv)
‘total_victim’ is the column in the hhcensus_data file we want to look into.
‘hhid’ is the household we want to look into in the hhcensus_data. which should match with the hhid that is selected. the hhid can also be your key. this is a unique id that identify each household and make it unique so that there will not be a conflict of choose in the dataset.
please let me know if you need any other help.
thank you,
Fabla