Marion Public Health
181 S. Main St. Marion, OH 43302 | Visit Official Website

Complaint Manager

Please fill out the form below and click "Submit" at the bottom of the screen.

Thank you for submitting this information. We will follow-up on this as soon as possible.

Oops! Something went wrong while submitting the form.

{"allowAdd":"YES","allowTimeActivity":"NO","singular":"Complaint","src":"Complaints","doRequireParent":"","pkey":"complaintsID","defaultParentFormID":"","addToPrintableName":"","pullParentPanelData":"","allowClone":"","allowCopy":"NO","icon":"chatting7.png","schedulerEvents":"none","plural":"Complaints","dsn":"local","updateAssignmentsOnChange":"","doAutoSave":"YES","isDashboard":"NO","allowAssignment":"YES","allowSaveAndAdd":"","showHistory":"YES","doShowHistoryViews":"","majorLabelDescription":"","allowAttach":"YES","doChangeLog":"YES","assignmentLogic":{"logic":[],"notificationType":"email","notificationText":"","notificationMessage":"<p>{RECORD.AssignedTofirstName} {RECORD.AssignedTolastName},</p><p>A {RECORD.complaintType} complaint has been added for you. Complaint Number {RECORD.complaintNumber} requires your attention.</p>","notificationTextMessage":""},"version":"1.0","title":"Complaint Manager","allowExport":"YES","allowEdit":"","disableRecordPreview":"","showConversationPanel":"","allowQuickEdit":"","allowDelete":"","myhdLogic":{"settings":{"expose":"YES","allowFileUploads":"YES","requireMinimumFileUploads":"","maxSummaryColumns":8,"type":"Public","includeFields":["complaintType","Subject","OwnerName","OwnerAddress","OwnerTenantPhone","complaintDetails","FullAddressofComplaint","complainantAnon","complainantFirstName","complainantLastName","complainantPhone","Email","FullComplainantAddress","ComplaintCityStateZip","ComplaintAddress"],"fieldSettings":{"FullAddressofComplaint":{"label":"","defaultValue":"","isFormValidator":"NO","searchResultsLayout":{"columns":[]},"formValidation":{"fields":[]},"overridesEnabled":"YES","overrideConfigs":{"properties":{"id":"AddressofComplaint","label":"Address of Complaint","group":"Complaint Details~expanded","required":"YES"},"type":"text","subfields":[],"required":"YES","logic":[]}}},"flags":[{"field":"dateReceived","value":"{now}"},{"field":"howReceived","value":"Online"},{"field":"status","value":"Received"}],"contactList":[{"userID":"8AE9B0D0-F9CC-4331-8CE6-B33AD35CC411","method":"Email","type":"user"},{"userID":"33FA7209-E6FF-46B7-9422-5C0525B5613F","method":"Email","type":"user"}],"fees":[]},"singular":"Complaint","plural":"Complaints","title":"Complaint Manager","instructions":"Please fill out the form below and click \"Submit\" at the bottom of the screen.","submittedMessage":"Thank you for submitting this information. We will follow-up on this as soon as possible.","emailNotificationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com","textNoficationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com","notificationConditions":[],"subForms":[],"questionnaireSettings":{"parentFormID":"","parentPkey":"","parentSrc":"","triggerFields":[],"frequency":1,"frequencyUnit":"daily","timeRange":{"start":"7:00 AM","end":"7:00 PM"},"emailContent":"Hi {userRecord.firstName}, a new {questionnaire.singular} is ready for you to submit. {url}","textContent":"Hi {userRecord.firstName}, a new {questionnaire.singular} is ready for you to submit. {url}","emailSubject":"You have a new {questionnaire.singular}"},"path":"complaint-manager"},"configureAssignmentLogic":{"logic":[]},"listCaption":"","messageLogic":{"settings":{"expose":"NO","allowFileUploads":"NO","type":"Public","includeFields":[],"flags":[]},"singular":"Complaint","plural":"Complaints","title":"Complaint Manager","instructions":"Please fill out the form below and click \"Submit\" at the bottom of the screen.","submittedMessage":"Thank you for submitting this information. We will follow-up on this as soon as possible.","emailNotificationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com","textNoficationMessage":"Hi {contact.firstName}, a new {form.singular} has been submitted from My Health Department.com","messages":[{"contacts":[{"userID":"0095F32D-3434-4163-9FEE-5BAA35E7B33D","method":"Email","type":"user"},{"userID":"9DB8FEA4-A063-4134-81C1-72DFDE691A95","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Food","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Food Complaint","emailSubject":"A Food Complaint has been received via the MyHD Portal","emailContent":"<p>A new Food Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"EA0519FC-803E-49DA-87F8-4E22C8FB8A21","method":"Email","type":"user"},{"userID":"9DB8FEA4-A063-4134-81C1-72DFDE691A95","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Body Art/Piercing","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Body Art/Piercing","emailSubject":"A Body Art/Piercing Complaint has been received via the MyHD Portal","emailContent":"<p>A new Body Art/Piercing Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"01B502D3-33B6-4CC0-8574-C2178712B1E6","method":"Email","type":"user"},{"userID":"9DB8FEA4-A063-4134-81C1-72DFDE691A95","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Composting","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Composting","emailContent":"<p>A new Composting Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>","emailSubject":"A Composting Complaint has been received via the MyHD Portal"},{"contacts":[{"userID":"9DB8FEA4-A063-4134-81C1-72DFDE691A95","method":"Email","type":"user"},{"userID":"01B502D3-33B6-4CC0-8574-C2178712B1E6","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Jail/Institution ","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Jail/Institution ","emailSubject":"A Jail Complaint has been received via the MyHD Portal","emailContent":"<p>A new Jail/Institution Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"01B502D3-33B6-4CC0-8574-C2178712B1E6","method":"Email","type":"user"},{"userID":"47B200FC-F9C3-4CEC-A708-7DF4EB3AC683","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Nuisance Housing","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Nuisance Housing","emailSubject":"A Nuisance Housing Complaint has been received via the MyHD Portal","emailContent":"<p>A new Housing Nuisance Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"01B502D3-33B6-4CC0-8574-C2178712B1E6","method":"Email","type":"user"},{"userID":"47B200FC-F9C3-4CEC-A708-7DF4EB3AC683","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Nuisance Solid Waste","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Nuisance Solid Waste","emailSubject":"A Solid Waste Nuisance Complaint has been received via the MyHD Portal","emailContent":"<p>A new Nuisance Solid Waste Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"01B502D3-33B6-4CC0-8574-C2178712B1E6","method":"Email","type":"user"},{"userID":"9DB8FEA4-A063-4134-81C1-72DFDE691A95","method":"Email","type":"user"},{"userID":"D10F00F0-D2D0-4A3E-B0FC-4FB854CA3C43","method":"Email","type":"user"},{"userID":"0095F32D-3434-4163-9FEE-5BAA35E7B33D","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Recreational Waterborne Illness","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Recreational Waterborne Illness","emailSubject":"A Recreational Waterborne Illness Complaint has been received via the MyHD Portal","emailContent":"<p>A new Recreational Waterborne Illness Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"9DB8FEA4-A063-4134-81C1-72DFDE691A95","method":"Email","type":"user"},{"userID":"EA0519FC-803E-49DA-87F8-4E22C8FB8A21","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"RV Park/Camp","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"RV Park/Camp","emailSubject":"A RV Park/Camp Complaint has been received via the MyHD Portal","emailContent":"<p>A new RV Park/Camp Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"01B502D3-33B6-4CC0-8574-C2178712B1E6","method":"Email","type":"user"},{"userID":"9DB8FEA4-A063-4134-81C1-72DFDE691A95","method":"Email","type":"user"},{"userID":"EA0519FC-803E-49DA-87F8-4E22C8FB8A21","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Schools","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Schools","emailSubject":"A School Complaint has been received via the MyHD Portal","emailContent":"<p>A new School Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"D10F00F0-D2D0-4A3E-B0FC-4FB854CA3C43","method":"Email","type":"user"},{"userID":"EA0519FC-803E-49DA-87F8-4E22C8FB8A21","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Sewage - HSTS","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Sewage - HSTS","emailSubject":"A Sewage Complaint has been received via the MyHD Portal","emailContent":"<p>A new Sewage Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>"},{"contacts":[{"userID":"D10F00F0-D2D0-4A3E-B0FC-4FB854CA3C43","method":"Email","type":"user"},{"userID":"EA0519FC-803E-49DA-87F8-4E22C8FB8A21","method":"Email","type":"user"}],"conditions":[{"field":"complaintType","operator":"EQUAL","value":"Water Supply/Private Wells","from":"Complaint Manager"}],"parentFormID":"thisForm","hideDefaultEmailRecordLink":"NO","title":"Water Supply/Private Wells","emailContent":"<p>A new Private Water Systems Complaint has been submitted from My Health Department.com. Please review and assign the complaint accordingly.</p><p>Complaint Number {RECORD.complaintNumber} requires your attention.</p>","emailSubject":"A Private Water Systems Complaint has been received via the MyHD Portal"}],"subForms":[]},"formID":"3CA28874-348A-4DFE-A7F8-92DDBAB914B0","listPageConfig":{"lkp":[{"alias":"ReceivedBy","key":"users","from":"userID","to":"This_Form","on":"userID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"Address","key":"Address","from":"addressID","to":"This_Form","on":"addressID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"Permit","key":"Permit","from":"permitID","to":"This_Form","on":"permitID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"Establishment","key":"Establishment","from":"establishmentID","to":"Permit","on":"parentFormID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"PermittedAddress","key":"Address","from":"addressID","to":"Establishment","on":"parentFormID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"ComplainantAddress","key":"Address","from":"addressID","to":"This_Form","on":"complainantAddressID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"AssignedTo","key":"users","from":"userID","to":"This_Form","on":"recordAssignedToUserID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"Owner","key":"Contacts","from":"contactsID","to":"Permit","on":"rdplookupID","filter":"{contactType} LIKE '%Owner%'","row":0,"lkpto":"permitID","type":"left","dsn":"","multiFrom":false,"multiTo":false},{"alias":"OwnerAddress","key":"Address","from":"addressID","to":"Owner","on":"addressID","filter":"","row":0,"lkpto":"","type":"left","dsn":"","multiFrom":false,"multiTo":false}],"columns":[{"mask":"","out":"{complaintNumber}","alias":"This_Form","src":"Complaints","format":"","label":"Complaint Number","hideFromOutput":"NO","outOverride":""},{"src":"Complaints","format":"","alias":"This_Form","label":"Status","mask":"","out":"{status}","hideFromOutput":"NO","filterable":true,"nonsearchable":true},{"src":"Complaints","format":"date","alias":"This_Form","label":"Date Received","hideFromOutput":"NO","mask":"mm/dd/yyyy","out":"{dateReceived}","filterable":true},{"src":"Complaints","format":"","alias":"This_Form","label":"Complaint Type","mask":"","out":"{complaintType}","hideFromOutput":"NO","filterable":true,"nonsearchable":true},{"src":"Complaints","format":"","alias":"This_Form","label":"How Received","mask":"","out":"{howReceived}","hideFromOutput":"NO","filterable":true,"nonsearchable":true},{"src":"Complaints","format":"","alias":"This_Form","label":"Investigation Within","mask":"","out":"{investigateWithin}","hideFromOutput":"NO","filterable":true,"nonsearchable":true,"outOverride":"{investigateWithin} Day(s)"},{"mask":"","out":"{firstName} {lastName}","alias":"ReceivedBy","src":"users","format":"","label":"Received By","hideFromOutput":"NO","nonsearchable":true,"filterable":true},{"mask":"","out":"{Subject}","alias":"This_Form","src":"Complaints","format":"","label":"Complaint Against","hideFromOutput":"NO"},{"mask":"","out":"{AssignedTofirstName} {AssignedTolastName}","alias":"AssignedTo","src":"users","format":"","label":"Assigned To","hideFromOutput":"NO","nonsearchable":true,"filterable":true,"alwaysIncludeAlias":"YES"},{"mask":"","out":"{addressLine1} {addressLine2} {city} {state} {zip}","alias":"Address","src":"Address","format":"","label":"Address","hideFromOutput":"NO"},{"mask":"","out":"{PermittedAddressaddressLine1} {PermittedAddressaddressLine2} {PermittedAddresscity} {PermittedAddressstate} {PermittedAddresszip}","alias":"PermittedAddress","src":"Address","format":"","label":"Permitted Address","hideFromOutput":"NO","alwaysIncludeAlias":"YES"},{"mask":"","out":"{ComplainantAddressaddressLine1} {ComplainantAddressaddressLine2} {ComplainantAddresscity} {ComplainantAddressstate} {ComplainantAddresszip}","alias":"ComplainantAddress","src":"Address","format":"","label":"Complainant Address","hideFromOutput":"NO","alwaysIncludeAlias":"YES"},{"mask":"","out":"{PoliticalSubdivision}","alias":"Address","src":"Address","format":"","label":"Political Subdivision","hideFromOutput":"NO","outOverride":"{if:PoliticalSubdivision}{PoliticalSubdivision}{else}{PermittedAddressPoliticalSubdivision}{/if}"},{"mask":"","out":"{PermittedAddressPoliticalSubdivision}","alias":"PermittedAddress","src":"Address","format":"","label":"Political Subdivision Permitted","hideFromOutput":"NO","alwaysIncludeAlias":"YES"},{"mask":"","out":"{Ownerorganization} {OwnerfirstName} {OwnerlastName}","alias":"Owner","src":"Contacts","format":"","label":"Owner","hideFromOutput":"NO","alwaysIncludeAlias":"YES"},{"mask":"","out":"{OwnerAddressaddressLine1} {OwnerAddressaddressLine2} {OwnerAddresscity} {OwnerAddressstate} {OwnerAddresszip}","alias":"OwnerAddress","src":"Address","format":"","label":"Owner Address","hideFromOutput":"NO","alwaysIncludeAlias":"YES","nonsearchable":false},{"mask":"","out":"{OwnerName}","alias":"This_Form","src":"Complaints","format":"","label":"Complaint Owner","hideFromOutput":"NO"},{"mask":"","out":"{OwnerAddress} {OwnerCityStateZip}","alias":"This_Form","src":"Complaints","format":"","label":"Complaint Owner Address","hideFromOutput":"NO"},{"mask":"","out":"{OwnerTenantPhone}","alias":"This_Form","src":"Complaints","format":"phone","label":"Complaint Owner Phone","hideFromOutput":"NO"},{"hideFromOutput":"YES","alias":"This_Form","mask":"","out":"{dateAdd}","label":"Date Added","src":"dateAdd","format":"date"},{"hideFromOutput":"YES","alias":"This_Form","mask":"","out":"{dateLastModified}","label":"Date Last Modified","src":"dateLastModified","format":"date"},{"hideFromOutput":"YES","alias":"This_Form","mask":"","out":"{modifiedBy}","label":"Last Modified By","src":"modifiedBy","format":""}],"listInfoBox":{"infoBoxType":"","infoBox":"alert","infoText":""},"COLUMNLIST":"Complaints.complaintNumber,Complaints.status,Complaints.dateReceived,Complaints.complaintType,Complaints.howReceived,Complaints.investigateWithin,users.firstName,users.lastName,Complaints.Subject,users.AssignedTofirstName,users.AssignedTolastName,Address.addressLine1,Address.addressLine2,Address.city,Address.state,Address.zip,Address.PermittedAddressaddressLine1,Address.PermittedAddressaddressLine2,Address.PermittedAddresscity,Address.PermittedAddressstate,Address.PermittedAddresszip,Address.ComplainantAddressaddressLine1,Address.ComplainantAddressaddressLine2,Address.ComplainantAddresscity,Address.ComplainantAddressstate,Address.ComplainantAddresszip,Address.PoliticalSubdivision,Address.PermittedAddressPoliticalSubdivision,Contacts.Ownerorganization,Contacts.OwnerfirstName,Contacts.OwnerlastName,Address.OwnerAddressaddressLine1,Address.OwnerAddressaddressLine2,Address.OwnerAddresscity,Address.OwnerAddressstate,Address.OwnerAddresszip,Complaints.OwnerName,Complaints.OwnerAddress,Complaints.OwnerCityStateZip,Complaints.OwnerTenantPhone","LABELMAP":{"AssignedTo":9,"OwnerAddress":16,"ComplaintAgainst":8,"PoliticalSubdivision":13,"ComplainantAddress":12,"HowReceived":5,"Status":2,"ComplaintNumber":1,"PermittedAddress":11,"ComplaintOwner":17,"PoliticalSubdivisionPermitted":14,"ReceivedBy":7,"Owner":15,"ComplaintOwnerPhone":19,"ComplaintOwnerAddress":18,"DateReceived":3,"InvestigationWithin":6,"Address":10,"ComplaintType":4},"SEARCHPOINTS":["Complaints.complaintNumber","Complaints.dateReceived","Complaints.Subject","Address.addressLine1,Address.addressLine2,Address.city,Address.state,Address.zip","Address.PermittedAddressaddressLine1,Address.PermittedAddressaddressLine2,Address.PermittedAddresscity,Address.PermittedAddressstate,Address.PermittedAddresszip","Address.ComplainantAddressaddressLine1,Address.ComplainantAddressaddressLine2,Address.ComplainantAddresscity,Address.ComplainantAddressstate,Address.ComplainantAddresszip","Address.PoliticalSubdivision","Address.PermittedAddressPoliticalSubdivision","Contacts.Ownerorganization,Contacts.OwnerfirstName,Contacts.OwnerlastName","Address.OwnerAddressaddressLine1,Address.OwnerAddressaddressLine2,Address.OwnerAddresscity,Address.OwnerAddressstate,Address.OwnerAddresszip","Complaints.OwnerName","Complaints.OwnerAddress,Complaints.OwnerCityStateZip","Complaints.OwnerTenantPhone"],"COLUMNPOINTS":["Complaints.complaintNumber","Complaints.status","Complaints.dateReceived","Complaints.complaintType","Complaints.howReceived","Complaints.investigateWithin","users.firstName,users.lastName","Complaints.Subject","users.AssignedTofirstName,users.AssignedTolastName","Address.addressLine1,Address.addressLine2,Address.city,Address.state,Address.zip","Address.PermittedAddressaddressLine1,Address.PermittedAddressaddressLine2,Address.PermittedAddresscity,Address.PermittedAddressstate,Address.PermittedAddresszip","Address.ComplainantAddressaddressLine1,Address.ComplainantAddressaddressLine2,Address.ComplainantAddresscity,Address.ComplainantAddressstate,Address.ComplainantAddresszip","Address.PoliticalSubdivision","Address.PermittedAddressPoliticalSubdivision","Contacts.Ownerorganization,Contacts.OwnerfirstName,Contacts.OwnerlastName","Address.OwnerAddressaddressLine1,Address.OwnerAddressaddressLine2,Address.OwnerAddresscity,Address.OwnerAddressstate,Address.OwnerAddresszip","Complaints.OwnerName","Complaints.OwnerAddress,Complaints.OwnerCityStateZip","Complaints.OwnerTenantPhone"],"FORMATTEDCOLUMNS":[]},"dataEntryConfig":{"panels":[{"form":"Law_Director_Form","layout":{"columns":[{"src":"Law_Director_Form","hideFromOutput":"NO","format":"","label":"Department","mask":"","out":"{department}","outOverride":""},{"src":"Law_Director_Form","hideFromOutput":"NO","format":"","label":"Charge Requested","mask":"","out":"{chargeRequested}","outOverride":""}]},"allowRDPAdd":true,"useForeignKey":true},{"form":"Inspection","layout":{"columns":[{"src":"Inspection","hideFromOutput":"NO","format":"date","label":"Inspection Date","mask":"","out":"{inspectionDate}","outOverride":""},{"src":"users","hideFromOutput":"NO","format":"","label":"Inspector","mask":"","out":"{firstName} {lastName}","outOverride":""},{"src":"Inspection","hideFromOutput":"NO","format":"","label":"Inspection Type","mask":"","out":"{purpose}","outOverride":""}]},"useForeignKey":true}],"form":[{"properties":{"group":"Complaint Details","label":"Complaint Type","id":"complaintType","maxlength":500},"required":true,"options":[{"text":"Body Art/Piercing","value":"Body Art/Piercing"},{"text":"Composting","value":"Composting"},{"text":"Food","value":"Food"},{"text":"Jail/Institution","value":"Jail/Institution"},{"text":"Nuisance Housing","value":"Nuisance Housing"},{"text":"Nuisance Solid Waste","value":"Nuisance Solid Waste"},{"text":"Recreational Waterborne Illness","value":"Recreational Waterborne Illness"},{"text":"RV Park/Camp","value":"RV Park/Camp"},{"text":"Schools","value":"Schools"},{"text":"Sewage - HSTS","value":"Sewage - HSTS"},{"text":"Water Supply/Private Wells","value":"Water Supply/Private Wells"}],"type":"select","default":"","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"group":"Complaint Details~expanded","label":"Complaint Details","id":"complaintDetails"},"required":true,"type":"textarea","default":"","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":"MAX","dbNullable":true},{"properties":{"id":"ComplaintAddress","label":"Complaint Address","group":"Complaint Details~expanded","required":true},"type":"text","subfields":[],"required":true},{"properties":{"id":"ComplaintCityStateZip","label":"Complaint City/State/Zip","group":"Complaint Details~expanded","required":true},"type":"text","subfields":[],"required":true},{"properties":{"id":"Subject","label":"Complaint Against","group":"Complaint Details~expanded"},"type":"text","subfields":[]},{"properties":{"id":"OwnerName","label":"Owner Name","group":"Complaint Details~expanded"},"type":"text","subfields":[]},{"properties":{"id":"OwnerAddress","label":"Owner Address","group":"Complaint Details~expanded"},"type":"text","subfields":[]},{"properties":{"id":"OwnerTenantPhone","label":"Owner/Tenant Phone","group":"Complaint Details~expanded"},"type":"phone","subfields":[]},{"properties":{"group":"Complainant","label":"Is Anonymous?","id":"complainantAnon","maxlength":500},"required":true,"options":[{"text":"Select an Option","value":""},{"text":"YES","value":"YES"},{"text":"NO","value":"NO"}],"type":"select","logic":[],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"group":"Complainant","label":"First Name","id":"complainantFirstName","maxlength":500},"type":"text","logic":[{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"NO","type":"show"},{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"YES","type":"hide"},{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"NO","type":"require"}],"default":"","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"group":"Complainant","label":"Last Name","id":"complainantLastName","maxlength":500},"type":"text","logic":[{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"NO","type":"show"},{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"YES","type":"hide"},{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"NO","type":"require"}],"default":"","dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true},{"properties":{"group":"Complainant","label":"Complainant Phone","id":"complainantPhone","maxlength":500},"type":"phone","logic":[{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"NO","type":"show"},{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"YES","type":"hide"},{"col":"","filterType":"field","src":"","field":"complainantAnon","valueAction":"===","value":"NO","type":"require"}],"dbType":"VARCHAR","dbUnicode":false,"dbMaxLength":500,"dbNullable":true}]},"hsScripts":[{"runWhen":"onload","runWhere":"cloudEntry","code":"/**\r\n * DCS-1207\r\n * Client System: Marion County OH\r\n * Utility: Establishment Manager\r\n * Description: process politicalSubdivision lookup when creating a new address entry with quick-add form.\r\n */\r\n\r\nlet currentLat;\r\nlet currentLng;\r\nlet addressForm;\r\n\r\n\r\nconst politicalSubdivisionLookUp = async () => {\r\n    if (currentLat && currentLng) {\r\n        const location = `POINT(${currentLng} ${currentLat})`;\r\n        const subdivisionData = await hs.api.getHSQueryResult({\r\n        formID: \"66D1B03E-AF72-4D51-8AA1-512B61923722\",\r\n        alias: 'politicalSubdivision-lookup-query',\r\n        params: JSON.stringify({ location: location })\r\n        }).catch(console.warn);\r\n\r\n        if (subdivisionData && subdivisionData.DATA?.length) {\r\n            addressForm.__vue__[\"PoliticalSubdivision\"] = subdivisionData.DATA[0].SubdivisionName;\r\n        }\r\n    }\r\n }\r\n\r\n\r\nconst renderAddressFormElements = () => {\r\n    addressForm = document.getElementById(\"quickAddForm\");\r\n    const watchList = [\"lat\", \"lng\"];\r\n    watchList.forEach((element) => {\r\n        addressForm.__vue__.$watch(element, (newValue, oldValue) => {\r\n        element === \"lat\" ? (currentLat = newValue) : (currentLng = newValue);\r\n        politicalSubdivisionLookUp();\r\n        });\r\n    });\r\n};\r\n\r\n\r\napp.events.on(`ui.controls.quickAdd.open`, (data) => {\r\n    if (data.form === \"Address\") {\r\n        renderAddressFormElements();\r\n    }\r\n});"}]}