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

    Is there a way to load a printable PDF on the form

    Asked by dweinapple on September 07, 2016 at 10:55 PM
    Is there anyway to load a printable PDF rather than this jpg that isn't
    high enough resolution for printing. Or should I just attach a higher res
    jpg? How can the user print it? There's also a submit button. I'll keep
    looking on your support forum to try to find something useful about this -
    but could still use your help.
    printable pdf
  • Profile Image
    JotForm Support

    Answered by jonathan on September 07, 2016 at 10:59 PM

    Can you please provide more details. Did you meant you want to load the printable PDF after submitting the form?

    Please tell us also the URL of your form you were working this on.

    We will wait for your updated response.

  • Profile Image

    Answered by dweinapple on September 08, 2016 at 01:31 AM
    The URL of the evaluation form is here.    When user hits the submit button on this form, they get this next form that just has one jpg image on it, the certificate.   I used this conditional logic statement:  

    Ideally, when the user hits the submit button, I'd like the to get just a PDF certificate that they can print on an 8.5 x 11 paper.   This form page with a jpg on it doesn't look so great.

    I think we're so close to what we need.   

     

    I'm building a new certificate where we can change out the titles and presenter information.  I am attaching an example of the file I'd like to serve up.

  • Profile Image
    JotForm Support

    Answered by Boris on September 08, 2016 at 02:30 AM

    We cannot see your image of the conditional statement (this link), because it is an image from your private Gmail inbox, but I have cloned your form into my account to take a closer look.

    I see you are evaluating your users on form 62308049099966, and then you want to display an image of a certificate on form 62507352133953 for users to download. It may be easier to set this up a little bit differently.

    Have you considered using a Thank You message for the user for serving their "certificate"?

    https://www.jotform.com/help/211-Setting-Up-the-Thank-You-Page

    The Thank You message can be formatted, and you can directly use the name and any other data your users enter on the form, by simply adding it from the Form Fields button. For example, this is how it would look when setting up the Thank You message:

    You would only need to instruct your users to print that page in order to keep a copy of their certificate. This would not be a PDF certificate, but rather a regular web page, which users should print by using their browser's Print button (or pressing Ctrl + P keyboard combination).

    Please let us know whether this would be a viable solution, or if you are looking for something else instead.

  • Profile Image

    Answered by dweinapple on September 08, 2016 at 02:55 AM

    Oh, yes - the conditional statement I used was this one: 

    It seemed a bit klugey to me, but at least it redirected the user after they press the submit button..   I like your suggestion of using the thank you page, and will try to go further with it.  I was using the change "thank you" page conditional logic thing, but it seems that you're doing something different.  It looks good - I'll try it tomorrow!!  Thank you.

  • Profile Image
    JotForm Support

    Answered by Rose on September 08, 2016 at 03:26 AM

    Thank you for letting us know. 

    Hope, my colleague's suggestion works fine for your situation. However, if  it is not fixed the issue you had even after your try, please let us know. We will do our best to find another way to handle your concern. 


  • Profile Image

    Answered by grade4pagasa on September 08, 2016 at 01:59 PM

    Hi dweinapple

    In case your looking for an alternate solution (though a bit more involved - but offers more functionalities & customization), just breeze through the forum link below.

    *notethere are other methods available but the one i used here are all based on Free Web Apps / Services. if there are users who have an alternative way of achieving the end result, please help out. 

    Hope this helps. 

    - Randy, fellow JotForm user

    Can I have a JotForm that Populate a Certificate?

  • Profile Image

    Answered by dweinapple on September 08, 2016 at 08:34 PM

    I've been using Boris' suggestion about creating the certificate as a jotform text page and using 

    Here's the URL for the overall evaluation form with two dropdown fields showing all the evaluation form titles: the one I've test is Lisa Mitchell in the 9/18/16 dropdown field.  
    Here's the URL for the relevant evaluation.   Here's the URL for the Certificate.     

     

    Two issues:

    1) I need a better way to format the certificate; landscape rather than portrait, and how to add a border (different styles to choose from?)  

    2) Is there a way to populate the title and course instructor on the certificate based on which evaluation was completed?  They are just text now, but could add corresponding form fields?  That way we won't need to make 30 certificates, but can use the one URL.  

    3) Name field.  Can that pre-populate based on the initial form?  That doesn't really matter - we can instruct the user to type their name into the name field.   

     

    If you can help me with these issues, I think we're almost done!

  • Profile Image
    JotForm Support

    Answered by jonathan on September 08, 2016 at 10:15 PM

    If I understand correctly now, the remaining work will be all for this form https://form.jotform.com/dweinapple/certificate-mitchell-091716-15ces only.

    Can you confirm this.

    On the issues:

    #1 

    You can increase the width of the form if you want the print out wider. Actually, the orientation can be controlled within the printer application. There is always option in the printer to print in Portrait or Landscape orientation. 

    #2

    Were you referring to this form https://form.jotform.com/dweinapple/training-evaluation-lisa-mitchell--

     

    You can use a Textbox field for Title and Facilitator field so that you can pre-populate it with details via URL parameter. Can you confirm if those were the fields you refer to.

    #3

    Yes. Similar to #2, fields can be pre-populated with data coming from another form. So this can be done for the Name as well.

     

    We will wait for your response.

  • Profile Image

    Answered by dweinapple on September 09, 2016 at 03:04 AM

    Yes - I am confirming that the remaining work will be done on the certificate.   

    1)  I will try to figure out how to increase the width of the form.  (How?)

    2)  We want to pre-populate the title and facilitator that are found on this form link into the certificate.

    Can you please show me how to use a Textbox field to pre-populate with these data items coming from the link in #2.  Yes, would like for this to be done for the participant name field as well.   Currently, all three of these fields are straight text fields, but I can make them textbox fields.

     

    Thanks - I away your response!

    D

  • Profile Image
    JotForm Support

    Answered by Rose on September 09, 2016 at 04:40 AM

    Thank you for letting us know.

    I will try to answer your question as I can. 

    I'm talking about now the form where the certificate is located ( form ID : 62507352133953). The original width of the form is 690 px. If you want to enlarge width and add a border to the form, please inject below css code to that form. If you want, you can change width value and border color.

    .supernova .form-all, .form-all {
    background-color : #ffffff;
    border : 4px solid #05c;
    width : 750px !important;
    }

    This is the guidance of how to inject above code to your form. 

    https://www.jotform.com/help/117-How-to-Inject-Custom-CSS-Codes


    Regarding your second question about pre-populating fields, I will get back to you in a very short time.

    Thank you for your understanding. 

     

  • Profile Image
    JotForm Support

    Answered by Rose on September 09, 2016 at 05:37 AM

    Thank you for your patience. 

    I tried to understand for a long time to where exactly I needed to populate title and facilitator on the second form. Since, there is only one facilitator on the text box of the first form. Moreover, As I understood; you would like to be autofilled also the field of "Designation and Certification or License #"  and "credentials" fields on the second form where the certificate located. Another thing which confuse me is that there is no name field on the first form but you would like to pre-populate it to second form. 
     

    When considering all of these,  The way I followed here can be just a guidance for you to configure your form.s  I'm going to explain you step by step what I did. 

    First form: the form directs user to certificate
    Second form : the form where certificate is located


    1. Add a "Name Field" to first form

    2. Add two " Dropdown Field"  to the first form


    First drop down is for Credentials. Write its options as you see here 



    Second one is for the Designation field. Write its options as you see here. 



    3. Add a  "Name Field" to the second form. 




    After these changing, you can pre-populates the fields from first form to second form. 

    This is the guidance of how to do it. 

    https://www.jotform.com/help/351-How-to-Automatically-Pass-Form-Data-to-Another-Form


    I can not give you the URL of the pre-populated form due to the fact that I do not know how you will configure it. That' s why, please have a look this guidance firstly.  After making above changing or your configuration and let us know if you are still stuck somewhere or need our further assistance. We would be pleased to help you. 

    Hope, these would solve your issue. 

  • Profile Image

    Answered by dweinapple on September 09, 2016 at 01:30 PM

    Wow. OK - need to go over this.  We need it to pre-populate credentials and license # in the same way..

  • Profile Image

    Answered by dweinapple on September 09, 2016 at 01:45 PM
    Hi Rose,
    Thank you so much for helping me with this. I will try the code soon - I'm
    not so good with programming - I'm kind of a "drag and drop" person, but
    will give it a shot!
    Devora
    ____________________________
    Devora Weinapple, MFT LIC #81558, ATR-BC, MA
    Psychotherapist and Board Certified Art Therapist #12-219
    dweinapplemft.com
    650-485-3019
    President - Northern California Art Therapy Association
    (NorCATA)
    *NorCATA is a chapter of the American Art Therapy Association
    *
    ...
  • Profile Image
    JotForm Support

    Answered by Boris on September 09, 2016 at 03:01 PM

    Sure, if you run into any issues along the way - we are here to help out. Thank you.

  • Profile Image

    Answered by grade4pagasa on September 10, 2016 at 01:19 PM

    Hi Devora

    Could you try filling out this demo form I made and see if it meets your specifications? 

    btw, I only used 1 form for the entire workflow.

    Disclaimer: I'm not a programmer, coder or a designer. 

    You can read the details of the workflow I used in this thread: Can I have a JotForm that Populate a Certificate?

    * Since I couldn't clone your form, I recreated one from scratch.

    ** It's impossible to include page borders (graphics or otherwise) within Google Docs (imposed by Google themselves).
    You can opt download the submissions in Excel and do a Word Mail Merge where you can fully customize the borders.

    Also, in your form, it says 11.5 credits - is this correct (fig. 4 below)?

    - Randy, fellow JotForm user. 

     

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

    Update

    I only saw now that you wanted the certificate in Landscape mode. I just modified the template to be as such so you can try it now.

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

    P.S.

    I'll be doing volunteer work for the next couple of weeks and will be offline for the said duration. 

    The JotForm Support team can handle all of your queries regarding the process I used for this workflow .

    The details of the workflow I used is in this thread: Can I have a JotForm that Populate a Certificate?

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

     

    fig. 1 - for testing purposes, you can just fill out the name, email, credentials, license no., and course to be evaluated. 

     

     

     

    fig. 2 - email (with attached PDF certificate) received automatically once the script is triggered.

     

     

     

    fig. 3 - screenshot of the simply designed certificate (you can use your own layout and replace this)

     

     

    fig. 4 - 11.5 credits? 

     

     

  • Profile Image

    Answered by dweinapple on September 10, 2016 at 05:09 PM

    Hey - I REALLY like this!  And it is very nice aesthetically as well :-)  I especially like that you have them choose a dropdown for the date: 9/17 or 9/18, and the a dropdown for the presenter -along with CEs for that workshop.  That's good!  And the fact that it's the evaluator/user that inputs all the relevant information, but only the name, credentials, course title, presenter, and credits show on the certificate.  Thank you for catching my error - the 11.5 for Schroder - it should be "1.5 CEs".  I owe you a starbucks card for that one!    I'm afraid though that I won't be able to recreate this, is it possible for me to use your code somehow?  Or is it just that I can clone your form (and payment for your time)?   I've forwarded the certificate to Barbara Petterson for her approval.

    There are only a couple of things that I would ask for you to change if you don't mind?

    1) We would like to use Barbara's signature - 

    2) The optional course details would be nice to repeat, but you're right, it's not essential.

    3) Linda Chapman has the Keynote on Saturday, and a 3-hr workshop .  I must have left it out in my form - I fixed that and the Schroder CE error on my original form, and need to do those edits on your form...)

    4) For the thank you page, these are my edits (but a very nice effort!):

    1st paragraph: replace "seminar" with "workshop"
    2nd paragraph: delete
    Last line:  replace "seminar" with "workshop"

    Oops - just re-read that you'll be away for a couple of weeks.   I will clone and try to do these edits myself..  

    THANK YOU!!!

  • Profile Image

    Answered by dweinapple on September 10, 2016 at 05:42 PM

    I've cloned your demo form, but how do I edit the hidden fields?

  • Profile Image

    Answered by grade4pagasa on September 10, 2016 at 05:45 PM

    Hi Devora.

    1.) Replace Barbara's signature - done.

    2.) Optional course details?

    3.) What's the topic of Linda's workshop? And how many credits?

    4.) done, done & done :)  (I added a closing sentence indicating their earned credits - is this ok?)

    I will email you the Google Docs Certificate Template & a copy of the the Integrated Google Sheets so you will know how I configured it.

    By all means, please change the layout / design of the template as I'm not good at designing :)

    I would recommend that you opt to do the Admin Mode - where no triggers (form submit or time intervals) will activate the script and only the designated Form Keeper will have control on the activation / trigger. This is to prevent excited form submitters from sending unnecessary multiple entries (your submissions might get depleted otherwise).

    Thanks for the kind words and YOU'RE WELCOME !

    I will start my volunteer work this afternoon - hopefully I can still help you. Gotta sleep for now. 

    - Randy, fellow JotForm user. 

  • Profile Image

    Answered by dweinapple on September 10, 2016 at 05:51 PM

    Randy, I so appreciate your hanging around long enough to help me finish this!!   The optional course details were the presenter and course listing (a second time), you made a note that maybe it's not needed again. I think it wouldn't hurt to just keep them.  

    I think you did a very nice job with the design - and it's nice to see how you were able to do what you did!

    -> Schroder should have 1.5 CEs, not 11.5 CEs

    -> Linda Chapman - Art Therapy Treatment of Relational Trauma: Rebuilding and Restructuring the Right Hemisphere - 3.0 CEs

     We also need to add an evaluation for Friday, September 16, (an additional drop down with one selection available):

    -> Judith Rubin - Special Reception - 1.0 CEs

    IMPORTANT:  I think I forgot to mention that each of the 30 workshops has a different Educational Goals and Objectives section of the evaluation.  

     

    I would really like to see the hidden fields so I can (later) figure out what you did so I can do it again for our next conferences?

    How do I work in Admin Mode?

    How do I edit the certificate page itself?

     

    Is anyone available to help me complete this project?  Our conference starts 9/16..  I'm getting a little anxious - will try to figure out what he did, and poking through the form that I cloned from the demo link..  Thanks!!!!

  • Profile Image

    Answered by dweinapple on September 11, 2016 at 01:29 AM

    Did you send the email you mentioned you would send that had the Google Docs Certificate Template and Integrated Google Sheets...  I don't see it..

  • Profile Image

    Answered by grade4pagasa on September 11, 2016 at 03:24 AM

    -> Schroder should have 1.5 CEs, not 11.5 CEs
    - corrected

    -> Linda Chapman - Art Therapy Treatment of Relational Trauma: Rebuilding and Restructuring the Right Hemisphere - 3.0 CEs
    - added

     We also need to add an evaluation for Friday, September 16, (an additional drop down with one selection available):
    -> Judith Rubin - Special Reception - 1.0 CEs
    added

    * for all 3 bullet items above, please check the animated gif below or try the updated demo form again.

    I would really like to see the hidden fields so I can (later) figure out what you did so I can do it again for our next conferences?
    - just click the hidden field > click the blue triangle > select show field

    How do I work in Admin Mode?
    - it's just fancy talk for manual mode to prevent auto-processing of all form submissions.
    - watch youtube videos on how to use autoCrat

    How do I edit the certificate page itself?
    Did you send the email you mentioned you would send that had the Google Docs Certificate Template and Integrated Google Sheets...  I don't see it..
    - i will send the link via email after i'm done replying here.

    * For JotForm specific queries, our skilled and helpful support staffs should be able to assist you specially with regards to:

    - dynamic dropdown widget setup,
    - how to extract the values separately from the dropdown output (for the tabular layout display option you mentioned) &
    - hidden fields.

    Sorry for the late response. Been awake for 19 hours and just woke up prepping for the volunteer work. 

    Gotta go now. 

    - Randy 

     

  • Profile Image

    Answered by dweinapple on September 11, 2016 at 03:45 AM

    This is great.   Will go over each step.   Last issue: each of the 30 workshops has a different Educational Goals and Objectives section of the evaluation.   You demo shows one of the 30 evaluations, all of whose data (other than title and facilitator) is the same - except for the objectives.   Can this still all be on one form when each different workshop selected has a different set of objectives? 

    I will look for your email 😊

  • Profile Image

    Answered by dweinapple on September 11, 2016 at 08:24 PM

    The demo form is no longer available..

  • Profile Image
    JotForm Support

    Answered by ashwin_d on September 11, 2016 at 10:52 PM

    Hello dweinapple,

    I did check the demo form and it seems to be still available:  https://form.jotform.me/62525422851453?

    Do try to access it again and get back to us if you have any trouble.

    Thank you!

  • Profile Image

    Answered by dweinapple on September 11, 2016 at 10:56 PM

    Thanks much!   Is there a time limit on this demo?   I may not have time to get to it until tomorrow morning...

  • Profile Image
    JotForm Support

    Answered by ashwin_d on September 12, 2016 at 01:49 AM

    Hello dweinapple,

    No there is no time limit and the form will be available for you to access until it is deleted. If you want you can clone the form in your account and look at it whenever you have time. The following guide should help you how to clone form in your account:  https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL 

    Thank you!

  • Profile Image

    Answered by dweinapple on September 12, 2016 at 02:45 AM
    Thank you- I am familiar with cloning forms - and will do that soon. Wondering if my request about the changing goals and objectives for each workshop is even possible - I haven't heard anything back, but luckily this process is ok to be delayed until a week or so after our conference 9/17-18- so would love to see any solution - I'm hoping m to learn as much as I can - as we will be needing to do this for all workshops and conferences our chapter plans!
    Randy mentioned that others have similar knowledge about this advanced stuff.. Advanced to me anyway! I hope to give back to the forum one day, too.
    ____________________________
    Devora Weinapple, MFT, ATR-BC, MA
    LIC #81558
    Psychotherapist and Board Certified Art Therapist #12-219
    President - Northern California Art Therapy Association(NorCATA)
    NorCATA is a chapter of the American Art Therapy Association

    ...
  • Profile Image

    Answered by grade4pagasa on September 14, 2016 at 12:17 PM

    Hi Devora

    I have limited online access for the next couple of weeks as I'm volunteering. I highly recommend that for your JotForm specific queries, the JotForm Support Team should be able to assist you specially with regards (but not limited) to:

    - dynamic dropdown widget setup, 

    - how to extract the values separately from the dropdown output (for the tabular layout display option you mentioned), 

    - piping field values, 

    - 30 workshops has a different Educational Goals and Objectives section of the evaluation and

    - hidden fields.

    I decided to help you because:

    ~ I noticed that your ticket is still unresolved for 2 weeks (original forum thread was opened on Aug. 25 (figure below) and it was on Sept. 8 that I first read about your challenge and I suggested a referenced link.) 

    ~ I've tried the autoCrat solution and have recommended it to other JotForm users. 

    Trying a new platform like Jotform can be very daunting. Add to that trying to get help and explain a desired end-result (for a considerable amount of time) over a forum and not getting a viable solution you needed can be somewhat frustrating. 

    The solution I shared is from Google Apps (a free 3rd party web service). The Google Sheets add-on autoCrat works perfectly! - that's why I recommended it. But this is outside the scope of support of the JotForm team.

    This is why I took it upon myself to create a working demo to let you see proof of concept and experience the entire process, i.e. I'm here to help with anything that concerns with autoCrat (outside of JotForm support-scope) and for JotForm specific queries, the JotForm Support Team should be able to assist you.

    Hope this clarifies my role in helping you as a fellow JotForm user.

    - Randy

     

     

     

    fig.  - the day ticket was opened

  • Profile Image

    Answered by dweinapple on September 14, 2016 at 12:38 PM

    Thank you Randy!  Since there is no time before our conference for me to work on all the support issues you've helped me with, we've been able to buy some time to try to get it done next week following the conference when the time pressure will be less.  I just wanted to make sure that your demo link was still available for me to clone - and I will have the focus to look at AutoCrat (yes - I do realize its outside of jotform scope).  You've been able to help me with so much already- I think the only thing left - besides really understanding what you've done -is to figure out is how to change the goals and objectives attached to each different presenter.  So there are other alligators and fires I'm needing to deal with up until and throughout the conference, but will be back on this on (probably Sunday night!)   Again, I am sorry to have been so reliant on your help - but I do have my homework to backward engineer your demo.  This is something we will use for all of our workshops and conferences! 

  • Profile Image
    JotForm Support

    Answered by Nik_C on September 14, 2016 at 01:52 PM

    Whenever you're ready to continue, feel free to get back to us.

    We'll be glad to assist you.

    Thank you!

  • Profile Image

    Answered by dweinapple on September 19, 2016 at 11:13 PM

    grade4pagasa has been helping me integrate jotform with AutoCrat to create my certificate.  I am now using AutoCrat to merge my form spreadsheet data into my certificate PDF (template) that has variables associated with my spreadsheet column headers (that should correspond with my form data).  I am now at the step of adding job triggers.  I don't need a time trigger, but do need to run on a form trigger.  How do I create a form trigger?  Since I'm using jot form rather than google forms, is there a way to use the jot form as a "form trigger"? 

     

    From AutoCrat 3.0 Help:A trigger allows an Add-on to run without you having to do anything manually.  For example, AutoCrat allows you to set either a time trigger that will automatically run at a given time interval (say every hour or every 6 hours), or a form trigger that will run automatically every time a user submits a new Google form response (if you have a form attached to your spreadsheet).

  • Profile Image
    JotForm Support

    Answered by Charlie on September 20, 2016 at 01:07 AM

    I'm sorry, but I'm not really that familiar with AutoCrat 3.0, as mentioned by Randy, this is quite out of our scope. But I did check the AutoCrat page to see how it works and it seems like all the setup you have came directly from Randy. I checked the documentation and it says that the form trigger is based on Google form response, so I'm not sure if you can trigger it on JotForm form. But you can try testing it out. The method also provided by Randy seems to involve manual step by an admin where they need to process the responses manually.

  • Profile Image

    Answered by dweinapple on September 20, 2016 at 04:05 PM

    I integrated my cloned form Automated Certificate Workflow with Google Sheets, but when I complete the form, there is no data in the spreadsheet.  Also, no PDF Certificate was emailed to me.   

    Thanks!

    Devora

     

  • Profile Image
    JotForm Support

    Answered by Mike on September 20, 2016 at 06:28 PM

    @Devora,

    Your question about the Google Spreadsheet integration has been moved into a separate thread.

    https://www.jotform.com/answers/937523

    It will be updated shortly.