Collect and display data in a structured way

Overview

In this tutorial, we will use Scaffolding to create a form for a user to fill in with data. Then, reuse that data and display it in a structured way.

Ingredients

Add-on

Scaffolding

Platform

Server, Data Center

Macros

Text Data, Date Data, List Data, User Options, Get Data

Step-by-step guide

Step 1 - Create a table

  1. Create a table with six rows and two columns.

  2. Fill in the table as shown:

Customer

 

Junior Developer

 

Senior Developer

 

Support

 

Start Date

 

End Date

 

Step 2 - Use Scaffolding macros to create form fields

  1. In the cell adjoining Customer, create a Text Data macro and provide a relevant name.

In this example, we used "Customer".

  1. In the cell next to Junior Developer, create a List Data macro. Inside the List Data macro:

    1. Add a User Options macro.

    2. Edit the User Options macro according to your requirement (groups, space(s), user(s) etc.).

  2. Repeat the same as the above step for the cells next to Senior Developer and Support.

  3. In the cell next to Start Date:

    1. Add a Date Data macro.

    2. Set Name to startdate.

  4. In the cell next to End Date:

    1. Add a Date Data macro.

    2. Set Name to enddate.

Make sure to give each macro above a unique and identifiable name.

Your editor view must look something like this:

Customer

Junior Developer

Senior Developer

Support

Start Date

End Date

  1. Click Save.

Step 3 - Enter data into the form fields

  1. Click Edit Contents at the top of the page.

The form created in the previous step loads.

  1. Fill in the form with relevant data. The form table must look similar to this:

  1. Click Save.

Step 4 - Create another table to display retrieved data

  1. Edit the page again.

  2. Create a table similar to the following:

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

Use the Get Data macro to retrieve the data that was saved in the form fields.

  1. In the cell next to Project Initiation, insert a Get Data macro.

  2. In the Preview window, enter seniordev (or, whatever name given 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.
    The table should then look similar to below.

Project Initiation

Project Analysis

Development

Code Review

QA

Bug Fixes

Support Handover

/ /

Documentation

/

Monitoring

Reporting

Project Period

From to  

  1. Click Save.

Result

The resultant table is similar to the table shown below: