Data

Edit Columns

The Edit Columns Mode allows changing the layout of the fields listed in the Data tab. You can add, remove fields and change their orders.

The Edit Columns allows changing the layout of the fields listed in the Data Page. You can add, remove columns, format and change their orders.

Data Page 21 - Columns

Existing columns can be removed by pressing the trash icon.

Edit Columns upd 1: Edit Columns interface screenshot 2

You can also edit their existing columns’ labels by pressing the edit button.

Edit Columns upd 2: Edit Columns interface screenshot 3

While editing you will options to edit labels’ format.

This is the default setting of the column:

Edit Columns upd 3: Edit Columns interface screenshot 4

While editing you will see 4 options:

Do not use any formating: You can choose not to use any formatting while displaying data for this column, which will effect the displayed data and label in the data page.

Edit Columns upd 4: Edit Columns interface screenshot 5

Database: If this option is selected, displayed data format and column label will be pulled from the SpreadsheetWeb Hub’s database.

Edit Columns upd 5: Edit Columns interface screenshot 6

Control Properties: If this option is selected, displayed data format and column label will be pulled from the designer application.

Edit Columns upd 6: Edit Columns interface screenshot 7

Custom Settings: This option will let you change the label name and choose desired format.

Edit Columns upd 7: Edit Columns interface screenshot 8

You can choose to only display numbers in the data page or change its format to display in the datapage.

Edit Columns upd 8: Edit Columns interface screenshot 9

When you are done formatting the column, click on OK. The changes made will be applied to the applicaitons’ date page immediately.

You can add new columns to the data page from the Add a Column list. You can have a minimum of 5 and a maximum of 20 columns for each application.

Edit Columns upd 9: Edit Columns interface screenshot 10

The ‘Add a Column’ list will list you the existing named ranges in your application and by adding them to the data page, you can display important data to users.

Once you click on an option it will be added as a column immediately. ‘Total Premium’ column which is in the currency format.

Edit Columns upd 10: Edit Columns interface screenshot 11

By clicking on Edit button, you can change the column label and formatting.

Edit Columns upd 11: Edit Columns interface screenshot 12