Working with App Builder

Sheets

By default, new templates consist of one sheet

There are two main options:  

    1. Name - Consists of the sheet name.
    2. Functionality - You can enable or disable the sheet.
    3. Design - Consist of Setting Width & Height of the sheet, Background color, Rounded Corners and Margin for Pod & PodGrids.

 

Pods

The first part of the Editor is known as the POD, which is, in essence, a spreadsheet. A Toolbar consists of a Pod, which includes:

  • Default five number of columns
  • Default five number of rows
  • Their intersections, called cells

 

a.  In a Pod, the Column is defined as the vertical space. Letters are used to designate each Column's.

  

In the above diagram the COLUMN labelled C is highlighted.

 

b.  In a Pod, the ROW is defined as the horizontal space. Numbers are used to designate each ROW

In the above diagram the ROW labeled 3 is highlighted.

 

c.  While working in a Pod, you can move a control cell (text box, text area, combo box, calendar, time, check box,) from one location to another. You can either remove it from its original location or move it to another location. You can also copy the original control cell and paste it to another location.

 

 

Insert

To Insert Column to a Pod

    1. With the mouse pointer, right click on the any cell from the column where you want the new column added.
    2. Choose the Insert option and choose Column to the left or Column to right
    3. The new column will be inserted

As you can see from this example, there was a blank column inserted into the Pod. 

 

To Insert Row to a Pod

    1. With the mouse pointer, right click on the any cell in the row where you want the new row added.
    2. Choose Insert and choose the Row above/ below option
    3. The new row will be inserted above the row you selected.

As you can see from this example, there was a blank row inserted into the Pod.

 

Delete

 

Deleting Columns

Before you delete, it is important to realize that any data located in the rows or columns being deleted will be deleted as well.

To delete a column from a pod

      1. Right click on the any cell in the column you want to delete
      2. Choose the "Delete Column" option from the list

You cannot delete all columns. A minimum of one column should be there at all times. When you try to delete the last remaining column, the application will display the following message:

                  

Delete Row

To delete a row from a Pod

    1. Right click on the any cell in the row you want to delete
    2. Choose the “Delete Row” option from the list

You cannot delete all rows. A minimum of one row should be there at all times. When you try to delete the last remaining row, the application will display the message: “One row should be there.”

 

Merge Cells

There are two ways to merge cells.

 

a.  You can merge cells via POD.

 

    1. Right click of the mouse of one cell where you want to merge
    2. Choose the table from the list
    3. Choose the Merge Cells and choose Merge cell Left/ right OR merge cell Up/ Bottom.

Once you merge the cells horizontally, then you are not able to merge that cell with other vertical cells and vice versa

 

b.  In toolbar there is the option Merge All

If you wish to merge a group of cells, you must first select those cells. You can select the cells as -

1) Go to any one cell you want to select

2) Hold the left click and drag it to the other cells you want to select.

The selected cells are highlighted. As shown in below figure row 3 and row 4 are selected.

Click the option Merge All from the toolbar and all the cells selected will be merged into one cell as shown in the image below:

 

Unmerge All

To unmerge the cell, select the already merged cell and click on the unmerge option in the toolbar.

 

Pod Grid

The next part of the editor is what separates us from the rest, with our custom feature called Pod Grid

The tool bar consists of PodGrid which includes:

      • Default five number of columns
      • Default one Header row
      • Default one Body row- consists of default five input boxes.

Default one Footer row

PodGrid behaves just like a spreadsheet but with one major difference. The header and footer act exactly the same as any pod or spreadsheet. It’s the Body line that makes this feature special. Once the PodGrid is created, the Body can be duplicated over and over depending on how the data is needed.

 

Insert

 

a.  Insert column to PodGrid

 

 

1.  With the mouse pointer, right click on any cell from the column where you want the new column added.

2.  Hover over the insert tab and choose the option Column to the Left or Column to Right.

3.  The new column will be inserted

As you can see from this example there was a blank column inserted into the PodGrid.

 

b.  Inserting Row in PodGrid

You cannot add rows in the PodGrid Body. You can add a row in the PodGrid Header and Footer.

To add row in Pod Grid Header/ footer

      1. With the mouse pointer, right click on any cell in the row where you want the new row added.
      2. Hover over the Insert tab and choose the Row above/ below option
      3. The new row will be inserted above the row you selected.

In the above figure, two rows are added in the PodGrid Header. You can also add rows in the PodGrid footer also.

 

Delete

a.  Delete Column

Before you delete, it is important to realize that any data located in the rows or columns being deleted will be deleted as well.

To delete a column from a PodGrid

      1. Right click on the any cell in the column you want to delete
      2. Choose the “Delete Column” option from the list

You can’t delete all columns. A minimum of one column should be present.

b.  Delete Row

You cannot delete the PodGrid Body row.

To delete a row from a PodGrid:

1.  Right click on the any cell in the row you want to delete

2.  Choose the “Delete Row” option from the list

You can’t delete all rows. A minimum of one header row and one footer row should be there.

 

Merge cell

Merging cells on PodGrid is the same steps as Merging cells on Pod.

Notes:

    • You cannot merge PodGrid Body cells
    • You cannot merge multiple controls

 

Example of PodGrid

PodGrid behaves just like a spread sheet but with one major difference. The header and footer act exactly the same as any pod or spreadsheet. It’s the Body Line that makes this feature special. Once the PodGrid is created, the Body can be duplicated over and over again depending on how the data is needed, as demonstrated in the diagrams below.

 

a.

b. 

Below is another example of how a pod grid can be modified to produce different lines of data. As you can see in the image below, the pod grid can be modified and split up into 3 groupings: the Header, which is (Client, Project, Task, Activity and Days row), the Body, which contains the multiple lines that can be added as needed (Client name, Project name, Task and etc...), and the Footer, which contains the total.

Youtube Link:- https://youtu.be/jAvy0vublXM

 

 

 

Have more questions? Submit a request

Comments

Powered by Zendesk