Populate the repeat_count for external_choices

Question

We are creating a survey for facilities in our City Parks.     The number of facilities and the items to be inspected varies from park to park.   One park may have two facilities with six assets (rooms) to inspect while another park may have three facilities with 10 assets to inspect.    We would like to be able to populate the repeat_count for facilities based on how many are at a give park and we would like to do this for the repeats for assets and items to inspect.

list name                                             name                                  label                           park_name_list

facility_nameAQUATIC_CENTERAquatic CenterCACTUSfacility_nameRESTROOMSRestroomsCACTUSfacility_nameCOMMUNITY_CENTERCommunity CenterELDORADOfacility_nameAQUATIC_CENTERAquatic CenterELDORADOfacility_nameSOUTH_BUILDINGSouth BuildingELDORADOfacility_nameAQUATIC_CENTERAquatic CenterCHAPARRALfacility_namePARK_OFFICESPark OfficesCHAPARRALfacility_nameRESTROOMSRestroomsCHAPARRAL

How can I count the number of facilities by park in the above example and then count the number of assets by by facility name from  below

list name                                     name                                  label                           park_name_list   facility_name_list

asset_nameCOMMUNITY_ROOM_1Community Room #1ELDORADOCOMMUNITY_CENTERasset_nameKITCHENKitchenELDORADOCOMMUNITY_CENTERasset_nameMENS_ROOMMen's RoomELDORADOCOMMUNITY_CENTERasset_nameWOMENS_ROOMWomen's RoomELDORADOCOMMUNITY_CENTERasset_namePOTERY_ROOMPottery RoomELDORADOCOMMUNITY_CENTERasset_nameCLASSROOM_3Classroom #3ELDORADOCOMMUNITY_CENTERasset_nameOFFICESOfficesELDORADOCOMMUNITY_CENTERasset_nameHALLWAYS_LOBBYHallways/LobbyELDORADOCOMMUNITY_CENTERasset_nameENTRANCEEntranceELDORADOCOMMUNITY_CENTERasset_nameGYMGymELDORADOCOMMUNITY_CENTERasset_nameOFFICESOfficesELDORADOAQUATIC_CENTERasset_nameMENS_LOCKER_ROOMMen's Locker RoomELDORADOAQUATIC_CENTERasset_nameWOMENS_LOCKER_ROOMWomen's Locker RoomELDORADOAQUATIC_CENTERasset_nameMENS_ROOMMen's RoomELDORADOSOUTH_BUILDINGasset_nameWOMENS_ROOMWomen's RoomELDORADOSOUTH_BUILDING

We are able to limit the choices by using a  choice_filter like this for facilities

park_name_list=${park_name} and facility_name_list=${facility_name}

and this for assets

park_name_list=${park_name} and facility_name_list=${facility_name} and asset_name_list=${asset_name}

select_one park_namepark_nameParkselect_one_external facility_namefacility_nameFacility   begin repeatFacility_LocationsLocationsselect_one_external asset_nameasset_nameAssets   begin repeatInspectionsInspections   select_one_external inspection_iteminspection_itemItemselect_one inspection_ratinginspection_ratingInspection RatingtextnotesNotesselect_one yes_nowork_order_submittedWO Submittedselect_one yes_nowork_order_completedWO CompletedimageInspections_imageImageend repeat  end repeat     integerasset_countAssets

Thanks Mele

IsmaelChivite · Accepted Answer

Hi. I cannot think of an obvious way to count list elements using an XLSForm expression. Could you create a CSV file listing the facility count? If so, you could use the pulldata function later to get the value and apply it to the repeat_count. Same for the assets.