Collecting and Displaying Data in a Structured Way

Let's use Scaffolding to create a form for a user to fill in with data. Then, let's reuse that data and display it in a structured way.

Add-onScaffolding
MacrosText Data, Date Data, List Data, User Options, Get Data
Suppliers

Step-by-Step Guide

Step 1: Create a Table

  1. Create a table with 6 rows and 2 columns.

  2. Fill in the table with the following data:

    Customer
    Junior Developer
    Senior Developer
    Support
    Start Date
    End Date

Step 2: Use Scaffolding macros to Create Form Fields

  1. In the cell next to "Customer", create a Text Data macro and provide a relevant name.
    In this example, we used "Customer".

  2. In the cell next to "Junior Developer", create a List Data macro.
    1. Inside the List Data macro, add another macro by creating a User Options macro.
    2. Edit the User Options macro according to your needs (groups, space(s), user(s) etc.)

  3. Do the same as the above step for the cells next to "Senior Developer" and "Support".

  4. In the cell next to "Start Date", type Date Data.
     
  5. Do the same as the above step for the cell next to "End Date".
    Make sure to give each macro above a unique and identifiable name.
    Your editor view should look something like this:

    Customer
    Junior Developer
    Senior Developer
    Support
    Start Date
    End Date



  6. Click Save.

Step 3: Enter Data into the Form Fields

  1. Click Edit Contents at the top of the page.
    The form you created in the previous step will load.

  2. Fill in the form with relevant data.
    The form table should now look similar to this:



  3. Click Save.

Step 4: Create Another Table to Display Retrieved Data

  1. Edit the page again.

  2. Create a table similar to this:

    Project Initiation
    Project Analysis
    Development
    Code Review
    QA
    Bug Fixes
    Support Handover
    Documentation
    Monitoring
    Reporting
    Project Period

Step 5: Retrieve User-entered Data and Display It

  1. Using the Get Data macro, we can now retrieve the data that was saved into the form fields.
    In the cell next to "Project Initiation", create a Get Data macro.

  2. In the preview window that appears, enter "seniordev" (or whatever name you provided in the "Senior Developer" List Data macro) in the Field Name entry field.

  3. Do the same for the rest of the table cells with Get Data macros that reference the other data macros that we saved information in.

  4. The table should then look something like this:

    Project Initiation
    Project Analysis
    Development
    Code Review
    QA
    Bug Fixes
    Support Handover / /
    Documentation /
    Monitoring
    Reporting
    Project PeriodFrom to  



  5. Click Save.

ProTip

  • Ensure that each Scaffolding element has a unique ID, as having the same ID for different elements may cause issues.
  • Macro names are like variables that store data and these names allow the data to be retrieved at a later time.
  • Dates from Date Data can be formatted (e.g. dd-MMM-yyyy)

Result

You should now have a table that looks like this: