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:
The TABLEFINDMANY() and TABLEFINDFIRST() functions are available under the Platinum plan.
The TABLEFINDMANY() function returns all rows from a table that match the value you are looking for in a given column.