ConvertCalculator Icon

FINDMANY & FINDFIRST

Learn how to use the FINDMANY and FINDFIRST functions

Where the TABLEFINDMANY and TABLEFINDFIRST function are used to query ConvertCalculator Tables, we created companion functions that can be used on regular Datasheets and on GoogleSheets:

  • FINDMANY
  • FINDFIRST

Both functions query data on the client, which makes them a bit less secure than our Table-functions, that query data on the server.

The FINDMANY and FINDFIRST functions are available under all plans.

FINDMANY

FS
FINDMANY(matrix_reference, find_column_reference, find_column_value, sort_column_reference, sort_column_order)
  • matrix_reference: the matrix from which to retrieve a value. This can be a datasheet (e.g DA) or a Google sheet imported with the GOOGLESHEET function.
  • 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: a 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).

FINDFIRST

FS
FINDFIRST(matrix_reference, find_column_reference, find_column_value, sort_column_reference, sort_column_order)
  • matrix_reference: the matrix 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: 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.