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.
How can I include the weekday on a date field?Asked by mbycsd 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.
Day Week Submissions excel
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.
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!
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.
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.
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" 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" />
<link type="text/css" media="print" rel="stylesheet" target="_blank" href="http://d2g9qbzl5h49rh.cloudfront.net/css/printForm.css?3.2.6889" rel="nofollow" />
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.
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?
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.