Add Inline If — IIF()

There are situations in which it’s laborious and clunky to add conditional logic.

For instance, I wanted to update the value of a cell by adding a URL to the existing content. The content should be preceded by a newline only if there already is content.

Without an inline if, I have to make many new nodes to handle both conditions.

A much simpler solution is to allow an inline if so that I could do the following in a Combine Text node:
IIF(length(Input1) > 0, "\n", '')NewUrl

When the length of the input is 0, the result is just NewUrl. But when it’s greater than zero, it’s the newline plus NewUrl

There are libraries that provide basic functions like this that would be reasonably quick to implement. mathjs may do all this.

It might make sense to use a concat(), too.

Definitely makes sense. You can still do this using a custom node, that’s exactly the kind of use case its built for.

Doc: https://blog.gumloop.com/gumloop-custom-nodes/
Video Tutorial: https://www.youtube.com/watch?v=yHjxbmdg-cI&ab_channel=Gumloop
Custom Node Workshop: https://www.youtube.com/watch?v=ovCCWfgWv4M

I could try again but custom nodes don’t seem fully baked yet.

For example, in my first attempt using it, the code generator told me to get the Google doc authentication with a library and even gave me code for it.

Except that after almost an hour of futzing with it, Gummie eventually told me that it’s not possible to get the authentication from Gumloop and I’d have to hardcode it.

This was part of my feedback to Max: Gummie often provides help but often it just says things that are wrong.

Cheers,
André

Makes sense. Gummie + Custom nodes have been a major focus for us lately, and we’re getting ready to ship a new and improved version for both soon. Really appreciate your patience with this!

That’s good to hear. On the whole, it’s better to use Gummie than not but some sessions I have to wonder after it’s given me bad coaching and I’ve wasted an hour…

Cheers,
André

1 Like

This topic was automatically closed 4 days after the last reply. New replies are no longer allowed.