Table Functions

This article explains how to use our unique table functions

We support multiple functions to query Datasheets and GoogleSheets, like VLOOKUP and INDEX function. With our introduction of Tables, we have created new TABLE functions, which are designed to query table data in a better, more secure way.

One important difference between the new TABLE functions and our current query functions is where the table data is queried: on the server versus on the client. The TABLE functions query data on the server.

We have created two unique Table functions:

  • TABLEFINDMANY()
  • TABLEFINDFIRST()

The TABLEFINDMANY() and TABLEFINDFIRST() functions are available under the Platinum plan.

TABLEFINDMANY()

The TABLEFINDMANY() function returns all rows from a table that match the value you are looking for in a given column.

FS
TABLEFINDMANY(table_reference, find_column_reference, find_column_value, sort_column_reference, sort_column_order)
  • table_reference: the table from which to retrieve a value.
    Note: a table should not be confused with a datasheet. Tables are available on the workspace level, while datasheets are available within a calculator only.
  • find_column_reference: the column in the datasheet from which to retrieve the value you are looking for. You can either reference the column by its letter reference (e.g. A, B, C) or its numerical reference (eg. 0, 1, 2, 3)
  • find_column_value: The value to look for in the referenced column. For instance an email, or ID.
  • sort_column_reference: the column that sets the sorting for cases where multiple rows are returned.
  • sort_column_order: the order to sort the column: ascending (1) or descending (-1).

Example

FS
TABLEFINDMANY(TA, A, your@email.com, B, 1)

With this example, you look in Table_A, for a value in column A (the first column), for all values that match the email your@email.com and sort by column B in ascending order.

The returned value will be a table containing all the rows that match the search query.

TABLEFINDFIRST()

The TABLEFINDFIRST() function returns the first rows from a table that match the value you are looking for in a given column.

FS
TABLEFINDFIRST(table_reference, find_column_reference, find_column_value, sort_column_reference, sort_column_order)
  • table_reference: the table from which to retrieve a value.
  • find_column_reference: the column in the datasheet from which to retrieve the value you are looking for. You can either reference the column by its letter reference (e.g. A, B, C) or its numerical reference (eg. 0, 1, 2, 3)
  • find_column_value: The value to look for in the referenced column. For instance an email, or ID.
  • sort_column_reference: the column that sets the sorting querying the table
  • sort_column_order: the order to sort the column: ascending (1) or descending (-1). Since this function only returns one value, the sort_column_order and sort_column_reference determine which row is returned in case multiple rows match the find_column_value.

Table

You can also load an entire Table in your calculator with the TABLE() function.

FS
TABLE(table_reference) TABLE(TA)
  • table_reference: the table from which to retrieve a value.
ConvertCalculator Icon

The and