How to pre-fill form field based on previous entry records?

  • ADMwebsite
    Asked on August 17, 2018 at 1:27 PM

    Hi,


    Haow can I pre-fill a form field based on previous recorded field.

    e.g  form field is "Equipe N°"

    Last entry "Equipe N°" field has n°20 as value and I want to pre-fill form with "21" when displaying new input screen ?  Can I access databse records to get theses data to be used for new entries ? 

  • Kiran Support Team Lead
    Replied on August 17, 2018 at 2:32 PM

    I am not sure if I understand your query correctly. Do you mean to add an increment number to one of your fields? If so, please check the Unique ID widget with autoincrements for each submissions. Please refer to the guide below that can help you with this.

    https://www.jotform.com/help/79-How-to-Add-Custom-Unique-IDs-to-your-Form-Submissions

    Hope this information helps! Let us know if you are referring something different. We will be happy to help. 

  • ADMwebsite
    Replied on August 17, 2018 at 2:56 PM

    Thanks Kiran, 


    I will check this option and feedback.

  • ADMwebsite
    Replied on August 18, 2018 at 3:37 AM

    Hi Kiran, 

    The uniqueID widget seems to fit my needs to increment entries, however, I can't succeed using this field data to build a subsequent field in my database using any kind of rules ( copy field or calculate field ) in the form !  Any hint ?

    1534577767Image 1 Screenshot 10

    does not copy anything ! 

    Does it mean that uniqueID is a kind of protected field ?  

  • ADMwebsite
    Replied on August 18, 2018 at 3:59 AM

    OK, I have found the solution using the widget "Submissions Counter" instead wich makes it 100%.

    Thanks

  • Kiran Support Team Lead
    Replied on August 18, 2018 at 7:58 AM

    Great! Glad to see that the submissions counter widget works for you. The unique ID widget generates the number only after submitting the form and the field data cannot be displayed on the form.

    Please get back to us if you need any further assistance. We will be happy to help.