Formatting output

1

I hope someone can shed some light on the following.

I am using a filter formula to output a list - in this sample the list contains only one item. I like to get rid of the “@” symbol and output as a bullet list.

I can get rid if the @ sign, I can output as a bullet list, but I can’t do both. What am I doing wrong?

Formula 1: if([1_ZoekNaam].IsNotBlank(),Pilot.Filter(upper(naam).find(upper([1_ZoekNaam]))>0).list(),“no search item”)
output: image

Formula 2: if([1_ZoekNaam].IsNotBlank(),Pilot.Filter(upper(naam).find(upper([1_ZoekNaam]))>0).bulletedlist(),“no search item”)
output: image

Formula 3: totext(if([1_ZoekNaam].IsNotBlank(),Pilot.Filter(upper(naam).find(upper([1_ZoekNaam]))>0).bulletedlist(),“no search item”))
output: image

Formula 4: bulletedlist(totext(if([1_ZoekNaam].IsNotBlank(),Pilot.Filter(upper(naam).find(upper([1_ZoekNaam]))>0).list(),“no search item”)))
output: image

I have tried to rewrite the formula many different ways, but I am not getting a bulleted list without the @ symbol. Anyone any ideas?

1_zoeknaam is a named formula on the canvas, where I enter something that can be matched (in this case “joost m”)

2

I think your Formula 2 might be the one to go with here. The @ symbol is popping up because it’s a row reference. If you further define the column, you’ll get just the column value and no @ symbol. Check the [ADD COLUMN HERE] part…

if([1_ZoekNaam].IsNotBlank(),Pilot.Filter(upper(naam).find(upper([1_ZoekNaam]))>0).[ADD COLUMN HERE].bulletedlist(),“no search item”)

3

@BenLee
Thank you - adding the column gave me the desired result - I used the totext() formula at different places for a quick ‘clean-up’ of my output, but I suddenly understand that I was outputting the reference and not the desired data.
I am going to fix this at other places in my document.
Thanks again - until next time…

1 Like