Long email notification, bottom portion is deleted occasionally

  • catherinec
    Asked on August 29, 2014 at 9:52 AM

    I have created a form for my company to use as an online version of our paper application. It is VERY long. While the form side of it is fine, the email notification side, which I painstakingly formatted to match our paper application, loses the last sixth or so of its contents sometimes.

    At first I thought that it was a product of our recently spotty internet connection, but after the third time it disappeared at the same spot in the same day, I figured that it must be related to JotForm in some way.

    Is there a limit to the size of the email notifications? Or is there something else that I'm missing?

    The part of my email notification that keeps disappearing is thankfully the least complicated part, but it won't do me any good to continually replace it if the submissions I receive are missing it anyway.

    My form is at http://form.jotform.us/form/42316072200135

    Thanks to anyone that can help me out!!

  • David JotForm Support
    Replied on August 29, 2014 at 1:07 PM

    Hi,

    I am trying to test the form but due to the length of the email notification I am having a hard time narrowing down exactly which part is missing.  For each submission I make, the notification looks the same though with the bottom part looking as such:

    Long email notification, bottom portion is deleted occasionally Image 1 Screenshot 20

    I dont not believe there is a limit to the length of email notifications.  Let us know a bit more about which fields specifically are not showing up and we will be happy to test this more.

  • catherinec
    Replied on August 29, 2014 at 1:19 PM

    Thank you for looking into it!

    Apparently, it's done it again while I was away on lunch. Immediately after the part that says:

    REQUESTED BY:

    L & B Transport, LLC  Safety Department
    (Name of Company) (Type Name)
    708 Highway 190 W Safety
    (Address) (Title)
    Port Allen, LA 70767 __________________________
    (City)

     (Signature)

    There should be the following, but it keeps disappearing:

    PREVIOUS PRE-EMPLOYMENT EMPLOYEE ALCOHOL AND DRUG TEST STATEMENT

     

    Sec. 40.25(j) As the employer, you must also ask the employee whether he or she has tested positive, or refused to test, on any pre-employment drug or alcohol test administered by an employer to which the employee applied for, but did not obtain, safety-sensitive transportation work covered by DOT agency drug and alcohol testing rules during the past two years. If the employee admits that he or she had a positive test or a refusal to test, you must not use the employee to perform safety-sensitive functions for you, until and unless the employee documents successful completion of the return-to-duty process. (see Sec. 40.25(b)(5) and (e))

     

    Prospective Employee Name: {applicantName}

    The prospective employee is required by Sec. 40.25(j) to respond to the following questions.

    1.) Have you tested positive, or refused to test, on any pre-employment drug or alcohol test administered by an employer to which you applied for, but did not obtain, safety-sensitive transportation work covered by DOT agency drug and alcohol testing rules during the past two years?

     {haveYou220}

    2.) If you answered yes, can you provide/obtain proof that you've successfully completed the DOT return-to-duty requirements?

     {ifYou}

    I certify that the information provided on this document is true and correct.

    Prospective Employee Signature: {signature223}

    Date: {date224}

    Witnessed By: ____________________________

    Date: _________________  

     

     

     

    MANDATORY USE FOR ALL ACCOUNT HOLDERS

    IMPORTANT NOTICE
    REGARDING BACKGROUND REPORTS FROM THE PSP Online Service

    1. In connection with your application for employment with L&B Transport, LLC ("Prospective Employer"), Prospective Employer, its employees, agents or contractors may obtain one or more reports regarding your driving, and safety inspection history from the Federal Motor Carrier Safety Administration (FMCSA).

    When the application for employment is submitted in person, if the Prospective Employer uses any information it obtains from FMCSA in a decision to not hire you or to make any other adverse employment decision regarding you, the Prospective Employer will provide you with a copy of the report upon which its decision was based and a written summary of your rights under the Fair Credit Reporting Act before taking any final adverse action. If any final adverse action is taken against you based upon your driving history or safety report, the Prospective Employer will notify you that the action has been taken and that the action was based in part or in whole on this report.

    When the application for employment is submitted by mail, telephone, computer, or other similar means, if the Prospective Employer uses any information it obtains from FMCSA in a decision to not hire you or to make any other adverse employment decision regarding you, the Prospective Employer must provide you within three business days of taking adverse action oral, written or electronic notification: that adverse action has been taken based in whole or in part on information obtained from FMCSA; the name, address, and the toll free telephone number of FMCSA; that the FMCSA did not make the decision to take the adverse action and is unable to provide you the specific reasons why the adverse action was taken; and that you may, upon providing proper identification, request a free copy of the report and may dispute with the FMCSA the accuracy or completeness of any information or report. If you request a copy of a driver record from the Prospective Employer who procured the report, then, within 3 business days of receiving your request, together with proper identification, the Prospective Employer must send or provide to you a copy of your report and a summary of your rights under the Fair Credit Reporting Act.

    The Prospective Employer cannot obtain background reports from FMCSA unless you consent in writing.

    If you agree that the Prospective Employer may obtain such background reports, please read the following and sign below:

    2. I authorize L&B Transport, LLC ("Prospective Employer") to access the FMCSA Pre-Employment Screening Program (PSP) system to seek information regarding my commercial driving safety record and information regarding my safety inspection history. I understand that I am consenting to the release of safety performance information including crash data from the previous five (5) years and inspection history from the previous three (3) years. I understand and acknowledge that this release of information may assist the Prospective Employer to make a determination regarding my suitability as an employee.

    3. I further understand that neither the Prospective Employer nor the FMCSA contractor supplying the crash and safety information has the capability to correct any safety data that appears to be incorrect. I understand I may challenge the accuracy of the data by submitting a request to https://dataqs.fmcsa.dot.gov. If I am challenging crash or inspection information reported by a State, FMCSA cannot change or correct this data. I understand my request will be forwarded by the DataQs system to the appropriate State for adjudication.

    4. Please note: Any crash or inspection in which you were involved will display on your PSP report. Since the PSP report does not report, or assign, or imply fault, it will include all Commercial Motor Vehicle (CMV) crashes where you were a driver or co-driver and where those crashes were reported to FMCSA, regardless of fault. Similarly, all inspections, with or without violations, appear on the PSP report. State citations associated with FMCSR violations that have been adjudicated by a court of law will also appear, and remain, on a PSP report.

    - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

    I have read the above Notice Regarding Background Reports provided to me by Prospective Employer and I understand that if I sign this consent form, Prospective Employer may obtain a report of my crash and inspection history. I hereby authorize Prospective Employer and its employees, authorized agents, and/or affiliates to obtain the information authorized above.

    Date: {date229}  Signature: {signature228} 

     Name: {applicantName}

     

     

    Hiring Standards

    1. All persons considered for a chemical tank driver must be a minimum of 25 years of age, hold a Class A CDL with an X endorsement and a valid TWIC card, "unless approved otherwise by Safety Director". Applicant must have at least 3 years of verifiable driving experience, including 1 year recent tank experience; if applying for flatbed only, you must have 1 year verifiable experience, have no more than 2 moving violations, or a combination of either moving violations and accidents in the last 3 years for which the driver was at fault. Any preventable accident listed or verified will need a copy of the police report template to verify accuracy. If the accident was the result of a speeding ticket it will be treated as one. Applicant must not have been involved in a DUI or a refusal of any sobriety test in the last 5 years. L&B reserves the right to accept or reject any applicant based on the severity and any disclosed or undisclosed information about any accident either mentioned or not mentioned on the application.

    2. The application will be reviewed by the Safety Department to ascertain the criteria are met and will be followed up with an MVR to check his/her driving history before proceeding further.

    3. If the applicant appears qualified by past employment history, the application will be turned over to Louis Vielee or Blain Houston for final approval.

    4. Upon determination that the applicant is qualified for employment with TMI/L&B, he/she will be required to obtain mandatory drug test and DOT physical if one is not valid.

    5. Upon receiving satisfactory results form the above test requirements and work history, the individual will be given the opportunity to complete the computer based training and attend an orientation class where the results must be satisfactory.

    6. Applicant will be required to read and familiarize himself with the company policy handbook/safety manual and is to verify this with signature below.

    7. Applicant is required to sign below that he has read and fully understands sections 383.51 and 383.53 in the Federal Motor Carrier Safety Regulation Handbook and agrees to become familiar with the company policies and procedures.

    Applicant Signature: {signature233}  Date: {date234}

     

    Remove before Printing:

    Link to Online Version: {edit_link}

    Link to Data PDF: {pdf-link}

     

     

    I had just replaced it this morning when I started working on it. But it would seem that it is no longer there. Again.

  • David JotForm Support
    Replied on August 29, 2014 at 2:41 PM

    Thank you for clarifying this.  It does indeed appear as though your notification is being cut short.  I could not find anything stating that there is a limit to the length of email notifications but I sent a bug ticket to our development team to see if they are able to give you a bit more information.  We will update you here as soon as we have a resolution.

  • Steve VP of Sales Operations
    Replied on August 29, 2014 at 11:25 PM

    Hello Catherine-

    We have been alerted to this issue before. A table in our database is limited to 21,844 characters, as noted in this comment:

    http://www.jotform.com/answers/396113#399977

    The workaround is to include the PDF link in the email, and then check the Show Headers & Texts option in the submission settings. See the link above for details. We do apologize for the inconvenience. Please let us know if you have further questions.

    Kind Regards

  • admin752
    Replied on June 15, 2015 at 9:22 PM

    I find myself in a very similair position as this user. The workaround of a PDF link is not viable as the email notificaiton is in html and not a direct duplicate of the form being filled in. Is it possible to double the database limit? I am at a loss as to where to go from here. I have been working on this form for days and have now hit a brick wall. Please help. Is it possible to extend this database limit to allow long documents to be emailed as Notifications?

     

    Mick