Property Calculator Intermediate Examples

Overview

Each example includes the scenario, the expression, a step-by-step explanation, and the expected result. All examples use Calculate Expression mode unless noted otherwise.

7. MSLU Aggregation — Invoice Total from Line Items

Scenario: An invoice object has an MSLU property Invoice Lines linking to line item objects. Each line item has an Amount property. Calculate the invoice total.

Sum(%PROPERTY_{PD.InvoiceLines}.PROPERTY_{PD.Amount}%)

How it works:

1. %PROPERTY_{PD.InvoiceLines}% resolves to the MSLU (3 lookup items)
2. .PROPERTY_{PD.Amount}% chains to read Amount from each linked object
3. The placeholder auto-expands: Sum([__P0], [__P1], [__P2]) where P0=500, P1=1200, P2=350
4. Sum() returns 2050

Bonus — Invoice total with VAT:

let('subtotal', Sum(%PROPERTY_{PD.InvoiceLines}.PROPERTY_{PD.Amount}%),
  Round(get('subtotal') * 1.24, 2))

Result: 2542.00

8. Regex Extraction — Order Number from Text

Scenario: A document title contains an order number in the format “ORD-NNNN”. Extract just the numeric part.

regexMatch(%PROPERTY_{PD.Title}%, 'ORD-(\d+)')

To get just the number part:

regexMatchGroup(%PROPERTY_{PD.Title}%, 'ORD-(\d+)', 1)

Result: 4521

9. Switch-Based Mapping — Country to VAT Rate

Scenario: Determine VAT rate based on the customer’s country.

switch(lookupName(%PROPERTY_{PD.Country}%),
  'Finland', 0.255,
  'Sweden', 0.25,
  'Norway', 0.25,
  'Denmark', 0.25,
  'Germany', 0.19,
  'France', 0.20,
  'UK', 0.20,
  0.00)

10. String Assembly with Conditions — Address Block

Scenario: Build a formatted address string, handling optional fields gracefully.

concat(
  %PROPERTY_{PD.StreetAddress}%,
  iif(isNullOrEmpty(%PROPERTY_{PD.ApartmentUnit}%), '', concat(', Apt ', %PROPERTY_{PD.ApartmentUnit}%)),
  '\n',
  %PROPERTY_{PD.City}%, ' ',
  %PROPERTY_{PD.PostalCode}%,
  '\n',
  lookupName(%PROPERTY_{PD.Country}%))

11. Date-Based Conditional — Contract Expiry Warning

Scenario: Set a warning text when a contract is within 30 days of expiration.

let('daysLeft', dateDiff(today(), %PROPERTY_{PD.ContractEnd}%, 'days'),
  iif(get('daysLeft') < 0, 'EXPIRED',
    iif(get('daysLeft') <= 30, concat('Expires in ', get('daysLeft'), ' days'),
      iif(get('daysLeft') <= 90, concat('Expires in ~', Round(get('daysLeft') / 30, 0), ' months'),
        'Active'))))

12. File Count Validation — Check for Required Attachments

Scenario: Generate a status text indicating whether required PDF documents are attached.

let('pdfCount', filecount('pdf'),
  iif(get('pdfCount') == 0, '❌ No PDF attached',
    iif(get('pdfCount') == 1, '✅ 1 PDF attached',
      concat('✅ ', get('pdfCount'), ' PDFs attached'))))