• Database Builder

Calculated columns and Sub Columns

Updated: Jan 6

Calculated columns are used for two reasons: One, to calculate a total between various columns. Two, to bring in multiple columns from another table.


To calculate a total between various columns:


  • You will see a calculated value line and a few tabs just below that.

  • Click on any of these tabs you want to include in your calculation, you can join them by clicking on any of the function icons. Depending on the column type, functions will include; +,-./,x.

  • Once you have your calculation, click save.

  • When adding new records, this column will be greyed out and calculated automatically once you save the new record.

To bring in columns from another table.


In order to bring in columns from another table, you first need to create a From Table column. Do this by:

  • Adding a new column to the table

  • Selecting From Table as your column type

  • Selecting the table you would like to reference from under 'select a table'

  • Save

  • This will bring in the first column of the table you would like to reference

Next:


  • You will see a Sub Columns section.

  • Click on the tab you want to add to your table. It will be added to the calculated value line


  • Click Save.

  • When adding new records, this column will be greyed out and calculated automatically once you save the new record.


37 views

Recent Posts

See All