Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using this expression to combine 2 fields in a Title. How can I combine these 2 expressions. I want to show URLs selected in the title, but would like it to be blank when nothing is selected.
IF GetFieldSelections (URL) is null,
=CONCAT({<URL=>} DISTINCT URL, ', '), show URLs
Thanks,
Fred
Why not just use GetFieldSelections(URL)? This will return selections made, and if none have been made, it will return null. If you want to replace the null with a blank space, you could wrap this in a Coalesce(GetFieldSelections(URL),'')
=if(getselectedcount(URL)>0, THEN something, Else something)