Does anyone know the correct valueformat to use when trying to get custom data to display as the label rather than the value?
customDataAsLabel = shows value
val = shows value
html = shows blank
I tried valuefield= and valueexpression= with and without the CONCAT. Who wants to be my hero today? :{)
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Views
Replies
Total Likes
Hey Doug... just the person I was hoping to summon! Unfortunately, that too displays the value and not the label of the parameter option.
displayname=Product
linkedname=direct
namekey=Mktg - Taxonomy - Product
querysort=DE:Mktg - Taxonomy - Product
textmode=true
valuefield=Mktg - Taxonomy - Product
valueformat=customDataValuesAsString
I tried this as an expression as well with the same result. I could do IF statements, but there are about 50 options and I would much prefer the system to just show me the answer that is already there!!
Views
Replies
Total Likes
Harrumph. Guess that doesn't work anymore @BrandonNW .
But this does:
displayname=valueexpression as HTML
namekey=Mktg - Taxonomy - Product
querysort=DE:Mktg - Taxonomy - Product
textmode=true
valueexpression={DE:Mktg - Taxonomy - Product}
valueformat=HTML
Regards,
Doug
Views
Replies
Total Likes
As Doug mentions you have to change it to a valueexpression instead of valuefield and it will display the values instead of the labels.
Views
Replies
Total Likes
Oh my goodness. That didn't work either, but I think I just realized why. The field I am pulling is a calculated field with a large concatenated formula. Since the calc field pulls the values in by default, I am guessing that textmode can only interpret that data and not the original field's labels. Would that be a correct assumption?
Views
Replies
Total Likes
Going on the theory that it was b/c of the calc fields, but now I am thinking maybe we got a bug or something b/c this works:
displayname=LOB
linkedname=direct
namekey=Mktg - Taxonomy - NF - LOB
querysort=DE:Mktg - Taxonomy - NF - LOB
textmode=true
valuefield=Mktg - Taxonomy - NF - LOB
valueformat=customDataLabelsAsString
But this does not:
displayname=LOB
linkedname=direct
namekey=Mktg - Taxonomy - NF - LOB
querysort=DE:Mktg - Taxonomy - NF - LOB
textmode=true
valueexpression=CONCAT({DE:Mktg - Taxonomy - NF - LOB},{DE:Mktg - Taxonomy - PC - LOB})
valueformat=HTML
Am I missing something stupid??
Views
Replies
Total Likes
Hi @BrandonNW,
Possibly...I'd suggest you check what is returned when you try each of the (minimal) following, then compare that to what you want to be returned in the CONCAT you mentioned.
displayname=NF - LOB
textmode=true
valueexpression={DE:Mktg - Taxonomy - NF - LOB}
valueformat=HTML
displayname=PC - LOB
textmode=true
valueexpression={DE:Mktg - Taxonomy - PC - LOB}
valueformat=HTML
Regards,
Doug
Views
Replies
Total Likes
These bring back the same results as the CONCAT (value instead of label). Booo. I think I will submit a ticket b/c there has to be way to get the label.
Thank you sincerely for troubleshooting with me!
Views
Replies
Total Likes
Views
Likes
Replies