How do I cross-reference tables in formulas?

Cross-referencing allows you to link cells from one table (within your template) to another.

Before setting up the equation, you'll need to ensure you've enabled cross table referencing within the template.

To do this, click onto any formula cell in the form builder. Select 'Enable table cross-referencing' if the button appears (if it doesn't, it means it's already enabled and you're good to go!)

When referencing another table, you'll need to know:

The table number you'd like to reference
- To find this, simply click on any formula cell within the template editor to reveal the table number at the top of the field.
The column/cell you'd like to reference
- Similar to above, select any formula cell within the template to reveal the column/cell information along the top/sides of the table field.

Using this information, you can then reference other tables using this formatting in your formula: Table#!cell_reference. E.g Table5!D:D or Table3!C1.

Note:

To reference all the values in an entire column, use A:A, B:B, ect. notation from the table in the formula.
Default tables can automatically increment the cell ID =A1+1, if this is not the desired behaviour, use $A1 within your formula.
You can store constants using formula cell =1 or =”TEXT”, as a pre-filled text/number cell.

Here are a few other things to take note of while using a formulas that cross-reference other tables:

Dashpivot Mobile app users will need to use versions v23.2 and later to complete forms using the table cross-referencing feature.
Sitemate Mobile app users will need to use versions v23.1 and later to complete forms using the table cross-referencing feature.