how can I print labels from submissions

  • Profile Image
    ATPHNB
    Asked on February 03, 2017 at 07:26 PM

    I would like to set up a report or something so that the person reviewing the submissions can click and print out a mailing label (yes, a mailing label for the post office) on a local printer. We get one or two catalog requests every day and have to send them out right away. Downloading and importing the data in to the database that does this now takes longer than typing it in.

     

    Any info

     

    Keith 

  • Profile Image
    liyam
    Answered on February 04, 2017 at 01:38 AM

    Hello Keith,

    I'm not sure this method can be done, but can you give us more information on this? Are the maling labels coming from the submissions data? 

    I also noticed that you mentioned about downloading and importing data into the database takes longer than typing it in, can you tell us your existing process? Perhaps there is a shorter method on doing this if you are manually downloading and importing information to your database. Perhaps using Webhooks which you can set to submit a copy of the submissions via back-end or Post data submission which you can point your thank you page and let the thank you page handle the importation automatically can remove that middle-process of manually importing data for you.

     

  • Profile Image
    ATPHNB
    Answered on February 07, 2017 at 12:14 PM

    Yes the data for printed labels is coming from the form submissions. We download an excel spread sheet and add it to our databases when we do an email blast or do mass mailings every month. However, when a customer completes a form requesting a catalog or a brochure on a product – usually one or two per day – we need to mail one out as soon as possible. Right now a staff person get’s the email from JotForm, sit’s down at a computer, and types in the name address etc. in to a standalone Microsoft Access database that has the Avery brand label form templates set up and prints one or two addresses. (We plan to get a new dedicated label printer from Dymo who has been making them for decdes http://www.dymo.com/en-US.)

    The staff person doing this task daily in most companies is an administrative person not familiar with importing database files, mapping fields etc. – And it’s a laborious effort for just one or two names. They typically just type it in from the email and print.

    What we want to be able to print directly to a label printer of a popular make like avery, or have the ability to format an output page perhaps in a PDF so we can print ourselves.

    JotForm is probably large enough a company to connect with Dymo like others have as seen on the link below.

    http://www.dymo.com/en-US/dymo-labeling-needs/mailing-shipping-labeling/mailing-shipping-labeling/labelwriter-450-label-printer

    I will look at those links you sent.

  • Profile Image
    david
    Answered on February 07, 2017 at 01:36 PM

    If you need to use your own templates that are populated from an access database, the only thing I can thing of would be to set up a script to populate your database:

    https://www.jotform.com/answers/714822-how-to-connect-the-form-to-my-MS-Access-database

    Other than that you can create a shipping label on one of your notifications.

    Simply edit the body of the notification to look the way your label should look like.

    Once there is a submission, you will get two e-mails:

    1 - Normal submission

    2 - Mailing label 

    Here is a sample of the second label:

     

    On that notification, not all the fields will be included, but only those needed for a mailing label.

    You can then simply print out the mailing label from the email. 

    Here's a quick test form to show you how it would work:

    https://form.jotform.com/63325049397967

    This would not work if you need to retain your current process.