Submission Search By Date

[omardhillon]

Hi,

first of all form tools works perfect and it is a very helpful resource.

However, I am having a small problem, that when I try to search submissions through date, a drop down appears next to selected "date" field, with value "select date range". This is the single value in that drop box so I cannot select anything. Than there is a text box next to it, where I do not know what to enter. (I am also including a screen shot)

Basically what I want to do is to search submission by date. Any sort of help will be great.

thanks

[Ben]

Hi omardhillon,

Sorry you're having trouble!

Try just logging out and in again. The values for that dropdown are stored in sessions when you first log in. This is because it's rather time-consuming figuring out what values should be in that dropdown. If, for example, your form has a single submission from today - having options to search by the last month and year aren't that relevant. As such, it (should!) just compile a list of options that are relevant to your form.

- Ben

[EDIT]: this looks like it may be a bug: I could reproduce the problem on my installation too. Rats! Okay, I'll do some investigation.

[marcat]

Any report on this issue? I too am seeing the "Select date range" list display with no options in it? This is true even for forms with more than 100 records. However I have some forms that it works on? In every case I am using the system generated date_submitted field...

Hi omardhillon,

Sorry you're having trouble!

Try just logging out and in again. The values for that dropdown are stored in sessions when you first log in. This is because it's rather time-consuming figuring out what values should be in that dropdown. If, for example, your form has a single submission from today - having options to search by the last month and year aren't that relevant. As such, it (should!) just compile a list of options that are relevant to your form.

- Ben

[EDIT]: this looks like it may be a bug: I could reproduce the problem on my installation too. Rats! Okay, I'll do some investigation.

[Ben]

Hi Marcat,

I'm afraid this thread is rather dated now: I replaced the search-by-date functionality with a much more spiffy JS calendar search, in 2.1.0 (I think). What version of Form Tools are you using?

- Ben

[marcat]

Ben,
Thanks for the reply. I am currently working on upgrading to 2.2.2. I have it installed and have successfully imported all data from our prod server to the new version. I have also added CAS authentication over the top of the FT authentication. That too is working great.
I can see lots of UI changes and the date searching is slick.
Very much appreciated...

Marcat

Hi Marcat,

I'm afraid this thread is rather dated now: I replaced the search-by-date functionality with a much more spiffy JS calendar search, in 2.1.0 (I think). What version of Form Tools are you using?

- Ben