What are COMP Table Blocks?
Computation (COMP) Table blocks contain spreadsheets that are identical to a Table.
Being a Function like the MERGE, FILTER and LOOP blocks, a COMP Table block does not display a page to your user. It instead processes your user's inputs in the background.
How to design a COMP Table spreadsheet
COMP Table spreadsheets are set up in the same way as a Table.
The cells in COMP Table spreadsheets, like Tables, also have TBL_[cell] field codes that can be dynamically referenced.
Note: When creating computation spreadsheets, you must reference external variables in a cell in the computation spreadsheet before using the variable in equations, as shown below:
Example of correct use:
Example of incorrect use:
What are the common use cases of COMP Table blocks?
COMP Table blocks can be used to:
- Perform automatic calculations in the background
- Store data which can be retrieved using an INDEX-MATCH design pattern
- Score Tallying System
- Create new variables
- Assign a numerical value to user-selected values