Search code examples
soql

Using cell value as SOQL field with G-connector


Is there a way to call for a cell value when building the SOQL query using G-connector for Google Sheets or Excel?

E.g.

SELECT A FROM B WHERE C= ''Sheet Name'!C5'

Kindly, Rasmus


Solution

  • Yes there is! :)

    SELECT A FROM B WHERE C= '[Sheet Name!C5]'