I have been able to use concatenation for short text. I’m wondering if I can use it to build longer strings? I have a bunch of reports for different status levels. If they are empty I don’t want to see the table header and I want to display some pro-forma text to say “Nothing to see here.”
I thought that I could push everything into a variable then print it at the end. I’m using a counter in the loop, so I tested a simple IF =$counter$= > 0 ELSE and that worked.
In addition to avoiding concatenation, one change I’ve made here is to initially set your counting variable to a value of zero, to ensure it’s treated as a numeric variable.
Yes, I get it. You declare the variable within the loop. The loop doesn’t run unless it has a found set, so checking the variable after the loop will tell me whether I have entered the loop, i.e., did the filter return any notes.
It wasn’t working when the string length was thousands. However, it does work for short strings. When I naively used it in a different collection the longest possible string length was always going to be less than 32 characters. It worked reliably there. It would be interesting to know what the limit is. Being able to utilise concatenation, even if it is length limited, is extremely powerful.