Hi everyone, I apologise for missing something that must be blindingly obvious… After searching on this forum and in the Make documentation, I’m unable to find what’s wrong here:
Goal I’m trying to set the variable Var_Newclient to true if a client’s name is not found in an array containing a list of existing clients.
Steps
STEP 1 List clients in a column in a Google Sheet; returns the same number of bundles as there are rows in the Google Sheet. Clients are in column C. Looks like this:
This seems like a complex scenario you’re trying to make, perhaps exporting the blueprint might help others replicate the issue to be able to answer your question.
At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.
It looks like your array doesn’t contain plain text or dates, but contains objects.
Every object has a property C which contains the value you want to be filtering.
Within the ‘set variable’ component, try changing 121. Array[] into map(121. Array[];C)
@Loopz > Thanks! That sounded relevant, but I tried and unfortunately it still doesn’t work. Before even using if(), I’ve tried with contains() + map(), and the below generates false despite “Accor” being in 121.array:
Use the map function like before. Instead of putting C as parameter, you put 0. That is because C is the label of the key, the the actual key is 0. If you hover with the cursor above key C, you’ll notice
