each(
    dataPath("data[*]"),
    combine(
      upsert("Event__c","ODK_Unique_ID__c", fields(
        field("ODK_Unique_ID__c", dataValue("instanceID")),
        field("Device_ID__c", dataValue("deviceid")),
        field("Date_of_Submission__c", dataValue("today")),
        field("Form_Start_Time__c", dataValue("start")),
        field("Staff_Member_Reporting__c", dataValue("names")),
        field("Other_Staff_Member_Reporting__c", dataValue("name_other")),
        field("Date_of_event__c", dataValue("date")),
        field("Province__c", function(state){
         if (state.data.province !== null) {
           return dataValue("province")(state)
         } if (state.data.province_other !== null) {
           return dataValue("province_other")(state)
         }
         else {
           null
         }
       }),
        // field("District__c", dataValue("district")),
        field("District__c", function(state){
               if (state.data.district !== (undefined || null)) {
              return dataValue("district")(state).replace("_"," ")
              } else {
               null
                }
              }),
        field("Location_of_event__c", dataValue("area")),
        field("Location__c",function(state) {
                return Array.apply(
                 null, dataValue("location")(state)
                ).join(';').replace(/_/g," ")
            }),
        field("Other_location__c", dataValue("location_other")),
        field("Name_of_Site__c", dataValue("site")),
        field("Name_of_partner_organisation__c", dataValue("partner")),
        field("Event_Planned_By__c", dataValue("planner")),
        field("Event_Planned_By_Other__c", dataValue("planner_other")),
        field("Event_Organized_By__c", dataValue("team")),
        field("Event_Type__c", function(state){
               if (state.data.event_type !== (undefined || null)) {
              return dataValue("event_type")(state).toString().replace("_"," ")
              } else {
               null
                }
              }),
        field("Activation_type__c", dataValue("activation")),
        field("Name", dataValue("name")),
        field("Name", function(state) {
          if (state.data.name !== (undefined || null)) {
            return dataValue("name")(state).slice(0,18)
          } else { null }
        }),
        field("Other_Event_Type__c", dataValue("type_other")),
        field("Actual_number_if_known__c", dataValue("actual")),
        field("Approximate_number_if_actual_not_known__c", dataValue("approximate")),
        field("Other_Participants__c", dataValue("participants_other")),
        field("Did_media_attend_the_event__c", dataValue("media")),
        field("Media_Source__c", dataValue("media_source")),
        field("Event_Assistance__c", dataValue("help")),
        field("Event_Assistants__c", dataValue("help_no")),
        field("Form_End_Time__c", dataValue("end"))
      )),
    beta.each(
        merge(dataPath("helpers1[*]"), fields(
          field("parentId", dataValue("instanceID"))
        )),
      create("Lead",fields(
      field("FirstName", dataValue("fname")),
      field("LastName", dataValue("sname")),
      field("Phone", dataValue("cnumber")),
      field("Company","Event Volunteer"),
      field("Lead_Type__c", function(state){
             if (state.data.fleader === ("Yes")) {
            return "Funda Leader"
          } else {
          return "Not Funda Leader"}
            })
      ))
)
)
)