- snaplashAsked 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?
- JotForm SupportChriistianAnswered on July 03, 2015 at 09:11 PM
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.
- snaplashAnswered on July 03, 2015 at 09:14 PM
Thanks for the response,
- JotForm SupportChriistianAnswered on July 03, 2015 at 10:56 PM
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
- snaplashAnswered on July 03, 2015 at 11:02 PM
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
- BorisAnswered on July 04, 2015 at 01:29 AM
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.
- snaplashAnswered on July 04, 2015 at 12:30 PM
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?
- JotForm SupportBDAVIDAnswered on July 04, 2015 at 09:44 PM
" 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.
- snaplashAnswered on July 04, 2015 at 09:48 PMActually no, if you look at the comma separated conditional logic in the
main brokerage dropdown, I would like to populate seperated fields on the
- SammyAnswered on July 05, 2015 at 05:27 AM
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.
- snaplashAnswered on July 05, 2015 at 11:23 AM