JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Can I break iContact date fields into day and month?Asked by trakwebster on January 05, 2016 at 06:02 PM
OK, I do have a follow up question.
When I tried to export your Birthday datetime class of field to iContact with an iContact custom date field, the program crashed, but when I changed the iContact custom field to text, then it works.
A date (in jotform) of 4/7/1944 arrives in iContact as "04 07 1944".
In a few months I will want to send emails to people who have certain birthdays.
However, I contact cannot sort by a custom field, and iContact cannot select very well. I can search for "04*" and get all those that start with "04" but that's about it, and the display does not let me break it down any further.
It would be far more useful if I could send them a "birthdayMONTH" field, and then a "birthdayDAY" field, and have these be different custom fields in iContact.
Is there a way to do that?
JotForm Support Manager
I think that possible if you use Text fields, the information would be in different columns in your report though, not sure if that would be feasible and functional for your purposes.
I tried it and it works. Used dropdowns, and specified the choices. For months, used 01 January, 02 February, etc. For days, used 1-31. (Using the pre-defined "months" doesn't play nice.)
On the iContact side, created simple text custom fields.
This enables a field in iContact which will contain precisely what we want for selection purposes, as you know exactly how to match, as the form-user had no ability to format different than the dropdown choices. So in iContact you can select all the "01 January" people, for example.
Because the day of month is in a separate field so as not to interfere with the matching of this selection.
And because we do have both month and day, we can send out emails which have tokens so as to spell out their upcoming birthday.
Works a treat.
Thank you very much for taking the time providing us with such details. We really appreciate it.
And we are glad to know it all work out for you. :)
Don't hesitate to Contact Us anytime for any assistance you need.