What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

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.

  • Profile Image

    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?

  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on January 05, 2016 at 09:56 PM

    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.

  • Profile Image

    Answered by trakwebster on January 05, 2016 at 10:53 PM

    Yup, Jeanette.

    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.


  • Profile Image
    JotForm Support

    Answered by jonathan on January 06, 2016 at 05:49 AM

    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.