Can any one Please guide that how we can mark validation in form that if the required data in not exist in uploaded file then the warning should appear to provide proper data
like we have household id to enter and basis that household id data is pulled from external file , but in case wrong id is mentioned then the data shows blank.
i want to restrict that is household is entered then it should check whether the same exist in file uploaded if not error should be displayed with message for entering correct household id.
I think I need to be more clear in my requirements
Actually I want that the houshold I’d when entered , should be check in external CSV uploaded in media section
And if the I’d is not matched in that file then it should prompt for entering correct house hold I’d
The solution which referred by you perhaps deals with numeric entered only , it does not check the data in upload file which should be pulled on the basis of above household I’d entered
If the pulldata function does not match anything with the identifier (in your data entry form) and that what is present in the csv file, it generates nothing. Hence, wouldn’t it be OK to set a constraint on the identifier itself?
Yes, you will have to edit/manipulate the numbers in the constraints that matches and is available in your csv file. Say, you may have like 1 to 1000 cases in your csv so you will need to edit the same accordingly in your xlsform.
That may not be possible to deal with edit or manipulate the same ,otherwise if you can please guide
As you mentioned that
If the pull-data function does not match anything with the identifier (in your data entry form) and that what is present in the csv file, it generates nothing
can we put a condition in pull data in xls like if field generates blank then it should ask to fill correct id ( as blank will only generate in case the household id doesn’t match )
Hi @caneeraj
Ideally that should be a constraint where the filed being filled by the pull data cannot be a blank i.e. !=’’ and the error message is to go back and fill the correct ID.