JotForm Cards: Show or hide field based on an answer in a Yes/No field type Input Table field

Hi!

We have set an input table, with yes/no answers to 9 questions.  We need:

1. Trigger a logic to show an additional field if any of those questions were answered "YES"

2. Store the actual answers.  Now they are not recorded in Google Spreadsheets.

Please advice

As for your first concern, I see that you have set a calculation value with for each row in the table.

And since that is the case, you will only be needing to pass the calculation value of each row into a Form Calculation widget.

The result of the calculation shown in the screenshot above will be a 9-digit number where each digit represents the calculation value of the selected answer in a row.

Once you have set that up, you can now create a condition that will show/hide a field based on the result in the Form Calculation widget.

Note: You have to hide the Form Calculation widget on the form. You can do that from its properties. — How-to-Hide-Form-Fields

Here's a Sample Form I have created based on the only form in your account — https://form.jotform.com/91474956816976

With regards to your other concern, I have integrated the Sample Form with Google Spreadsheet and I see that the output of each row's answer in the spreadsheet is either "True" or "False". I believe that is the default return output for the Yes/No field type of the Input Table field. And to my understanding, you would like to have "Yes" or "No" as the output passed to Google Spreadsheet. Is that correct? Kindly confirm.

We will wait for your response.