- iondjpAsked on May 04, 2017 at 02:26 AM
Is there a way to set the default values in an Input Table where the Input Type is Text Box or Numeric Text Box.
I have found info describing how to set Calculation Values in an Input Table, so I hoped that I could set these to numeric values (i.e. 300.00, 350.00,etc) and hoped those values would appear in text box.
But, no such luck.
The reason for this....I want to create a simple table as a price list and then use the values in the cells in calculations (either in a condition or a Calculation Wizard field). I tried to use the spreadsheet widget for this purpose, but it does not appear to allow me to pull the values out of the spreadsheet cells to use in the Calculation Wizard or to specify the specific cells to insert as FormFields in Text areas.
Any assistance would be appreciated
- SvenAnswered on May 04, 2017 at 03:07 AM
You can use the values in cells in an input table to perform calculations, either using the form calculation widget, or conditional logic. Here's a guide explaining how to achieve that:
I hope this answers your question, please let us know if you need any further help.
- iondjpAnswered on May 04, 2017 at 09:19 AM
Sorry for the confusion here...I thought I got this to work, but it appears not.
The problem is, it appears that when you use the Text Boxes as Input Types, the values do not work.
In fact, my testing shows the following;
Radio Buttons and Check Boxes work as described
DropDown Boxes will use the DropDown Options, not the Calculation Values
The Text Box, Currency Box, & Numeric Text Box do not work for this purpose.
I expected and hoped that the values I inserted in 'Calculation Values' would be inserted in the Text Box as the default.
- JotForm SupportBJoannaAnswered on May 04, 2017 at 11:01 AM
Please note that calculation values can only be assigned to check box and radio button fields. It is not possible to assign calculation values to other type of fields.
If you are using Number or Text box fields inside of you Input Table field, values that are entered inside of the field will be used for calculation.
Only way to pre-populate values inside of the field is via URL parameter or with pre-populate app:
Here is my demo form: https://secure.jotformpro.com/71233999026967?q5_input5=1&q5_input5=2&q5_input5=3&q5_input5=4&q5_input5=5&q5_input5=10&q5_input5=15&q5_input5=20
Hope this will help. Let us know if you need further assistance.