Hi - anyone using Celigo integrator.io: do you know if it's possible to use a Formula (Text) NS criteria as part of additional lookup criteria when doing an additional NS lookup?

hey @al3xicon did you get your question answered? If not, you can always ask in our Community https://docs.celigo.com/hc/en-us/community/topics/201073147-Celigo-integrator-io

@matt.graney the question was already asked and was not really answered (https://docs.celigo.com/hc/en-us/community/posts/360076887352-Formulas-in-Lookup-search-criteria) - I believe the solution may be similar to how formulae are represented within SuiteScript but haven't been able to confirm on my own yet.

Here

@Shubi how do you designate the formula, though?

@al3xicon what's your formula? Let me see if I can make it work

SUBSTR({name},0,INSTR({name},' : '))

- but really it's more a question of the syntax, not in how to get a particular problem solved. I want to know in general how to represent NS saved search formulae in this screen

I personally haven't used formulas in celigo but I have added additional normal criteria. I'm curious about it too now.

no not yet but don't worry about it

Technically speaking - something like this should work. Try a simple case when formula