I have a form called Join Us in SquareSpace. This form has the option turned on for ‘email sign up:
So I want to set it up so that when the user, checks off the sign up box that it will trigger my filter zap and add them to the email octopus subscriber list. I have been trying to set this up, but the field is not showing up on the Zapier side:
I can see the email field, but there is no indicator of that checkbox field. I see that in there is this information regarding the field on Chrome Inspector:
and the only field that is really questionable I see in the Form Submission steps is called ID
However, I am stuck on how to set this trigger up correctly. It was passing through, but when I would test it out nothing was adding to my EmailOctopus subscriber list after I published this.
Best answer by Suhlest92
I would like to firstly express, how refreshing it is to actually see a response on a question in a forum like this. Of the many tools I’ve used over the years, it feels seldom that I find a supportive community.
For that I would like to respond because after a little investigating earlier this afternoon I figured it out! And I hope that this can help developers in the future who may be using EmailOctopus for a client using SquareSpace.
Challenge:
form fields exist, but the checkbox for the email signup consent functionality on SquareSpace does not pull as it’s own field (above) you’ll see in the SquareSpace page editor on this form, you have an option for the email signup checkbox.
The test function in Zapier doesn’t actually check that box (above) the test function is filling out the form’s required fields but the opt-in subscription checkbox is not part of the default test functionality.
Solution Found:
First, I did the live Live Zap run, much like was mentioned by @Troy Tessalone and @Sparsh from Automation Jinn. (However I did a lot of try/fail because I did this before the response came in)
On the live zap run, I used my personal email as a test form submission in SquareSpace but I set up an initial Trigger Action, to Filter by Zapier for the email field boolean to be true. In my test submission, I of course checked the sign up for news and updates box, and this is what returned as an email value! (above) please notice that additional string (text) has been appending to the field value and reads ‘, accepts marketing:true’.
So now I figured out that the checkbox response was not reacting as it’s own respective field as mentioned by @AndrewJDavison, but instead was appending to the email field value. A quirk of SquareSpace, I suppose. With this new found knowledge, the tests were passing through up until this trigger hit because now the email field value was no longer a valid email.
The next step, was to split the value.
Using the Formatter by Zapier to Transform: Split Text by Commas and Kept the Email (for Squarespace Forms's "Email" field) using the ‘First’ Segment.
Running the test, it returned just the email and not the appended text!
The last thing I needed to do was replace the field value with the previous output.
So I used another Formatter by Zapier and Transform: Replace the Email input Value by Finding the Email input Value, and replacing it with the previous step’s output!
Now, the submission data was able to successfully pass the triggers and move to Add/Update Contact on EmailOctopus!
(above) here is the full Zap Map that shows the actions used to move submissions into the contact list that accept news/marketing!
Alright, I know this was lengthy, but I hope this can save someone a headache, or some time when setting this up in the future. I am new to EmailOctopus but this was a great learning process since this is actually my first ever time using Zapier too.
Because the response from the community in this forum was met with timely support response, I wanted to return that respect with what I’ve learned to be a contributor of that sentiment.
Probably try adding a custom field for email signup to solve your issue as Zapier may not be getting checked or unchecked state from Squarespace by default. After that you can use a live zap run as a test trigger. Hope it helps!
I would like to firstly express, how refreshing it is to actually see a response on a question in a forum like this. Of the many tools I’ve used over the years, it feels seldom that I find a supportive community.
For that I would like to respond because after a little investigating earlier this afternoon I figured it out! And I hope that this can help developers in the future who may be using EmailOctopus for a client using SquareSpace.
Challenge:
form fields exist, but the checkbox for the email signup consent functionality on SquareSpace does not pull as it’s own field (above) you’ll see in the SquareSpace page editor on this form, you have an option for the email signup checkbox.
The test function in Zapier doesn’t actually check that box (above) the test function is filling out the form’s required fields but the opt-in subscription checkbox is not part of the default test functionality.
Solution Found:
First, I did the live Live Zap run, much like was mentioned by @Troy Tessalone and @Sparsh from Automation Jinn. (However I did a lot of try/fail because I did this before the response came in)
On the live zap run, I used my personal email as a test form submission in SquareSpace but I set up an initial Trigger Action, to Filter by Zapier for the email field boolean to be true. In my test submission, I of course checked the sign up for news and updates box, and this is what returned as an email value! (above) please notice that additional string (text) has been appending to the field value and reads ‘, accepts marketing:true’.
So now I figured out that the checkbox response was not reacting as it’s own respective field as mentioned by @AndrewJDavison, but instead was appending to the email field value. A quirk of SquareSpace, I suppose. With this new found knowledge, the tests were passing through up until this trigger hit because now the email field value was no longer a valid email.
The next step, was to split the value.
Using the Formatter by Zapier to Transform: Split Text by Commas and Kept the Email (for Squarespace Forms's "Email" field) using the ‘First’ Segment.
Running the test, it returned just the email and not the appended text!
The last thing I needed to do was replace the field value with the previous output.
So I used another Formatter by Zapier and Transform: Replace the Email input Value by Finding the Email input Value, and replacing it with the previous step’s output!
Now, the submission data was able to successfully pass the triggers and move to Add/Update Contact on EmailOctopus!
(above) here is the full Zap Map that shows the actions used to move submissions into the contact list that accept news/marketing!
Alright, I know this was lengthy, but I hope this can save someone a headache, or some time when setting this up in the future. I am new to EmailOctopus but this was a great learning process since this is actually my first ever time using Zapier too.
Because the response from the community in this forum was met with timely support response, I wanted to return that respect with what I’ve learned to be a contributor of that sentiment.
Wow, awesome work here @Suhlest92! 🙌 I’m so pleased you were able to get it solved and thank you so much for taking the time to share such a detailed explanation to help others in the community. We really appreciate it! 🤗
And a big thank you @Troy Tessalone, @Sparsh from Automation Jinn and @AndrewJDavison for helping to get this solved. Love to see the community working together like this! 🧡
