Script samples

Copy a value from one field to another
Calculate sum (difference, percentage) of multiple fields
Hide a field
Hide a filed from a certain step
Write a value from a catalog column to a form field
Make sure the end date isn’t before the start date
Make sure at least one field is filled out
Search for duplicate entries in the register
Deadline extension depending on priority
Automatically change task status after receiving a reply
Autocomplete service level agreement resolution time
Hide a form field if an email doesn’t come not from a designated address
Filter a catalog

Copy a value from one field to another

This script copies the value from “Source field” to “Text field”.

form.onChange(['Source field'], true)
  .setValue('Text field', state => {
    const [value] = state.changes;

    if (!value)
      return null;

    return value.text;
  });

Calculate sum (difference, percentage) of multiple fields

In this example, the script adds up rental cost and deposit, then applies a 7% discount and displays this sum.

form.onChange(['Rental price', 'Deposit'])
  .setValues(['Discount', 'Total'], state => {
    const [price, deposit] = state.changes;

    if (!price || !deposit)
      return null;

    const discount = price.value * 0.07;
    const total = price.value + deposit.value - discount;
    return [discount, total];
  });

Hide a field

In this example, the 'Discount' field is hidden if the value in the 'Quantity' field is up to 99.

form.onChange(['Quantity'], true)
  .setVisibility(['Discount'], state => {
    const [quantity] = state.changes;

    if (!quantity)
      return null;

    return quantity.value > 99;
  });

Hide a field from a certain step

In the example below, the Client field will be hidden from the second step of the workflow.

form.onChange([''], true)
  .setVisibility (['Client'], state => {
    return state.currentStep < 2;
 });

Write a value from a catalog column to a form field

Here “Catalog” is the name of the form field with a catalog, “Column” is the name of a catalog column, and “Text” is the **Text** type form field where the value is stored.

form.onChange(['Catalog'])
  .setValue('Text', state => {
    const [item] = state.changes;

    if (!item || !item.columns)
      return null;

    return item.columns['Column'];
  });

Make sure the end date isn’t before the start date

form.onChange(['Start date', 'End date'])
  .validate('End date', state => {
    const [start, end] = state.changes;

    if (!start || !end)
      return null;

    if (start.date && end.date && start.date >= end.date)
      return {
        errorMessage: 'The end date cannot be before the start date.'
      };

    return null;
  });

Make sure at least one field is filled out

form.onChange(['Email', 'Phone'], true)
  .validate('Email', state => {
    const [email, phone] = state.changes;

    const emailIsEmpty = !email || !email.text;
    const phoneIsEmpty = !phone || !phone.text;

    if (emailIsEmpty && phoneIsEmpty)
      return {
        errorMessage: 'Add your email or phone number.'
      };

    return null;
  });

Search for duplicate entries in the register

Suppose there is a form with the fields “Year”, “Number”, and “Document”. Using this script, you can send a request to the register and check if the document has already been published.

form.onChange(['Year', 'Number'])
  .validateAsync('Number', async state => {
    const [year, num] = state.changes;

    if (!year || !num)
      return null;

    if (year.text && num.text) {
      const duplicates = await form.fetchSelfRegister(f => f
        .fieldEquals('Year', year)
        .fieldEquals('Number', num), []
      );

      if (!duplicates || !duplicates.tasks)
        return null;

      const firstDuplicate = duplicates.tasks[0];
      if (firstDuplicate)
        return {
          errorMessage: `Order <a href="#id${firstDuplicate.task_id}">has already been published.</a>`
        };
    }

    return null;
  });

Deadline extension by priority

This script lets you change a task's due date based on its priority, or set a custom due date.

form.onChange(['High priority', 'Date shifting'])
  .setValue('Due date', state => {
    const [checkmark, customDue] = state.changes;

    if (customDue && customDue.date)
      return {date: customDue.date};

    if (!checkmark)
      return null;

    if (checkmark.checked)
      return {days_from_create: 1};

    return {days_from_create: 3};
  });

Automatically change task status after receiving a reply

const orgId = 111111;

form.onChange([], true)
  .setVisibility(['Open / Done'], 
    state => false
  );

form.onChange([], true)
  .setStatus(state => {
    if (state.commenter && state.commenter.organization_id !== orgId)
      return {choice_name: 'In progress'};
  });

form.onChange(['Responsible'])
  .setStatus(state => {
    const [currVal] = state.changes;
    const [prevVal] = state.prev;

    if (!prevVal && currVal)
      return {choice_name: 'In progress'};
  });

Autocomplete service level agreement resolution time

You can specify resolution time and field names in the script using specific numbers,, variables, or formulas to calculate the resolution time. When the Priority and Client form fields are changed, the script will determine one of the designated due dates.


form.onChange(['PriorityThe name of a Catalog field in the service ticket form.
', 'ClientThe name of a Catalog field in the service ticket form.'])
  .setValue('Due dateThe name of a Date field in the service ticket form.', 
    state => {
      const [priority, client] = state.changes;

      if (!priority || !priority.columns || !client || !client.columns)
        return null;

      const tariff = client.columns['Rate planThe Client catalog column of service rates.'];
      const priorityValue = priority.columns['PriorityThe name of a column in the Priority catalog.'];
      const hours = getSlaHoursByTariffAndPriority(tariff, priorityValue);

      if (hours === undefined)
        return null;

      return {hours_from_create: hours};
    });

function getSlaHoursByTariffAndPriority(tariff, priority) {
  switch (tariff) {
    case 'BasicThe name of a rate plan from the Client catalog column.':
      switch (priority) {
        case 'LowThe value from the Priority catalog column.
' : return 64The deadline in hours.;
        case 'MediumThe value from the Priority catalog column.
': return 32Срок в часах;
        case 'HighThe value from the Priority catalog column.
': return 16The deadline in hours.;
      }
    case 'StandardThe name of a rate plan from the Client catalog column.':
      switch (priority) {
        case 'LowThe value from the Priority catalog column.
' : return 32The deadline in hours.;
        case 'MediumThe value from the Priority catalog column.
': return 16Срок в часах;
        case 'HighThe value from the Priority catalog column.
': return 8The deadline in hours.;
      }
    case 'PremiumThe name of a rate plan from the Client catalog column.':
      switch (priority) {
        case 'LowThe value from the Priority catalog column.
' : return 16The deadline in hours.;
        case 'MediumThe value from the Priority catalog column.
': return 8Срок в часах;
        case 'HighThe value from the Priority catalog column.
': return 4The deadline in hours.;
      }
    default:
      return undefined;
  }
}

Hide a form field if an email doesn’t come not from a designated address

The script identifies the sender’s email address, and if a message is not from mail@example.com, the Category field will be hidden.

form.onChange(['Email'], true)
  .setVisibility(['Category'], state => {
    const [email] = state.changes;
    return email && email.text == "mail@example.com";
  });

Filter a catalog

This script filters the list of cities by selected state. You might also use it to show the expenses related to a specific department chosen from a list of other departments.

let catalogItems = null;

form.getCatalog("US states and citiesThe catalog that binds values from two other catalogs.").then(items => {
  catalogItems = items;
});

form.onChange(["StateThe form field that defines values available for the City field.
"]).setFilter("CityThe form field where values change depending on the value selected in the State field.", state => {
  const [region] = state.changes;

  if (!catalogItems || !region || !region.columns)
    return null;

  const regionCol = region.columns["StateThe title of the column that defines values available in the City field.
"];
  const filtered = catalogItems
    .filter(item => item.columns["StateThe title of the column that defines values available in the City field."] == regionCol)
    .map(item => item.columns["CityThe name of the column where potential City fields come from."]);
  
  return filtered.length > 0
    ? {
        values: filtered
      }
    : null
});

Sidebar