Thank you so much for your continued support.
Attached is the XLSForm containing only the information for the affected entries. What I would like is for the drugs to be uploaded in alignment with the selections made for each program.
Thank you once again.
Best regards,
Ansumana
NMSA_DISTRIBUTIONS2.xlsx (27.1 KB)
@samuelansu, could you be more specific with your requirements so that the community should be able to help you out? Did you mean you would like to filter all the choices that were not selected in the select_multiple question and display them on the subsequent select_one question? Feel free to correct me if I understood you differently.
Thank you, Kal_Lam, for following up on this issue.
We currently have five programs: FreeHCI, Malaria, HIV/AIDS, TB, and CHW. The system holds the following number of medications for each program, respectively:
If FreeHCI and Malaria are selected in the multiple select question, I would like the subsequent select_one (which is within a repeat group) to only display the 11 medications relevant to those two programs — i.e., 5 from FreeHCI and 6 from Malaria.
This is intended to minimize errors and ensure that medications from HIV/AIDS, TB, and CHW are not mistakenly selected when they are not part of the chosen programs.
Thank you again for your support.
