In form building, how can I auto populate data in a table?

  • alshana
    Asked on April 16, 2025 at 5:54 PM

    I'm trying to create a more efficient travel authorization process, and I'm stuck on how to accomplish auto-populating per diem in a table based on the employee's input dates. Can you please help?

  • Christian Ice Jotform Support
    Replied on April 16, 2025 at 9:04 PM

    Hi Alshana,

    Thanks for reaching out to Jotform Support. Are you trying to autopopulate the Departure Date field to the Date column on your Input Table? If so, you can use a conditional logic to do so. Here's how:

    1. In Form Builder, click on Settings in the orange navigation bar at the top of the page.
    2. Select Conditions in the menu on the left side of the page and click on Add Conditions and choose Update/Calculate Field.

      In form building, how can I auto populate data in a table? Image 1 Screenshot 40
    3. Set up the condition as shown below and click on Save.

      In form building, how can I auto populate data in a table? Image 2 Screenshot 51

    Here's the result:

    In form building, how can I auto populate data in a table? Image 3 Screenshot 62

    We also have a guide on How to Insert Text or Calculation Into a Field Conditionally that you can check out.

    Give it a try and reach out again if you have any other questions.

  • alshana
    Replied on April 17, 2025 at 2:20 AM

    Thank you this did help!

    Another question, is there a way to auto populate the next dates down that column depending on the date range in departure date field and return date field?
  • Christine Jotform Support
    Replied on April 17, 2025 at 4:48 AM

    Hi Alshana,

    To avoid confusion, I moved your other question to a new thread and helped you with that here.

    Let us know if there’s anything else we can help you with.

Your Answer