Grouping and Retrieving Data

Let's use Scaffolding to group data and then retrieve it.

Ingredients

Add-ons

Scaffolding

Platform

Macros
Suppliers


Step-By-Step Guide


  1. Create a Group Data macro and name it "HRperson."

  2. Inside that Group Data macro, create a table like the one below:

    Name 
    Title 
    Position 



  3. Now create two Text Data macros, a List Data macro and a set of List Option macros, like in the following image:




  4. Give the first Text Data macro a Field Name of "name" and a Content Type of text

  5. Give the second Text Data macro a Field Name of "position" and a Content Type of text.

  6. Give the List Data macro a name of "jobtitle" and the List Option macros a value and label of "Mr", "Mrs", and "Ms" respectively. 

  7. Now create another set of macros by repeating Steps 1 - 6, but this time change the Group Data name to "ITperson", while keeping the rest of the properties the same for all the macros.
    You should have something like the following image:




  8. Now let's collect all the data from the macros we created before and compile them into one place.
    Create a table like this:

    TitleNamePosition

     

     

     

     

     

     



  9. Add 6 Get Data macros, one for each cell.
    For each macro, enter an appropriate Field Name with the format of groupName.dataName.
    For example, for the first cell, you can use "HRperson.jobtitle" (based on the title and group name you provided in the above steps).
    You should have something like the following image:




  10. Now save the page and click Edit Contents.

  11. Enter some information into the form and check out the results. 

 


Notes

When defining Get Data, use groupName.dataName for the name parameter.

Result

HR

Name

Cameron Corsola

Title

Mr

Position

Head of Human Resources

IT

Name

Yvette Yvangel

Title

Ms

Position

Linux Administrator

List of Employees

TitleNamePosition


Mr

Cameron CorsolaHead of Human Resources


Ms

Yvette YvangelLinux Administrator