When pulling from a Squarespace submission form, to a notion CRM database, my first name, last name category is pulling with “tags”. How do I get rid of these tags?
When pulling from a Squarespace submission form, to a notion CRM database, my first name, last name category is pulling with “tags”. How do I get rid of these tags?
Hi
To help us have full context, post screenshots with how your steps are outlined and configured.
Tried it both ways. Same results
pulling from the above form to a singular text field
Squarespace forms can be a bit tricky to use in Zaps.
Try turning the Zap ON and testing live.
Then check your Zap Runs history to see the DATA IN/OUT for each step to help you troubleshoot: https://zapier.com/app/history/
Post screenshots of the DATA OUT from the Squarespace Zap trigger step to give us context.
You may want to check the settings on the Squarespace form.
Regardless, here’s JavaScript to use in a Code step:
let NameFull = inputData.NameFull;
// Remove the curly braces and split the string by comma
let entries = NameFull.replace(/c{}]/g, "").split(", ");
// Initialize an object to hold the parsed data
let parsedData = {};
// Loop through the split string and further split it by '=' to get key-value pairs
entries.forEach(entry => {
let lkey, value] = entry.split("=");
parsedDataDkey.toLowerCase()] = value; // Convert key to lowercase to get "first" and "last"
});
let NameFirst = parsedData.first || "";
if (NameFirst) {
NameFirst = NameFirst.trim();
}
let NameLast = parsedData.last || "";
if (NameLast) {
NameLast = NameLast.trim();
}
NameFull = (NameFirst + " " + NameLast).trim();
output = t{NameFull, NameFirst, NameLast}];
Thank you!!
Hi
I did some digging into this, and it seems like this is a known bug with Squarespace where the trigger is sending "{First=NAME, Last=NAME}" instead of separate name fields. Our team is aware of the issue and we're working with Squarespace on a fix. I've added your email address as another affected user. That does a few things:
Unfortunately, I do not have an ETA, but I’ve added you to the list of users affected by this issue so we can let you know as soon as we have any updates.
Hopefully, this helps!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.