What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
Alter the input to the spreadsheet based on the user choice of the drop down.Asked by snaplash on July 03, 2015 at 08:16 PM
Hi, Is it possible to have a user friendly term in a dropdown menu such as "Garamond" and have the input in the spreadsheet be "Adobe Garamond Pro-Bold" for example?
Thanks for contacting us.
If you are referring to changing the font of the Drop Down field to Garamond and Spreadsheet field to Adobe Garamond Pro-Bold, this might be possible by adding a custom CSS code in your form. If you can provide to us the link or name of the form in question so we can suggest a custom CSS code that you can use in your form to change the font of the fields.
We will wait for your response.
Thanks for the response,
Can you try injecting the custom CSS code below in your form?
font-family: "Garamond" !important; //change font for all the labels in the form
font-family: "Garamond"; //change font for drop down menu
font-family: "Garamond"; //change font for input field
font-family: "Garamond"; //change font for button submit
To inject custom CSS code in your form, just follow the instructions provided in this article: How to Inject Custom CSS Codes.
If you want to only change the style for a specific field, can you point out which field so we can further check? And also, I did not found any Spreadsheet field in your form. Are you referring to the Address Map details field? Please confirm.
We will wait for your response
I am sorry. I dont think I was clear. I dont want anything on the form to change.
I am trying to just alter the input to the spreadsheet based on the user choice of the drop down.
IE if the drop down selected was windermere, the spreadsheet "could" populate a fixed value like Windermere Real Estate, or 1234, or anything else for that matter
Thank you for clarifying your request.
You wish to have your DropDown present one value to your users, but input a different value in the submission reports, excel files and spreadsheets. Yes, that is possible with our tools.
You would need to (1) set up Calculation Values to your Drop Down field, (2) add a (hidden) field where you would forward your desired substitute values, and (3) add Conditional Logic to update the field 2 with value from field 1.
Please just keep the first row at the top of the Calculation Values with a dummy/random value, as depicted in the image. It would be "assigned" to the empty drop down option, so you can use "empty", though I have used "dummy".
Your spreadsheet values would appear like this:
I hope this helps.
That is Spectacular! Thank you!
One more additional question on the same topic...
Is is possible to fill multiple fields. IE if the user selects "Windermere" it would populate color, logo and font fields?
" the user selects "Windermere" it would populate color, logo and font fields?"
Do you mean to show certain fields depending on the selection? If yes, this is possible to accomplish with the conditional logic to Show/Hide a field:
First you add the fields:
Then click on Conditions, and select Show/Hide a form field:
Then you can create a rule like this:
This is what will happen:
Hope this is what you mean.
Actually no, if you look at the comma separated conditional logic in the
main brokerage dropdown, I would like to populate seperated fields on the
You can use the approach highlighted by Boris, in this case you add multiple rules to the condition that updates a from field value.
Could you kindly provide a link to the updated form in question so i can create some test scenarios using a cloned copy.