Passing Name fields to AirTable and MailChimp

  • Profile Image
    teamhigher
    Asked on May 23, 2019 at 08:47 AM

    I want to integrate a form with both MailChimp and AirTable. However, MailChimp only works with the JotForm FullName field (first and last as sublabels) and AirTable only works with First and Last created as individual Text fields.

    Is there a way to collect first and last names that will work with both integrations?

    I tried putting in both types then hiding the Full Name field and tried to set up a condition to pass First and Last text fields content to FullName field but that doesn't seem to work either.

  • Profile Image
    BDAVID
    Answered on May 23, 2019 at 10:57 AM

    Unfortunately, it is not possible pass just the first or last name field into separate fields. What you could do is to use custom fields in Mailchimp, so you can match each individually.

    Let us know if you need more help.

  • Profile Image
    teamhigher
    Answered on May 23, 2019 at 03:17 PM

    Conversely, if I want to keep FullName field is there a way to map the 2 sublabels to 2 separate fields in AirTable? or am I limited to putting the full name into one field?

  • Profile Image
    BDAVID
    Answered on May 23, 2019 at 04:35 PM

    I have tested the Airtable, and you can add a Single Line Text field type:

    1558643598singlelinetext.png

    Match in with the Full Name field of your form:

    1558643673airtable.png

    And it will be sent both first and last name to that field:

    1558643714table.png

    Let us know if you need more help.

  • Profile Image
    teamhigher
    Answered on May 23, 2019 at 06:00 PM

    Thanks, I understand that and that is my workaround. However, it would be better to have separate First and Last Name columns in Airtable, but there doesn't seem to be a way to pass the  FullName form field into  2 columns in Airtable unless I use two separate text fields for first and last name on the form and then it won't work with Mailchimp and I'm reluctant to start messing with the Mailchimp list fields.

  • Profile Image
    jherwin
    Answered on May 23, 2019 at 08:34 PM

    You can add two short text entry field for first and last name and then one short text entry field to combine the first and last name.
    1558657949firstname.png

    Full Name - this field is hidden.

    Conditional Logic:
    1558657980insertname.png

    Demo form: https://form.jotform.com/91427918723969

    Please try to clone the form and integrate it with Airtable and MailChimp.

  • Profile Image
    teamhigher
    Answered on May 24, 2019 at 07:13 AM

     Unfortunately that combines First and Last into First Name in mailchimp

    1558696178Screen Shot 2019-05-24 at 7.00

  • Profile Image
    Richie_P
    Answered on May 24, 2019 at 09:03 AM

    To clarify, do you want to separate the first name and last name in the MailChimp Integration Or do you want to combine?

    You can map two text fields for First name and last name in MailChimp Integration.

    Just edit the the merge tag in your MailChimp Integration.

    Sample Screenshot:

    Hope this information helps.


  • Profile Image
    teamhigher
    Answered on June 03, 2019 at 10:59 AM

    What I'd like to be able to do is use one short text entry for the First Name and another short text entry for Last Name.

    But when I try to integrate to mailchimp the only option I on the mailchimp side is: Full Name

    1559573751Screen Shot 2019-06-03 at 10.5


    This is how my merge fields look in MailChimp but I don't know how to change it so that they show up separately when integrating from JotForm.

    Also if I make changes to the merge tags in MailChimp will it mess things up in my existing list?

    1559573838Screen Shot 2019-06-03 at 10.5

    Thanks

  • Profile Image
    BDAVID
    Answered on June 03, 2019 at 12:37 PM

    Please try adding new fields in your Mailchimp list:
    1559579569newfields.png

    Then remove the Mailchimp integration, and integrate again, the new fields should be displayed, example:

    1559579727showup.png

    Let us know if you need more help.