How can I include the weekday on a date field?

  • mbycsd
    Asked on April 26, 2015 at 2:00 PM

    Hello.

     

    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.

     

    Thank you.

     

     

  • raul
    Replied on April 26, 2015 at 2: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.

  • mbycsd
    Replied on April 27, 2015 at 2: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!

    thank you.

     

     

  • raul
    Replied on April 27, 2015 at 8: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.

  • mbycsd
    Replied on April 27, 2015 at 3:05 PM

    Raul,

    Here's the test page to make sure I have jQuery set up correctly.

    http://mbyctest1.cloudaccess.net/social/1855-date-picker-test.html

    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.  

    http://mbyctest1.cloudaccess.net/social/1856-jotform-event-form-test-2015-04-27.html

    Can you please advise on how to fix the styling? 

    Thank you very much for helping me.

     

  • Welvin Support Team Lead
    Replied on April 27, 2015 at 4:24 PM

    Hi,

    You forgot to add the CSS stylesheets of the form. You have to add these lines in the source codes:

    <link href="http://d2g9qbzl5h49rh.cloudfront.net/static/formCss.css?3.2.6889" rel="stylesheet" type="text/css" />

    <link type="text/css" rel="stylesheet" href="http://d2g9qbzl5h49rh.cloudfront.net/css/styles/nova.css?3.2.6889" />

    <link type="text/css" media="print" rel="stylesheet" href="http://d2g9qbzl5h49rh.cloudfront.net/css/printForm.css?3.2.6889" />

     

    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.

    Thanks

  • mbycsd
    Replied on April 27, 2015 at 5:46 PM

    Hello, 

    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?  

     

    sw

  • Ben
    Replied on April 27, 2015 at 7: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.