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

  • horvathalexandre
    Asked on November 12, 2016 at 9: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

  • Ashwin JotForm Support
    Replied on November 13, 2016 at 7: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:

    Data de validade na planilha de Importação em Excel Image 1 Screenshot 20

     

    Hope this helps.

    Do get back to us if you have any questions.

    Thank you!

  • horvathalexandre
    Replied on November 13, 2016 at 1: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
    ...
  • KadeJM
    Replied on November 13, 2016 at 4: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:

    Data de validade na planilha de Importação em Excel Image 1 Screenshot 20

    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.

     

  • horvathalexandre
    Replied on November 13, 2016 at 6: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
    ...
  • Chriistian Jotform Support
    Replied on November 13, 2016 at 9: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.

  • horvathalexandre
    Replied on November 14, 2016 at 7: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
    ...
  • Chriistian Jotform Support
    Replied on November 14, 2016 at 7: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.