Hello,
I have pulled and seperated a sting of data on a new tab and would like the Primary Field to include some of the seperated data.
I keep getting the circular error message. I’m struggling to see why this is happening but would love to know is there a work around?
The string contains:
Cost Name–Staff Name–Description of Services
and as been seperated into different columns:
{Cost Name} {Staff Name} {Description of Services}
I would like the Primary Record to contain:
CONCATENATE(datetimeformat({Date},‘YYYY-MM-DD’)," “,{Staff Name},” ",{Cost Name})
For whatever reason, I can add the full string but not the seperated information.
Thanks
