- mbycsdAsked on April 26, 2015 at 02:00 PM
Here's a link to a screen grab that explains my question: http://screencast.com/t/ZQ8PFFW0
Here's a link to the excel spreadsheet that is downloaded from the submissions: http://screencast.com/t/wNMYMYsA04ly
When the people who administer this form, download the submissions into an Excel spreadsheet they would like to see the Date-of-Event and Week-Day in one column so they don't always have to hide the "Date of Event" from the decision makers.
- raulAnswered on April 26, 2015 at 02:21 PM
Unfortunately, that is not possible.
What you have made in your form is the only way to have the date string of the selected date using the form builder.
You can accomplish this by using a regular input field in your form and a custom script to show the date picker that includes the weekday. But, you would need to use the full source code of your form along with the script to show the date picker.
Something like this: http://2008.kelvinluck.com/assets/jquery/datePicker/v2/demo/datePickerClickInput.html which uses a date picker from JQuery
Hope this helps.
Let us know if you require further assistance.
- mbycsdAnswered on April 27, 2015 at 02:41 AM
Our website uses Joomla 3.4. I have been checking this afternoon to see if I could use the JHtml static calendar function to create a Date Picker. I couldn't get it to work on a test page and it may require using the form.php instead of an article.
I may have more luck with JQuery Date Picker. I will work on that in the morning and see if I can incorporate it into the Jotform source code. If not, I will explain to the administrators that we've reached the end of my tech skills!
- raulAnswered on April 27, 2015 at 08:48 AM
Ok, here: https://shots.jotform.com/raul/559325/index.html you can find an example of a cloned version of your form with the JQuery date picker. You can see the source code of the page to have an idea of how it works, I also want to point out that you would need to use the noConflict mode in JQuery in order to make the picker work correctly.
You can also find here: http://form.jotformpro.com/form/51155980748969 the standalone version of the form I used on the example page, feel free to clone it to your account if you want to inspect it further.
If you have any questions, please let us know.
- mbycsdAnswered on April 27, 2015 at 03:05 PM
Here's the test page to make sure I have jQuery set up correctly.
Here's the link to the cloned form source code that I pasted into my Joomla article. The styling is not working well, but I do get the calendar and the result shows the week day.
Can you please advise on how to fix the styling?
Thank you very much for helping me.
- JotForm SupportWelvinAnswered on April 27, 2015 at 04:24 PM
You forgot to add the CSS stylesheets of the form. You have to add these lines in the source codes:
<link target="_blank" href="http://d2g9qbzl5h49rh.cloudfront.net/static/formCss.css?3.2.6889" rel="nofollow noopener" rel="stylesheet" type="text/css" />
<link type="text/css" rel="stylesheet" target="_blank" href="http://d2g9qbzl5h49rh.cloudfront.net/css/styles/nova.css?3.2.6889" rel="nofollow noopener" />
<link type="text/css" media="print" rel="stylesheet" target="_blank" href="http://d2g9qbzl5h49rh.cloudfront.net/css/printForm.css?3.2.6889" rel="nofollow noopener" />
You can get your form's entire source codes with the date function in this link: https://shots.jotform.com/welvin/text/thread-559325.txt.
- mbycsdAnswered on April 27, 2015 at 05:46 PM
Joomla is removing the links to the CSS stylesheets. I may need to download the stylesheets and insert them in the index.php file.
I think I have JCE set correctly: http://www.screencast.com/t/SFHk0ArFq
Do you know why it might be deleting the links?
- BenAnswered on April 27, 2015 at 07:36 PM
Since we can assist with only one issue/question per thread and this is not the same issue as the original one, I have moved this to a new thread here: http://www.jotform.com/answers/560083
We will be replying to it shortly.