How can I create a Form in which all logics and conditions should be used but in record submitted form it is not readable

How can I create a Form in which all logics and conditions should be used but in record submitted form it is not readable .

I tried a lot to connect an excel sheet but fail.

Kindly share me that how can I fulfilled the client requirements as it would be easily readable, manageable and looks to be engaging heaving proper data in submission form.

Hi Muhammad,

Thanks for reaching out to Jotform Support. Building a form with full logic and conditions while ensuring the submission record is clean, readable, and client-friendly can be done by taking these actions. First, clearing hidden field values on the form. It’s easy to disable the setting that automatically clears hidden field values on form submission. Let me show you how:

1.  In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2. Then, click on Show More Options, and scroll down to the Clear Hidden Field Values section.
3. From the Clear Hidden Field Values Dropdown menu, select Don’t Clear.

The next step is hiding empty fields in PDFs. You can hide empty fields in PDF Editor in just a few simple steps. Let me show you how:

1. In PDF Editor, click on the Gear icon in the upper right corner of the page to open PDF Settings.
2.  Put a check in the box next to Hide Empty Fields. This will hide the fields that haven't been filled in the form when you are using it as PDF document. Check out the screenshot below to see how it'll look:

After that, you can improve readability and layout using Section Headers and Page Breaks to organize the form into logical sections, or consider switching to the Card Form layout for a step-by-step filling experience. Additionally, in PDF Editor, rearrange and format fields so the output matches the order and clarity your client requires. As for exporting to Excel, Jotform does not support live syncing directly with Microsoft Excel, but you can integrate with Google Sheets for real-time syncing and then download the sheet as Excel anytime. You can import data to an existing Google Sheet using our Google Sheets Integration. Let me show you how to set that up. First, let's connect your Google account to the form:

1.  In Form Builder, in the orange navigation bar at the top of the page, click on Settings.
2.  In the menu on the left, click on Integrations and select the Google Sheets integration.
3.  Now, select Use an Existing Spreadsheet and click on Next.
4.  Then, click on Authenticate and connect your Google account. Then, let's set up the integration settings:
5.  Once you connect your Google account, click on Add Action.
6.  In the Select a Spreadsheet section, click on Select, and
7.  Select your Google Spreadsheet in the window that opens and click on Select.
8.  Scroll down, make sure the Send Existing Submissions to the Sheet option is selected, and click the Save button at the bottom right of the settings. That’s it. Once everything is set up, your existing submissions will be sent to your spreadsheet. Any new submissions to your form will also update your Google Spreadsheet automatically. Check out the screencast below to see how it'll work:

Alternatively, from Jotform Tables, you can download submissions in Excel format. You can easily download your data from Jotform Tables as a CSV, Excel, or PDF file. Let me show you how:

1.  On your My Tables page, hover over the form whose data you want to download, and click on View Table.
2. On the upper-right side of the page, click the Download All button. 
3.  Now, select Download as CSV, Excel, or PDF to download your data.

You can also check out our How to Download Form Submissions as Excel, CSV, or PDF guide for more information.

Give it a try and let us know if you have any other questions.