Conditional Concatenation

m · 2024-08-23T15:24:48.401+00:00

Hello, I want to concatenate 3 API string items together. However, the last item does not always have a value. If it does, I need to also add a colon ":" before it. I use the IF formula to check if the 3rd item is an empty string using equals, and if it is not, then I concatenate a colon + the item. However, it didn't return the desired result. What did I do wrong?

m
1 year ago
Hello, I want to concatenate 3 API string items together. However, the last item does not always have a value. If it does, I need to also add a colon ":" before it. I use the IF formula to check if the 3rd item is an empty string using equals, and if it is not, then I concatenate a colon + the item. However, it didn't return the desired result. What did I do wrong?
Lucas G
1 year ago
When 3rd item is empty, does it come in as null or as an empty string?
If it's an empty string, just leave the equals empty
You also don't need the Not node in there but that's not as big a deal
m
1 year ago
@Lucas G mmm, tried that, still doesn't work. The 3rd item shows up as "" in the API if it is empty. What else should I check?
@m
@Lucas G mmm, tried that, still doesn't work. The 3rd item shows up as "" in the API if it is empty. What else should I check?
Lucas G
1 year ago
Just leave it empty, no “”
m
1 year ago
@Lucas G Gotcha!! I removed the one in the If>Then field, didn't see the one in the equal...and it works!! Thank you so much!!!
👍1

Conditional Concatenation

m

Lucas G

m

Lucas G

m