Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am needing help with an ongoing issue.
I am pulling a field where the result is the ID being pulled rather than the text, and if multiple have been selected at the input stage it becomes concatted.
I need to change these ID's back to text, I was hoping to use the replace( but getting a little confused here.
Dimension: =IF(contract_field_title = 'Please specify which currency' and answerLatest = 'Yes', contract_field_answer_value)
Current Result: 182,184
Desired Result: GBP,USD
Where multiple fields have that title we are using the following expression:
=concat(distinct(IF(contract_field_title = 'Please specify which currency' and answerLatest = 'Yes', contract_field_answer_value)), ',')
Current Result: 182,134,242
Desired Result: GBP,USD,AUD
How would I achieve this?
Hello Steve,
The problem is we have a load script which is templated across a number of different sites and client data within. We want to steer away from having custom load scripts for sites and have one 'template' if you like so we have to do these in the front end.
But yes, for now it is working using the long method i have mentioned, thanks for your help.