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

    [Zapier Integration] Submission data is received as N/A values

    Asked by Meredith Randolph  on December 23, 2015 at 12:55 PM

    We are running an integration where JotForms data is pulled into Zapier, and Zapier places a file in DropBox. For some reason, the data being fed from JotForms to Zapier is not correct. Zapier has ran issue logs and believes it is being sent wrong.  

    Here is what Zapier said:

    Thanks for sending those over! It looks like the values we're getting from JotForm are N/A if you look in the Data Out area here (https://zapier.com/app/history/50663dab-7b26-4bc0-8665-077c24001119), so the disconnect seems to be on their end as what their API is providing to us. We don't show any errors on our side that would prevent this information being pulled. Can you double check in the fields you've mapped within your Zap, and that they are carrying that value over appropriately?

    And here's what Jot Forms sends vs what Zapier receives:

    Data from JotForm:

    · Submission Date

    2015-12-23 09:54:04

    · START TERM

    May

    · START YEAR

    2017

    · APPLICANT TYPE

    NEW

    · LAST NAME

    Shuklin

    · FIRST NAME

    Eugene

    · PREFERRED NAME

    Test Application

    · MIDDLE NAME

    middle name

    · DATE OF BIRTH

    image001.png@01D13D69.CA4DECE0Saturday, December 23, 2000

    · GENDER

    MALE

    · ETHNICITY

    White/Caucasian

    · CITIZENSHIP

    USA

    · PERMANENT RESIDENT OF THE U.S.

    YES

    · PERMANENT STREET ADDRESS

    123 Main St

    · CITY

    Fairfax

    · STATE

    VA

    · POSTAL CODE

    20120

    · COUNTRY

    USA

    · PERMANENT E-MAIL

    eugene.shuklin@powerobjects.com

    · MOBILE PHONE

    5712435503

    · Select Yes to receive Admission-related alerts via text to your mobile phone #

    NO

    · HOME PHONE

    1231234567

    · SKYPE ID

    skypeidfiels

    · BEST WAY TO CONTACT YOU

    E-mail

    · PRIMARY COLLEGE

    Nova

    · DEGREE MONTH

    January

    · DEGREE YEAR

    2015

    · DEGREE

    BS

    · MAJOR

    BIOLOGY

    · CUMULATIVE GPA

    4

    · COLLEGE 2

    college2

    · COLLEGE 2 MAJOR

    college2 major

    · COLLEGE 2 DEGREE EARNED

    BA

    · COLLEGE 3

    college3

    · COLLEGE 3 MAJOR

    college3major

    · COLLEGE 3 DEGREE

    BSN

    · COLLEGE 4

    college4

    · COLLEGE 4 MAJOR

    college4major

    · COLLEGE 4 DEGREE

    OTHER

    · Have you satisfied the required pre-requisites for Trinity School of Medicine?

    o Yes

    · NATIVE LANGUAGE

    ENGLISH

    · AAMC ID (8 DIGITS)

    12345678

    · MCAT SCORE VERIFICATION CODE (16 DIGITS)

    1234567890123456

    · TEST DATE BEFORE APRIL 2015

    image001.png@01D13D69.CA4DECE0Wednesday, December 09, 2015

    · VERBAL REASONING

    20

    · PHYSICAL SCIENCES

    21

    · BIOLOGICAL SCIENCES

    22

    · TOTAL SCORE - BEFORE APRIL 2015

    63

    · TEST DATE AFTER APRIL 2015

    image001.png@01D13D69.CA4DECE0Wednesday, December 16, 2015

    · CHEM & PHYS FOUNDATIONS

    11

    · CRITICAL ANALYSIS & REASONING

    21

    · BIO & BIOCHEM FOUNDATIONS

    3

    · PSYCH, SOC, BIO FOUNDATIONS

    4

    · TOTAL SCORE - AFTER APRIL 2015

    39

    · 1st POSITION

    work exp position 1

    · 1st EMPLOYER

    powerobjects

    · 1st EMPLOYER ADDRESS AND PHONE NUMBER

    employee address

    · DATES OF 1st EMPLOYMENT: START

    image001.png@01D13D69.CA4DECE0Tuesday, December 01, 2015

    · DATES OF 1st EMPLOYMENT: END

    image001.png@01D13D69.CA4DECE0Wednesday, December 23, 2015

    · MED/CLINICAL EXPERIENCE

    medical exp large statement

    · EXTRA-CURRICULAR ACTIVITIES

    extra curricular activities statement

    · COMMUNITY AND/OR MILITARY SERVICE

    military service

    · RESEARCH AND/OR PUBLICATIONS

    research and publication fields

    · NAME OF COMMITTEE CHAIR and/or PRE-HEALTH ADVISOR

    Letter Recommendation

    · NAME OF SCHOOL

    Nova

    · NAME AND RELATIONSHIP - 1st REFERENCE

    relationship name

    · E-MAIL - 1st REFERENCE

    email@email.com

    · PERSONAL STATEMENT

    personal statement field

    · HAVE YOU APPLIED TO TRINITY SCHOOL OF MEDICINE PREVIOUSLY?

    NO

    · HAVE YOU ATTENDED MEDICAL SCHOOL IN THE PAST?

    NO

    · HAVE YOU EVER WITHDRAWN FROM MEDICAL SCHOOL?

    NO

    · HAVE YOU EVER BEEN CONVICTED OF OR CHARGED WITH ANY VIOLATION OF THE LAW (FELONY OR MISDEMEANOR)?

    NO

    · HAVE YOU EVER BEEN DISCIPLINED BY ANY LICENSING OR CREDENTIALING BOARD?

    NO

    · HAVE YOU EVER BEEN DISCPLINED BY ANY INSTITUTION OF HIGHER EDUCATION FOR VIOLATION OF INSTITUTIONAL RULES AND REGULATIONS GOVERNING STUDENT BEHAVIOR?

    NO

    · How did you first learn about Trinity School of Medicine?

    o E-mail from the School

    · Check here.

    o true

    · FULL NAME

    Eugene Shuklin

    · DATE

    image001.png@01D13D69.CA4DECE0Wednesday, December 23, 2015




    What Zapier got:

    fields__CITIZENSHIP:

    N/A

    fields__PREFERRED NAME:

    Test Application

    fields__IF YES, USE THIS SPACE TO PROVIDE DETAILS AND THE CURRENT STATUS OF YOUR INSTITUTION CASE.:

    N/A

    fields__COLLEGE 4 MAJOR:

    college4major

    fields__MIDDLE NAME:

    N/A

    fields__COLLEGE 2 MAJOR:

    college2 major

    fields__ACKNOWLEDGEMENT :

    N/A

    fields__COURSES REQUIRED FOR ADMISSION:To satisfy the Trinity School of Medicine pre-requisites for admission you must provide an un-official transcript to confirm completion. Official transcripts are required prior to matriculation. A list of required pre-requisites can be found on our website under Admissions Requirements. :

    N/A

    fields__EXTRA-CURRICULAR ACTIVITIESIn this section please list extracurricular and/or community activities in which you were involved in during or after college. List the type of experience, organization name, dates you were involved and total hours along with a description of the experience. List any leadership roles and/or accomplishments related to these activities. :

    N/A

    fields__PERSONAL STATEMENTIn 300-1500 words please provide your personal statement. Utilize this as an opportunity to distinguish yourself from other applicants. You may want to include challenges or hardships that have impacted your educational pursuits. Other considerations such as motivations for entering the medical field and why you feel you will be an asset to the healthcare profession may be included. :

    N/A

    fields__COLLEGE 4 DEGREE:

    N/A

    fields__BIO & BIOCHEM FOUNDATIONS:

    3

    fields__START TERM:

    N/A

    fields__APPLICANT TYPE:

    N/A

    fields__RESEARCH AND/OR PUBLICATIONSIn this section please list research activities and publications you were involved in during or after college. List the type of experience, organization name, dates you were involved and total hours along with a description of the experience. :

    N/A

    fields__NAME AND RELATIONSHIP - 1st REFERENCE:

    N/A

    fields__TEST DATE BEFORE APRIL 2015:

    N/A

    fields__DATES OF 1st EMPLOYMENT: END:

    N/A

    fields__IF YOU WERE DISMISSED OR WITHDREW, PLEASE LIST THE REASONS FOR THIS ACTION.:

    N/A

    fields__ENGLISH PROFICIENCY REQUIREMENTS: If English is your native or primary language, skip to the Medical College Admissions Test section below. Applicants whose native language is not English must demonstrate an established level of English language proficiency through the Internet Based Test (iBT) of the Test of English as a Foreign Language (TOEFL) or the academic format of the International English Language Testing System (IELTS). The test must have been taken within the two years of the first term of enrollment. If your native language is not English and you have taken either of these tests, please be prepared to produce your scores. An official report of your scores must be sent directly to the Office of Admissions from the testing agency before an admissions decision can be made. :

    N/A

    fields__By checking this box and entering my name and today"s date in the spaces below, I certify that the information submitted by me on this application is complete and accurate. I understand that withholding requested information or giving false information may make me ineligible for admission, cause me to be dismissed from Trinity School of Medicine or have my degree rescinded, if application. If I accept an offer of admission from Trinity School of medicine, I understand that I am subject to the rules, regulations and policies of Trinity School of Medicine as they now exist or as they may be modified in the future, and I understand that the rules, regulations and policies of Trinity School of Medicine are subject to change without notice. :

    N/A

    fields__MED/CLINICAL EXPERIENCE:

    N/A

    fields__NAME OF COMMITTEE CHAIR and/or PRE-HEALTH ADVISOR:

    N/A

    status:

    ACTIVE

    fields__MEANINGFUL EXPERIENCE(S)In this section you have the opportunity to highlight any work experience, community service, volunteer activities, extracurricular activities, awards, honors, or publications that you would like to bring to the attention of the Admissions Committee.:

    N/A

    fields__COLLEGE 3 DEGREE:

    N/A

    fields__COLLEGE 3 MAJOR:

    college3major

    fields__PHYSICAL SCIENCES:

    21

    fields__Application for Admission:

    N/A

    fields__DEGREE:

    N/A

    fields__OTHER DISCIPLINARY ACTIONS :

    N/A

    fields__DATE OF BIRTH:

    N/A

    fields__DEGREE YEAR:

    2015

    fields__ACADEMIC INFORMATION :

    N/A

    fields__Select Yes to receive Admission-related alerts via text to your mobile phone #:

    N/A

    fields__HAVE YOU EVER WITHDRAWN FROM MEDICAL SCHOOL?:

    NO

    fields__PRIMARY COLLEGE:

    N/A

    fields__CUMULATIVE GPA:

    4

    new:

    1

    fields__TOTAL SCORE - AFTER APRIL 2015:

    39

    fields__Application Fee Payment Provided:

    N/A

    fields__COLLEGE 3:

    N/A

    fields__COLLEGE 2:

    N/A

    fields__VIOLATIONS OF LAW :

    N/A

    fields__COLLEGE 4:

    N/A

    fields__IDENTIFYING INFORMATION :

    N/A

    fields__ 1st EMPLOYER ADDRESS AND PHONE NUMBER:

    N/A

    fields__TEST DATE AFTER APRIL 2015:

    N/A

    fields__DEGREE MONTH:

    January

    fields__2nd EMPLOYER:

    N/A

    fields__VERBAL REASONING:

    20

    fields__WORK EXPERIENCE(S)In this section you have the opportunity to highlight any work experience you have had. Include full time, part time or summer employment while a college/university level student or after.:

    N/A

    fields__COMMUNITY AND/OR MILITARY SERVICEIn this section please list extracurricular and/or community activities in which you were involved in during or after college. List the type of experience, organization name, dates you were involved and total hours along with a description of the experience. List any leadership roles and/or accomplishments related to these activities. :

    N/A

    fields__CHEM & PHYS FOUNDATIONS:

    11

    fields__DATES OF 1st EMPLOYMENT: START:

    N/A

    fields__PERSONAL STATEMENT:

    N/A

    fields__IF YES, USE THIS SPACE TO PROVIDE DETAILS AND YOUR CURRENT STATUS.:

    N/A

    fields__ETHNICITY:

    N/A

    fields__Please attach a copy of your transcript(s) with your application to expedite the review process. Unofficial or student copies are acceptable to initiate the review of your file.:

    N/A

    fields__LAST NAME:

    N/A

    fields__HAVE YOU EVER BEEN DISMISSED FROM MEDICAL SCHOOL:

    N/A

    fields__GENDER:

    N/A

    fields__LETTERS OF RECOMMENDATIONWhen using a committee letter or recommendation from your schools pre-health professions advisory committee, please provide the name of the committee chair person and the name of the institution that will provide the committee letter in support of your application for admission. :

    N/A

    fields__CRITICAL ANALYSIS & REASONING:

    21

    fields__MAJOR:

    BIOLOGY

    fields__IF YOU ARE RE-APPLYING, WHAT HAVE YOU DONE TO STRENGTHEN YOUR APPLICATION?:

    N/A

    fields__BIOLOGICAL SCIENCES:

    22

    fields__FIRST NAME:

    N/A

    fields__PERMANENT E-MAIL:

    N/A

    fields__HEALTHCARE EXPERIENCE (PHYSICIAN SHADOWING, EMPLOYMENT, VOLUNTEER)Please list the type of experience, organization name, dates you were involved and total hours along with a description of the experience. :

    N/A

    fields__TOTAL SCORE - BEFORE APRIL 2015:

    63

    fields__DATES OF 2nd EMPLOYMENT: END:

    N/A

    fields__PERMANENT RESIDENT OF THE U.S.:

    N/A

    form_id:

    51684025828965

    fields__SKYPE ID:

    N/A

    fields__PERMANENT STREET ADDRESS:

    N/A

    fields__Submitting your form will take you to the PayPal transaction window to submit your Application fee.:

    {"product":["Application Fee (Amount: 0.00 USD)"],"currency":"USD","total":"0.00","coupon":"VET2016"}

    fields__START YEAR:

    N/A

    flag:

    0

    fields__MOBILE PHONE:

    5712435503

    fields__2nd EMPLOYER ADDRESS AND PHONE NUMBER:

    N/A

    fields__HAVE YOU EVER BEEN CONVICTED OF OR CHARGED WITH ANY VIOLATION OF THE LAW (FELONY OR MISDEMEANOR)?:

    N/A

    fields__NAME AND RELATIONSHIP - 2nd REFERENCE:

    N/A

    fields__NATIVE LANGUAGE:

    N/A

    fields__MCAT SCORE VERIFICATION CODEEach examinee is assigned a verification code when they create an official MCAT score report. To access the verification code, you must choose the option to "create and print my own official score report." The report includes a verification code that we will use to confirm your scores. Please note that verification codes are only valid for 90 days. Services are available through the online Testing History (THx) Report System and are free. You may also request that AAMC release your scores to Trinity School of Medicine via the same link. :

    N/A

    fields__2nd POSITION:

    N/A

    fields__1st POSITION:

    N/A

    fields__SUPPORTING MATERIALS :

    N/A

    fields__CITY:

    N/A

    fields__PLEASE LIST THE NAME OF YOUR PREVIOUS MEDICAL SCHOOL:

    N/A

    fields__AWARENESS OF TRINITY SCHOOL OF MEDICINE :

    N/A

    fields__MEDICAL COLLEGE ADMISSIONS TEST (MCAT)Please list your MCAT scores by section below. If you have taken the MCAT more than once, list your highest total score (from a single exam). The student score report for the MCAT contains a 16 digit verification code, enter it along with your 8 digit AAMC ID to have your scores verified by the Office of Admissions. :

    N/A

    created_at:

    2015-12-23 09:54:04

    fields__ List all institutions you have attended or are currently attending. Begin with the most recent school attended and list in reverse chronological order. You must have an official transcript sent to the Office of Admissions from each college and university you have attended. :

    N/A

    fields__Have you satisfied the required pre-requisites for Trinity School of Medicine? :

    Yes

    ip:

    71.163.80.87

    fields__FULL NAME:

    N/A

    fields__PRIOR APPLICATION OR ENROLLMENT IN MEDICAL SCHOOL :

    N/A

    id:

    326691646780923114

    fields__ If your college or university does not have a pre-health professions advisory committee, please list the names of two persons who will provide letters of evaluation/recommendation in support of your application for admission. One of these persons must be an instructor or professor who has taught you. The second letter should be from a physician, if possible. :

    N/A

    fields__COMMUNITY AND/OR MILITARY SERVICE:

    military service

    fields__MCAT SCORE VERIFICATION CODE (16 DIGITS):

    N/A

    fields__1st EMPLOYER:

    N/A

    fields__HAVE YOU APPLIED TO TRINITY SCHOOL OF MEDICINE PREVIOUSLY?:

    N/A

    fields__BEST WAY TO CONTACT YOU:

    N/A

    fields__How did you first learn about Trinity School of Medicine?:

    E-mail from the School

    fields__DATES OF 2nd EMPLOYMENT: START:

    N/A

    fields__HAVE YOU ATTENDED MEDICAL SCHOOL IN THE PAST?:

    N/A

    fields__HAVE YOU EVER BEEN DISCPLINED BY ANY INSTITUTION OF HIGHER EDUCATION FOR VIOLATION OF INSTITUTIONAL RULES AND REGULATIONS GOVERNING STUDENT BEHAVIOR?:

    N/A

    fields__IF YES ABOVE, WHEN?:

    N/A

    fields__PLEASE LIST YOUR ATTENDANCE END DATE:

    N/A

    fields__HOME PHONE:

    N/A

    fields__IF YOU HAVE ATTENDED MEDICAL SCHOOL, PLEASE LIST YOUR ATTENDANCE START DATE:

    N/A

    fields__E-MAIL - 1st REFERENCE:

    email@email.com

    fields__EXTRA-CURRICULAR ACTIVITIES:

    N/A

    fields__POSTAL CODE:

    N/A

    fields__COUNTRY:

    N/A

    fields__HAVE YOU EVER BEEN DISCIPLINED BY ANY LICENSING OR CREDENTIALING BOARD?:

    N/A

    fields__Submit:

    N/A

    fields__STATE:

    N/A

    fields__AAMC ID (8 DIGITS):

    N/A

    fields__RESEARCH AND/OR PUBLICATIONS:

    research and publication fields

    fields__PSYCH, SOC, BIO FOUNDATIONS:

    4

    fields__NAME OF SCHOOL:

    N/A

    fields__IF YES, USE THIS SPACE TO PROVIDE DETAILS AND THE CURRENT STATUS OF YOUR CASE. :

    N/A

    fields__COLLEGE 2 DEGREE EARNED:

    N/A

    fields__DATE:

    N/A

    fields__Check here.:

    N/A

    Fields with no value:

    fields__If Other please indicate source

    fields__E-MAIL - 2nd REFERENCE

    updated_at

    fields__If Student or Alumni referral please list name.


    zapper submission data
  • Profile Image
    JotForm Support

    Answered by Mike on December 23, 2015 at 01:27 PM

    Thank you for contacting us.

    Can you please provide us with a form link in question?

    Are you referring to N/A values as incorrect data?

  • Profile Image

    Answered by Meredith Randolph  on December 23, 2015 at 01:45 PM
    Oh, sorry! I thought I pasted the URL.
    https://form.jotform.com/51684025828965
    And yes, the N/A as incorrect data.
    Meredith Randolph | Project Director | Office: 612.339.3355 x176
    PowerObjects, an HCL Company
    ...
  • Profile Image
    JotForm Support

    Answered by Mike on December 23, 2015 at 02:13 PM

    Thank you for provided information.

    A bug report ticket has been attached to this thread and forwarded to our Development Team. We will let you know when we have any updates on this.

    Can you please confirm if the issue is still affecting your new form entries?

  • Profile Image

    Answered by Meredith Randolph  on December 23, 2015 at 02:45 PM
    Yes, it is. I just submitted a new one under my name and the same thing happened.
    Meredith Randolph | Project Director | Office: 612.339.3355 x176
    PowerObjects, an HCL Company
    ...
  • Profile Image

    Answered by victor on December 23, 2015 at 03:28 PM

    Sorry for this inconvenience. As my colleague indicated, he already opened a ticket for our back end team to review this issue. As soon as we have any update on the progress you will be informed through this thread.

  • Profile Image

    Answered by Meredith Randolph  on December 29, 2015 at 11:47 AM
    Do we have an update on this? I haven’t heard back since Wednesday, and this needs to be resolved ASAP.
    Meredith Randolph | Project Director | Office: 612.339.3355 x176
    PowerObjects, an HCL Company
    ...
  • Profile Image
    JotForm Support

    Answered by Mike on December 29, 2015 at 02:02 PM

    The issue is somehow related to that specific Adobe FormsCentral migrated form. I have removed migration layout elements, and also switched Date fields from lite to normal mode.

    It seems to be fixed the problem on my side. Please inspect your next form submission to see if it is delivered correctly.

  • Profile Image
    JotForm Support

    Answered by NeilVicente on June 03, 2016 at 08:28 AM

    Hi Meredith,

    Sorry for the late notice, but I just wanted to check in. Are you still having such issues with your form?