Skip to main content

General Product Q&A

Not sure where to post? Ask your product-related questions here and get support from the community.

  • 2,654 Topics
  • 6,061 Replies
2654 Topics
Level 4
.146003860Level 4
 General Product Q&A
praveen.ojha12
Level 6
praveen.ojha12Level 6
 General Product Q&A
Level 3
jaikishan.pandy11Level 3
 General Product Q&A
Level 1
mel.schic12Level 1
 General Product Q&A
ankur.sahan
Level 1
ankur.sahanLevel 1
 General Product Q&A
Level 3
.14601241Level 3
 General Product Q&A
Level 3
guturi.rajdeLevel 3
 General Product Q&A
Level 1
yuanyuan.zhangLevel 1
 General Product Q&A
Level 3
ryotaro.manabLevel 3
 General Product Q&A
Level 7
ömer.petekLevel 7
 General Product Q&A
prasanth.s12
Level 1
prasanth.s12Level 1
 General Product Q&A
Level 3
.146001156Level 3
 General Product Q&A
Level 0
anamitra.senguLevel 0
 General Product Q&A
Level 1
.14600109512Level 1
 General Product Q&A
Level 6
reenu.josep12Level 6
 General Product Q&A
Level 0
.146001215Level 0
 General Product Q&A
Level 2
gaurav.bade14Level 2
 General Product Q&A
Level 2
alex.giorgLevel 2
 General Product Q&A
Level 5
florian.hoerl12Level 5
 General Product Q&A
Possibility to define multiple empty variable try catches in FILTER statement?

Hi all, I have implemented the following sheet filter statement, which only applies a filter if at least one value is in a variable (selected through a dropdown): <% if(customer_selection != "") { %>  FILTER whatever; <% } %>  ---------------- However, when I try to add another statement like the above for a second variable within the same sheet load script, then NONE of the two conditional filter statements work.  Can someone provide me with the correct syntax to define multiple of the above conditional filter statements in one sheet load script?   -------------------------  A second question is whether it is possible and if yes what the correct syntax is to define a conditional filter statement like the following: <% if(search_pattern_selection LIKE "XYZ") { %> FILTER whatever;<% } %> Thus, not testing for emptiness but testing with a LIKE comparer if certain values are in a variable.    @david.beche12​ any input on the two questions?  Than

463
Level 0
Level 0
sel.kumLevel 0
 General Product Q&A
Level 1
aya.sasakLevel 1
 General Product Q&A
Level 2
elizaveta.bugaeLevel 2
 General Product Q&A
Level 2
kiran.kanja14Level 2
 General Product Q&A
Level 1
amit.singh13Level 1
 General Product Q&A
Level 4
.1460040856Level 4
 General Product Q&A
Show more activity

Badge Winners

VIEW ALL
Community Code of ConductAccessibility statement