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

    Data de validade na planilha de Importação em Excel

    Asked by horvathalexandre on November 12, 2016 at 09:03 PM

    Boa noite, tenho o seguinte formulário com vocês https://form.jotformz.com/62527383527663

     

    Ele é um formulário para recebimento de currículos, no qual a resposta que é enviado ao candidato é que o currículo dele ficara conosco durante 120 dias.

     

    Pois bem, quando vou na página de recebimento de formulários, verifiquei que posso fazer um download de todos as informações que eles preencheram, como data e horário.

     

    Minha pergunta é possível colocar um prazo de validade nesse formulário indicando por exemplo quando vencerá esse período de 120 dias que é u meu caso?

     

    Pois quando faço a importação em Excel tenho que ficar fazendo alterações na planilha para saber quando vencerá esse período, e como todo dia tem novos currículos, tenho que sempre refazer esse procedimento.

     

    Aguardo retorno, obrigado.

     

    Alexandre Horvath

    Page URL:
    https://form.jotformz.com/62527383527663

    excel NA href jotformz a
  • Profile Image
    JotForm Support

    Answered by ashwin_d on November 13, 2016 at 07:17 AM

    Hello Alexandre,

    If I understand your requirement correctly, you want to display the expiration date of resume which is 120 days from the date of submission. Is that correct?

    Yes it is possible to achieve your requirement by adding a date field in form and set the default data to be 120 days form current date. You can also hide this date field so that your users cannot see this date. Please check the screenshot below which should help you:

     

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • Profile Image

    Answered by horvathalexandre on November 13, 2016 at 01:44 PM

    Good afternoon, unfortunately did not understand how to do, until I added the date field, but do not know how to do this association dates, could send me other screens, thanks!
    Alexandre Horvath
    alexandrehorvath@outlook.com
    De: JotForm [mailto:noreply@jotform.com]
    Enviada em: domingo, 13 de novembro de 2016 10:18
    Para: alexandrehorvath@outlook.com
    Assunto: Re: Data de validade na planilha de Importação em Excel
    A new response has been received:
    [JOTFORM]
    Answered by ashwin_d
    Hello Alexandre,
    If I understand your requirement correctly, you want to display the expiration date of resume which is 120 days from the date of submission. Is that correct?
    Yes it is possible to achieve your requirement by adding a date field in form and set the default data to be 120 days form current date. You can also hide this date field so that your users cannot see this date. Please check the screenshot below which should help you:
    [https://www.jotform.com/uploads/forum/ashwin_d/1479039319dateAdd.gif]
    Hope this helps.
    Do get back to us if you have any questions.
    Thank you!
    View this thread on browser » Unsubscribe Thread
    1479039473
    ...
  • Profile Image
    JotForm Support

    Answered by KadeJM on November 13, 2016 at 04:06 PM

    My colleague sent you a screenshot via his last response to show you how to set up the expiration.

    Were you not able to view it?

    If so then I've reuploaded it for you to try to view again below:

    If you still confused or need more help then please let us know where you're stuck at so that we may assist you furthermore.

     

  • Profile Image

    Answered by horvathalexandre on November 13, 2016 at 06:44 PM
    My friend, thank you, now it worked.
    Just one last doubt is possible to place this deadline for the files already listed there or not?
    Alexandre Horvath
    alexandrehorvath@outlook.com
    De: JotForm [mailto:noreply@jotform.com]
    Enviada em: domingo, 13 de novembro de 2016 19:06
    Para: alexandrehorvath@outlook.com
    Assunto: Re: Data de validade na planilha de Importação em Excel
    A new response has been received:
    [JOTFORM]
    Answered by KadeJM
    My colleague sent you a screenshot via his last response to show you how to set up the expiration.
    Were you not able to view it?
    If so then I've reuploaded it for you to try to view again below:
    [https://shots.jotform.com/kade/screenshots/1479039319dateAdd.gif]
    If you still confused or need more help then please let us know where you're stuck at so that we may assist you furthermore.
    View this thread on browser » Unsubscribe Thread
    1479071178
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on November 13, 2016 at 09:27 PM

    On behalf of my colleagues, you are most welcome. To place the deadline in the previous submissions that were already listed, you will need to edit the submissions and resubmit them. Please follow this guide on How to Edit Submissions Made on Your Forms.

    If you need further assistance, please let us know.
    Regards.

  • Profile Image

    Answered by horvathalexandre on November 14, 2016 at 07:44 AM

    Good morning, thank you for the feedback. Last question, this deadline is only for my internal control, right? The answer of the form will not disappear after that date, right?
    Alexandre Horvath
    alexandrehorvath@outlook.com
    ________________________________
    De: JotForm
    Enviado: segunda-feira, 14 de novembro de 2016 00:27
    Para: alexandrehorvath@outlook.com
    Assunto: Re: Data de validade na planilha de Importao em Excel
    A new response has been received:
    [JOTFORM]/www.jotform.com>
    [https://www.jotform.com/resources/assets/icon/jotform-icon-dark-400x400.png]
    Online Form Builder JotForm
    www.jotform.com
    If you need online forms for generating leads, distributing surveys, collecting payments and more, JotForm is for you. Learn more about how we can help.
    Answered by Chriistian
    On behalf of my colleagues, you are most welcome. To place the deadline in the previous submissions that were already listed, you will need to edit the forms and resubmit them. Please follow this guide on How to Edit Submissions Made on Your Forms.
    If you need further assistance, please let us know.
    Regards.
    View this thread on browser Unsubscribe Thread
    1479090471
    ...
  • Profile Image
    JotForm Support

    Answered by Chriistian on November 14, 2016 at 07:56 AM

    Hi there,

    To answer your question, no, your form submissions will not disappear. The expiration dates are just data in your submissions.

    Regards.