Scripts can be used in forms that contain tables. Use them to:
Unlike automatically calculated table fields, scripts allow you to define conditions and support other field types, like multiple choice.
Suppose you have a form that contains a table with a list of items available for purchase. Each item has a Name, Price, Quantity, Subtotal, and Tax field. Tax is a multiple choice field with three options: 0%, 5% and 7%.
The value of the Subtotal field can be automatically calculated and filled in with help from this piece of code:
form.onChange(['Price', 'Quantity', 'Tax']) .setValue('Subtotal', state => { const [price, quantity, taxRate] = state.changes; if (!price.value || !quantity.value) return [0]; let cost = price.value * quantity.value; const tax = taxRate.choice_name ? parseInt(taxRate.choice_name) : 0; if (taxRate.choice_name) cost += cost * (tax / 100); return [cost]; });
Let’s place two fields, Discount and Grand total, at the bottom of the table.
To automatically calculate the Grand total (the total after the discount), use this code:
form.onChange(['Subtotal', 'Discount']) .setValue('Grand total', state => { const [cost, discount] = state.changes; const total = cost.sum * (1 - discount.value / 100); return [total]; });
Both pieces of code can work together, creating a chain of dependent fields.