Latest Contributions by KenBuja

You can use the Schema function to return the list of fields in the related table var relatedInspections = FeatureSetByRelationshipName($feature, relationshipName); var theSchema = Schema(relatedInspections); var theFields = theSchema['fields']; var theFieldList = []; for (var index in theFields) Push(theFieldList, theFields[index].name) ... View more

Here's one way to do it: var name;// = 'Jane Doe'; var phone;// = '999-999-9999' var email;// = '[email protected]'; if (IsEmpty(name)) name = 'Anonymous'; if (IsEmpty(phone)){ iif(IsEmpty(email), `${name}, no contact information provided`, `${name}: ${email}`) } else { iif(IsEmpty(email), `${name}: ${phone}`, `${name}: ${phone}, ${email}`) }         ... View more

It's much easier to work with your code when you use the "Insert/edit code sample" button. Click the three dots at the end of the icon bar, then select the </> icon. I'm guessing you're showing three different versions of the same script you'd like to run, but if I'm incorrect, please let me know. What are the some of the dates you'd expect to see in your data? You can test your script in the Playground like this to see how it works with a variety of dates. var clean_up_date = null; var contact_date = Date(2023,10,6); var reporting_date = Date(2023,10,4) var citation_date = Date(2023,10,5); When (!IsEmpty(clean_up_date), "Removed", !IsEmpty(reporting_date) && DateDiff(contact_date, Date (reporting_date), 'days') >=3, "Over Due- Warning three days over Reporting", !IsEmpty(reporting_date) && DateDiff(contact_date, Date (reporting_date), 'days') <=2, "Contact Made 1", DateDiff(citation_date, Date(contact_date), 'days') >=3, "Over Due- Citation three days over Warning", DateDiff(citation_date, Date(contact_date),'days') <=2, "Contact Made 2", "Open") ... View more