Form Submissions: Ability to track the dates when a submission has been edited.

  • Profile Image
    marcellobrazil
    Asked on October 19, 2017 at 02:24 PM

    I created 3 kind of users. I wanna check what date/time they send the form. Maybe I will need a field for each one but I dont know where I can get this info

    THANKS FOR YOUR HELP

  • Profile Image
    John_Benson
    Answered on October 19, 2017 at 04:04 PM

    Can you please provide more details of what you're trying to achieve?

    To my understanding, you have 3 kinds of users. 

    User 1: 

    User 2: 

    User 3: 

    Are they going to edit one submission?

    You can enable the Send on Edit of the notification email. You can track the time and date whenever you receive the notification email of the edited submission.

    1508443432notifcas.png

    You can also add a hidden Date/Time field on your form and set it to "Current Date/Time". See image below:

    1508443415notifcas11.png

    1508443465notifcas112.png




  • Profile Image
    marcellobrazil
    Answered on October 19, 2017 at 04:10 PM

    https://form.jotformz.com/71225598854669

    I did everthing you said. But this didnt solve 100%

    I need this


    Fornecedor envia form Compras recebe e envia form no dia 10/10/17 as 14h “Data/Hora compras” salva o tempo copiando do campo padrão Mkt recebe e envia form no dia 10/10/17 as 16h “Data/Hora mkt” salva o tempo copiando o campo padrão, o qual atualiza automaticamente para 10/10/17 as 12h Celula recebe e envia form no dia 11/10/17 as 9h “Data/Hora mkt” salva o tempo copiando o campo padrão, o qual atualiza automaticamente para 11/10/17 as 9h
  • Profile Image
    BDAVID
    Answered on October 19, 2017 at 07:17 PM

    Basically, you want to keep the original submission date?

    What you can do is to pass the date field value to another date field, which should have a NONE default date, through conditions: https://www.jotform.com/help/268-How-to-Insert-Text-or-Mathematical-Calculation-into-a-Field-Using-a-Condition 

    1508454930defaultdatenone.png

    First you would need to add the Get Form Page URL widget: 

    05-07-2017-1494158325.png

    Then, create a condition like this:

    1508454960condition.png

    Let us know if you have more questions, we will be glad to assist you.

  • Profile Image
    marcellobrazil
    Answered on October 20, 2017 at 07:54 AM

    "Basically, you want to keep the original submission date?"

    I wanna to keep the date/time when Fornecedor submit the form.
    Also, I wanna to keep the date/time when Compras submit the form.
    Also, the same thing for Marketing and Celula.
    https://form.jotformz.com/71225598854669

     

  • Profile Image
    John_Benson
    Answered on October 20, 2017 at 11:18 AM

    Unfortunately, this is not possible on the Edit Submission feature. Once you edited the form data, the Submission will be updated as well. It means that when you update the Name and the Date/Time then the previous submission data will be replaced with a new one.

    You're correct, you will need a separate field for each user to track it properly.

    Related guide: A-General-Approach-on-Building-an-Approval-Process-Workflow 

    I hope this information helps.

  • Profile Image
    marcellobrazil
    Answered on October 20, 2017 at 11:37 AM

    I really need to record the date/time. Are you sure it is impossible to do that?

    When I download the answers in the Excel it has this information. Maybe a field that record each part of the form it is the answer.

    Or something if the calculate condition. Can I stop the calculation? For example I copy the field Date today and tomorrow its stops to copying.

  • Profile Image
    BDAVID
    Answered on October 20, 2017 at 12:30 PM

    What you are trying to accomplish is complex, the only option would be adding a Date field for each department, and having the user to manually input the date and time when submitting the form.

  • Profile Image
    marcellobrazil
    Answered on October 20, 2017 at 12:43 PM

    This need to be automatically. I need a field that record the date/time when you send the form, is it complex? I have no ideia, sorry if I were rude with "is it complex?"

  • Profile Image
    BDAVID
    Answered on October 20, 2017 at 01:05 PM

    We really want to help you, however, our date time submission feature updates each time the form gets re-submitted through the edit link. And we do not have a specific feature that automatically records the "date and time" each time a submission gets re-submitted.

  • Profile Image
    marcellobrazil
    Answered on October 20, 2017 at 01:21 PM

    is it hard to create date/time for Edit Link Submission? Or to have a condition to active a field?

  • Profile Image
    John_Benson
    Answered on October 20, 2017 at 01:57 PM

    Let me try to create a workaround for this issue. I will contact you again on this thread once I am done with the demo form.

    Thank you. 

  • Profile Image
    marcellobrazil
    Answered on October 20, 2017 at 02:02 PM

    NICE! THANKS FOR YOUR HELP!! I will be waiting

  • Profile Image
    John_Benson
    Answered on October 21, 2017 at 05:22 PM

    Sorry for the delay.

    Here's the demo form (Workaround)https://form.jotform.com/72924640728967

    To test the demo form, please clone it by following this guide: https://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL

    In the demo form, I added the Configurable List widget to record the edit logs. Here's a screen animation sample:

    1508620596teazrzggza.gif

    Here's the final submission looks like:

    1508620906teapzma1.png

    To view your submission page, please follow this guide: https://www.jotform.com/help/269-How-to-View-Form-Submissions

    Let us know if you have any questions or need further assistance. Thank you.

  • Profile Image
    marcellobrazil
    Answered on October 23, 2017 at 08:32 AM

    But for that the user needs to fill the field, I need it to be automatically

  • Profile Image
    Kevin_G
    Answered on October 23, 2017 at 11:39 AM

    Unfortunately, it's not possible to automatically fill the Configurable List widget (used on my colleague's example). 

    Also, please note that the data is saved when the submit button is changed, so far there is not  way to have a date picker or another field to automatically change its value (which would help yo know the last edit date). 

    Currently, you will need to use the workaround provided by my colleague and ask your users to fill the last edit logs, JotForm does not save the submissions edit logs either. 


  • Profile Image
    marcellobrazil
    Answered on October 23, 2017 at 11:59 AM

    Can you talk with the developers if it is hard to create this field? I think for some people it is important to record the date and time when the form was submit (even in Edit Link) 

  • Profile Image
    Kevin_G
    Answered on October 23, 2017 at 01:20 PM

    I will forward this to our second level as feature request, although we cannot provide an ETA, we will let you know as soon as we receive any updates about it. 


  • Profile Image
    marcellobrazil
    Answered on October 24, 2017 at 09:20 AM

    nice, thanks!

  • Profile Image
    marcellobrazil
    Answered on October 30, 2017 at 09:48 AM

    any news?

  • Profile Image
    John_Benson
    Answered on October 30, 2017 at 10:54 AM

    We still do not have an update to our developers regarding on this issue. We will contact you again on this thread once we have any updates.

    Thank you.