Tutorial: Multi-line Forms
  • 14 Sep 2020
  • 1 Minute To Read
  • Contributors
  • Print
  • Share
  • Dark
    Light

Tutorial: Multi-line Forms

  • 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.

httpebmsnetauwp-contentuploads201309calc-4-complete.png

An OHS Induction assessment form

httpebmsnetauwp-contentuploads201309questions-samples.png

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:

    httpebmsnetauwp-contentuploads201309calc-1.png

    • When you create a textbox for use in a multi-line table, you must uncheck the ‘Header?’ checkbox:

      httpebmsnetauwp-contentuploads201309Image-31.png

    • 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

    httpebmsnetauwp-contentuploads201309Image-26.png

  5. Enter 16 as shown

  6. Click Go

  7. You should now see something like this:

    httpebmsnetauwp-contentuploads201309calc-3-multiplelines.png

    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

    httpebmsnetauwp-contentuploads201309calc-4-complete1.png

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

Was This Article Helpful?