I’m just creating a zap that will pull data from Active Campaign and send to Zoho Analytics. Basically, once a university student fills out this form, they are added to the contact list for University Enquirers. From there I want to pull specific custom fields (see screenshot below) and add a new row to Zoho Analytics.
The issue we are having is that there are no custom fields for university, instead a tag gets added depending on which form they filled out. We can’t make it a custom field as each university has their own form with their own colours and branding, so instead it becomes a tag.
This tag gets added along with other tags so what I tried doing was using text formatter and the “Split Text” option.
Which is working fine, however it appears with [Enquirer] QUT at the start and I just want it to appear with the university name, and without the [Enquirer] part. So, I used a second text formatter below the first one to replace [Enquirer] with nothing.
When I test the zap it appears correct, however when I actually fill out the form to test it, the university field doesn’t get populated in Zoho Analytics.
I was wondering if anyone had any suggestions on how I can do this better to get the result I need.
If you have any questions or need me to explain something to get a better understanding, please let me know.
I appreciate any help.