Editing related data with calculated expressions

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
<script type="text/plain" id="get-owner-count">
  // Check the edit context
  // If it is insert (create workflow), return and get out
  if ($editcontext.editType == "INSERT") {
    return;
  } else {
    // If not Insert/Create
    // Get a FeatureSet of owners from the related owners table
    var ownersFeatureSet = (FeatureSetByRelationshipName($feature, 'NZParcels_Owners', ['*'], false));
    // Make sure ownersFeatureSet is not empty
    if(!(IsEmpty(ownersFeatureSet))) {
      // Count the amount of owners within the owners featureset
      var countOwners;
      countOwners = Count(ownersFeatureSet)
      // Apply the count to the value in the owner_number field
      return countOwners;
    }
   // If ownersFeatureSet is empty, return nothing.
   return;
  }
</script>

1
2
3
4
5
6
const getOwnerCountExp = new ExpressionInfo({
  expression: document.getElementById("get-owner-count").text,
  name: "get-owner-count",
  returnType: "number",
  title: "Get owner count"
});

1
2
3
4
5
6
7
8
9
10
const ownerCountParcelFE = new FieldElement({
  description: "Queries the related owners table and counts the number of owners related to this parcel",
  label: "Total no. of owners",
  fieldName: "owner_number",
  editableExpression: falseExp.name,
  input: { // autocastable to TextBoxInput
    type: "text-box"
  },
  valueExpression: getOwnerCountExp.name
});

1
2
3
4
5
const parcelsFormTemplate = new FormTemplate({
  title: "Parcel ID - {parcel_id}",
  elements: [parcelIdFE, parcelTypeFE, calcParcelAreaFE, ownerCountParcelFE, relatedOwners, relatedPermits],
  expressionInfos: [createParcelIdExp, calcParcelAreaExp, getOwnerCountExp, trueExp, falseExp]
});

1
2
3
4
5
6
view.map.editableLayers.forEach((layer) => {
  if (layer.title == "Parcels") {
    parcelsLayer = layer;
    parcelsLayer.formTemplate = parcelsFormTemplate;
  }
});