TabReference gives you the possibility to use of other functions in order to retrieve any text field value within its properties. A common example here may be using a ParameterValue to define question value. Let’s say that we parameterize make on another tab in Query. Once you parameterize make of the new car, you can use ParameterValue expression in the expression window instead of typing in the exact name of the make.
Previously created page, has reference to a tab with with only one parameter - Country.
Let’s now add an additional text field, now linked to the new tab which includes the parameter - note that now the second parameter becomes visible in Compose.
We can now use this parameter to define the value for Make of new car question. We will use the ParameterValue function for this.
Note that - similarly to TabReference and many other expressions - pressing “@” will provide suggestions based on available parameters.
As a result, we get exactly the same value, but now it is based on the parameter value rather than specified directly.
In the examples above, you can see that the formula ends with the statistic (Mean). In such a case TabReference provides Value from the given cell by default. As described above, it is also possible to retrieve other properties of the cells. Some common use cases here might be:
Retrieving formatted value, which provides value from the cell converted to string- this allows to skip conversion to string in case we want to use the value as part of a longer text;
