Hi,
I’m wondering if anyone has come across a similar problem and found a solution…
I’m looking for a way to validate form data so that only certain information can pass through. For example, in a text area field, I want to make sure that only numeric numbers (1,2,3,4, etc.) can pass through and text does not. In this scenario, a dropdown with only numeric options is not possible as the number range is very, very large.
To add some context, we have forms linked to Google Sheets as part of one of our tracking initiatives with our franchisees. When they don’t follow instructions and submit text instead of numbers it breaks the sync we have with our business intelligence platform.
Aside from creating default text within the field (which is ignored) and further instructions on the form itself (which is ignored) I’m not sure what other options are left.
Any and all help is appreciated.
Thanks
Hi there, Amy from ActiveCampaign’s Customer Experience Team. We’re just refreshing our forum page and I wanted to add some help here for anyone who comes across this page/question/post.
As our native forms don’t yet have the ability to identify ‘valid’ contact data such as email addresses etc, it would be wise to set up double opt-in. This will ensure that contacts who complete your form are essentially ‘valid’. You could then use the start trigger ‘submits a form’ and a wait step to say 'wait until contact is subscribed to list (confirms double opt in) > once they confirm they can pass to the Google Sheet step within your automation.
However this still doesn’t validate that the details input are ‘valid’ so this is just s slight workaround.
You could also incorporate if/else statements to filter out those invalid submissions from a valid submission such as ‘field is not blank’ > if a contact doesn’t complete the field then they will flow down the ‘no’ path and can avoid being added to the list too (if they complete the form + double opt-in).
Any questions or additional ideas, thread them below!