Submission Date - Update on edit

  • Profile Image
    DatatelCommunications
    Asked on February 07, 2018 at 06:51 PM

    Hi JotForm,

    I would like to request a feature or widget which updates to tell us the last submitted date on a form. The submission date field only updates on the first submission. 

    Are you able to fix that so it updates on edited submissions too? If not please provide a solution to this problem.


    Thank You

  • Profile Image
    BDAVID
    Answered on February 07, 2018 at 09:59 PM

    The submission date column keeps the date when the form was originally submitted. If you want to have a date that updates each time the submission is submitted in edit mode, you can add a date field which you can hide, and setup to be automatically updated with the current date:

    1518058428date.png

  • Profile Image
    DatatelCommunications
    Answered on February 07, 2018 at 10:12 PM

    Hi,

    This does not work if you have the setting [Clear hidden Fields on submit] enabled.

    I need a better solution than this as we need the other hidden fields on the form cleared

  • Profile Image
    BDAVID
    Answered on February 07, 2018 at 10:50 PM

    The "Clear hidden fields on submit" setting works on fields that are hidden through conditions only, the ones hidden from their properties will not be affected.

  • Profile Image
    DatatelCommunications
    Answered on February 07, 2018 at 10:57 PM

    Great thanks for your help.

    Could you please help with another question I have regarding the autocomplete widget.

    We currently have hundreds or forms and most of them use our autocomplete fields. All of them need to be updated manually when a single new name is added or removed from our contacts. This is usually a 3+ hrs job each time. 

    Is there a way we can populate autocomplete fields options using an API or linking it to a central JotForm list etc? 

    This is extremely important for us.

    Thank You

  • Profile Image
    Jim_R
    Answered on February 08, 2018 at 03:09 AM

    I'm glad you're all set on this one. Your last question was moved to a separate thread to avoid confusion:

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

    I'll reply to you there shortly.

  • Profile Image
    DatatelCommunications
    Answered on February 11, 2018 at 08:37 PM

    Hi Guys,

    I tested this and it does not work. 

    When you go to edit a submission: https://www.jotform.com/edit/{{SUBMISSION ID HERE}}

    Then you will notice that the date field attempts to fill in the [Current] date but then fails to do so and prefills the last value. 
    I assume this is because its prefilling the previous form entry into the field. 

    Please advise.

    Thank You

  • Profile Image
    BJoanna
    Answered on February 12, 2018 at 04:27 AM

    I made several tests and this will not work because the date was already entered when the submission was submitted. 

    I will raise a feature request to our developers to see if the submission date can be updated when the submission is edited or if the new column can be added to the submission page that will capture the date of the last edit. However, please note that we can not provide you the exact time when and this will be implemented.

    For now, I can only suggest you to add a date field to your form and disable the past and future dates. The field should also require. In this case, when the submission is edited there will be an error message shown inside of the field and the user that is editing the submission will have to select the today's date. 

    How to Use the Date Limits Option

  • Profile Image
    DatatelCommunications
    Answered on February 12, 2018 at 06:59 PM

    Thanks. This is a high priority request for us. I know this is a big issue for many other JotForm users as well.