Skip to main content

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?

I just need Ashlyn,Johnston

 

Hi @ashlynjohnston13 

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

 


@ashlynjohnston13 

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.

 


 


@ashlynjohnston13 

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 @ashlynjohnston13,

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:

  • Bring this to the attention of the integration developers
  • Help track and prioritize fixes
  • Allows us to notify you via email if/when this is fixed

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!


Reply