Exporting submissions - need blank cells as well

  • Profile Image
    eriediocese
    Asked on November 03, 2021 at 12:19 PM

    I created a form with several tables in it.

    I am importing the submissions into an Access database

    In order for the columns to line up properly for the import, I need all of the columns to export whether or not they are completed.

    Is there a way to do that?

  • Profile Image
    parker
    Answered on November 03, 2021 at 03:26 PM

    Hello,

    How are you exporting the data? When I made a clone of your form when I had blank cells in the tables I still got every row to show up on Excel even if they weren't filled.

    1635966937_6182dfd9e79c1_

  • Profile Image
    eriediocese
    Answered on November 04, 2021 at 12:41 PM

    I am talking about columns not rows. I need ALL of the columns to export whether or not the person has submitted content for that field. It's the only way to get consisted positioning in the columns all the way across the row.

  • Profile Image
    parker
    Answered on November 04, 2021 at 01:51 PM

    Hello,

    In looking at the screenshot you can see where my submission had no data in the column H, I, J, K and the column still showed up on the sheet.

    How are you exporting where you're not getting this?


  • Profile Image
    eriediocese
    Answered on November 06, 2021 at 10:18 AM

    It appears I didn't have all of the columns selected.

    Is there any way to only allow numbers in some of the columns?

    Most of my tables have 5 columns. The first column in a 5-column table contains text but the remaining 4 columns should only allow numbers.

    I have one table that only has 4 columns. Those should all be numbers.

    Is that possible?


    Also, on 11/4 I deleted a bunch of form responses for this form that I shouldn't have. Can I get them back?

  • Profile Image
    Amos_W
    Answered on November 06, 2021 at 11:14 AM

    Hi there,

    Unfortunately there is no way of applying a certain data type to only one column in the table element

    You might find some use in the "Time Picker" widget.

    https://www.jotform.com/widgets/time-picker

    or maybe the configurable list

    https://www.jotform.com/widgets/configurable-list

    or maybe the Appointment Slots widget

    https://www.jotform.com/widgets/appointment-slots


    Hope any of those could serve you in any way, anyhow, I apologize for the inconvenience.


    For the deleted submissions,

    Please have a look at the following article,

    https://www.jotform.com/help/1000-how-to-restore-deleted-submissions-in-jotform-tables/

    It will easily take you through the process of restoring your deleted submissions,

    If you need any further assistance, Please let us know,

    Thank you