Exporting submissions - need blank cells as well

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?

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.

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.

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?

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?

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