Skip to main content

I’ve successfully applied both those conditions distinctly:



  • filterByFormula: {customerOwnerRef} = ''

  • filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}')


But I don’t understand how to make a logical OR between both conditions, I tried the following but it fails with INVALID_FILTER_BY_FORMULA error:



  • filterByFormula: {customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}' OR({customerOwnerRef} = '')

Nevermind, I found the solution while writing the question.



filterByFormula: OR({customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}', {customerOwnerRef} = ''),


Reply


Terms & Conditions