Manually added field is blank

[MHarrison]

Hi guys,

I have an external direct form that originally accepted the date in three "text" fields, month, day and year. Searching on date wasn't very feasible, so I have revised the date input to a single "date" field, which would then allow the included datepicker jQuery function allow for searching on dates.

I've got the new field in place and have added it to my view where I would like it to display, but I'm not seeing the submitted dates. I've run a couple of tests and the data is being passed to the database, which I have been able to verify with phpMyAdmin. The column for the field shows up in my view, but it is empty.

Any help in fixing this would be greatly appreciated. Thanks.

Regards,

Mark Harrison

[MHarrison]

Hi guys,

Have been playing with this some more and it looks like I have uncovered a bug. To whit, when the new field's "field type" is set to "textbox", the data shows up in my view, but when the "field type" is set to "date", the field is blank in my view.

My problem remains this: I want to set the "field type" as "date" in order to be able to search for a range of dates, which is an available search option only for "date" field types. If the data is not available when this field type is set, then the ability to search for it fails.

Can anyone lend a hand in resolving this?

[Brent123]

Hi. Have you made sure your HTML INPUT tag TYPE is set to DATE (on the form's HTML code) for the field in question? Since the data is available when the field type is set to "textbox" in Form Tools, maybe the HTML INPUT tag TYPE is still set to TEXT, rather than DATE. This is just a quick/random guess. Here are a few references that may help:

http://www.w3schools.com/tags/tag_input.asp

And, HTML5 has several new INPUT tags:
http://www.w3schools.com/HTML/html5_form..._types.asp

Of course, I am assuming that you added your form using the "direct/POST" method, rather than using the Form Tools Form Builder module. If the latter is the case, then am not sure what is causing the problem, since I have not yet used Form Builder. In any case, just check all of your INPUT tags in the HTML code to make sure they match the settings in Form Tools' view fields.