-
Rajpoot_JunaidAsked on April 8, 2025 at 8:30 AM
I am trying to create a form with input tables based on conditional logic. my conditions are already working fine, but it submits other forms too that are not filled or not required.
I want to get only what's been filled by the user
I am trying to create a form where users will
- Select a criteria such as Vendor name . (single choice property field)
- This would then reveal an Input table based on the above selection (I have the conditions working on this)
- Each table would have
- upto 15 rows
- 2 Two columns, both numeric values
- The user would enter a number in the corresponding row/s,
- Later in the submit page, it would have fields for summary that would show
- Vendor Name
- Row wise items
- 2 Columns filled with numaric value
Right now all the related input tables are being submitted, which are not required, would appriacite help in this regards
-
Manilene JotForm SupportReplied on April 8, 2025 at 11:34 AM
Hi Rajpoot_Junaid,
Thanks for reaching out to Jotform Support. Even when hidden, JotForm includes data from all fields unless told otherwise. You can check if the Clear Hidden Field Values is enabled.
- In Form Builder, on the orange navigation bar, click on Settings.
- On Form Settings, click on Show More Options.
- Scroll down, on Clear Hidden Field Values and select Clear When Submitted.
- Selected Vendor Name
- Only rows that were filled (with values in either column)
Since Input Tables are tricky for partial summary, here's how to handle it:
Option 1: Use Form Calculation Widgets + Conditional LogicCreate hidden calculation widgets for each row in your Input Table:
- Only pull values if the row is filled.
- Combine these into a summary Text field.
Example Logic (per row):
If Input Table[row][Stock] or Input Table[row][Order] is filled - Then copy the row label + numbers to a Short Text or Form Calculation widget.
Reach out again if you have any other questions.
-
Rajpoot_JunaidReplied on April 8, 2025 at 2:25 PM
Hi Manilene
Thank you so much for the Prompt reply As I have attached the picture, i need my final result as 3
But unfortunately, I am struggling to create a logic where if Input Table[row][Stock] or Input Table[row][Order] is filled, then copy the row label + numbers to a Short Text or Form Calculation widget.
Tried doing it, adding a hidden field to grab the data, but that also misses the first column 1 of the table.
It would be great if you could add a sample GIF image similar as above on how to create a logic that shall work if the input [row][stock] or the input table [row][Order] is filled
still all the table that are not selected are showing as out put, refer to columns 8 ,9 i.e
-
Jovanne Support Team LeadReplied on April 8, 2025 at 7:21 PM
Hi Rajpoot_Junaid,
To better understand the logic you're trying to build, could you please clarify a few things for us:
- What specific condition should trigger the data to be copied? (e.g., is filled, is not empty, etc.)
- Are you looking to copy both the row label and the numeric values from the Stock or Order columns into a separate field?
- Could you share how your current conditions are set up, or a screenshot of your condition logic?
From what you've described, it sounds like you want to extract only the filled rows from the input table and summarize them in a short text or calculation field excluding any empty rows like columns 8 and 9. As soon as we get a bit more info, we’d be happy to help build out a working example.
Once we hear back from you, we can help you with this.
-
Rajpoot_JunaidReplied on April 9, 2025 at 2:31 AM
Hi Jovanne
- What specific condition should trigger the data to be copied? (e.g., is filled, is not empty, etc.)
If the table * is filled* with any entry, all the rows and columns of that specific table should reflect in the calculation field/response sheet.
- Are you looking to copy both the row label and the numeric values from the Stock or Order columns into a separate field?
Not specifically in a separate field, if I can only get a filled table ( as a result) with rows and Stock or Order columns.
- Could you share how your current conditions are set up, or a screenshot of your condition logic?
From what you've described, it sounds like you want to extract only the filled rows from the input table and summarize them in a short text or calculation field, excluding any empty rows like columns 8 and 9. As soon as we get a bit more info, we’d be happy to help build out a working example.
I want to extract only the row names, filled rows and filled columns from the input table as final results. but in my case, all the other tables that are not filled or not required are also showing as result.
-
Mary JotForm SupportReplied on April 9, 2025 at 6:48 AM
Hi Rajpoot_Junaid,
I will need more time to look into this, I will get back to you with an update.
In the meantime, let us know if you have any other questions.
-
Mary JotForm SupportReplied on April 9, 2025 at 7:30 AM
Hi Rajpoot_Junaid,
Since the input table is considered a single field, it will show in the Notification Email as a whole, not only the filled boxes:
If you would like to copy each answer and only show the filled fields, you will need to copy them one by one. Here is a sample condition:
Here is the result:
Give it a try and let us know if you have any other questions.
Your Answer
Something Went Wrong
An error occurred while generating the AI response. Please try again!