• v5
• Print
• Share
• Dark
Light

## Multi-line eForms

The Multi-line eForm feature is one of the more confusing and non-typical features of the eBMS Platform.

There are times when you need to have multiple items that function very similiarly, for example:

A simple debit/credit form

In this example, each of those drop-downs has the name Amount . To achieve this, each of them has a distinct LineNumber value from 1 to 16. The calculation for Total is very simple, owing the multi-line design. An OHS Induction assessment form In this example, each of those drop-downs has the name Answer . To achieve this, each of them has a distinct LineNumber value from 1 to 8.

By giving each of these the same names we derive a few benefits:

1. Formulas can be easily be written to calculate a score across every row

2. You can design a single line, and then with a single button replicate that line any number of times

3. It is a simple mechanism for allowing a 1-to-N relationship within a form

## Tutorial

1. Create a new eForm named Calculator

2. Set it out as below: • When you create a textbox for use in a multi-line table, you must uncheck the ‘Header?’ checkbox: • Add a Label and TextBox for Item Description .

• Add a Label and TextBox for Amount (of Data Type Number)

Feel free to format it nicely with a \$ and to 2 decimal places.

3. Select the Item Description and Amount textboxes

4. Find the Action panel on the left side of your screen 5. Enter 16 as shown

6. Click Go

7. You should now see something like this: Note that each row has the same name, but a different number. If you need to refer to a specific row in a formula you can use this syntax: [Amount]#7 .

8. Add a total Number TextBox

9. We don’t cover array formulas in this tutorial, so you’ll have to trust me. Try the formula:

``````SUM(EACH [Amount])
``````
10. Try it out For more concept information about Multi-line eForms refer to Multi-line eForms