Tutorial: Multi-line Forms

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.

calc-4-complete

An OHS Induction assessment form

questions-samples

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:
    calc-1

    • When you create a textbox for use in a multi-line table, you must uncheck the ‘Header?’ checkbox:
      isheader
    • 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
    calc-2-replicate
  5. Enter 16 as shown
  6. Click Go
  7. You should now see something like this:
    calc-3-multiplelines
    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
    calc-4-complete

For more concept information about Multi-line eForms refer to Multi-line eForms

Related Articles