Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Circular Reference - can someone help with this?

Topic Labels: Automations
110 0
cancel
Showing results for 
Search instead for 
Did you mean: 

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

0 Replies 0