
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 08, 2020 04:29 AM
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} = '')
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 08, 2020 04:29 AM
Nevermind, I found the solution while writing the question.
filterByFormula:
OR({customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}', {customerOwnerRef} = '')
,

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 08, 2020 04:29 AM
Nevermind, I found the solution while writing the question.
filterByFormula:
OR({customerOwnerRef} = '${process.env.NEXT_PUBLIC_CUSTOMER_REF}', {customerOwnerRef} = '')
,
