Common functions created using the logic builder

Category: Form Builder - Script Editor Section: Basics of Scripting Last Updated: 2023-11-01

---

Ready-to-use Logic Builder scripts for common tasks. Copy into your field's Logic tab.

CONFIGURATION

• Trigger Type: JavaScript
• Action Type: Value
• Change data. to row. for fields inside repeats

---

Get Gender from Person Control

Determines gender from the salutation field.

Trigger

var input = data.person;
result = input !== undefined ? true : false;

Action

var input = data.person;
if (input.Sal_cho === '') {
  value = 'Unspecified';
} else if (input.Sal_cho === 'Mr' || input.Sal_cho === 'Dr(M)') {
  value = 'Male';
} else {
  value = 'Female';
}

---

Calculate Age from Date

Calculates age in years from a date of birth field.

Trigger

var input = data.DOB_dt;
result = input !== undefined ? true : false;

Action

var input = data.DOB_dt;
var age = (parseInt(moment().format('YYYYMMDD')) - parseInt(input.replace(/-/g, ''))) + '';
var dummy = age.replace(age.slice(-4, age.length), '');
value = dummy === '' ? 0 : dummy;

---

Sum Repeat Values

Totals all instances of a number field within a repeat.

Trigger

var rpt = data.Repeat_rpt;
result = rpt !== undefined ? true : false;

Action

var rpt = data.Repeat_rpt;
var count = 0;
for (i = 0; i < rpt.length; i++) {
  var input = rpt[i].Number_num;
  if (input === '' || input === null || input === undefined) {
    input = 0;
  }
  count += parseInt(input);
}
value = count;

---

Build List from Repeat

Creates a formatted list (e.g., "A, B and C") from repeated text values.

Trigger

var rpt = data.Repeat_rpt;
result = rpt !== undefined ? true : false;

Action

var rpt = data.Repeat_rpt;
var Arr = [];
var string = '';

for (i = 0; i < rpt.length; i++) {
  var input = rpt[i].Field_txt;
  if (input !== '') {
    Arr.push(input);
  }
}

if (Arr.length > 0) {
  string = Arr[0];
}
if (Arr.length > 1) {
  for (i = 1; i < Arr.length - 1; i++) {
    string += ', ' + Arr[i];
  }
  string += ' and ' + Arr[Arr.length - 1];
}
value = string;

---

Field Reference Quick Guide

Location	Syntax
Outside repeat	data.FieldName
Inside same repeat	row.FieldName
Repeat array	data.RepeatName_rpt
Repeat row field	rpt[i].FieldName