I just had a look at the Formulaire table form in the database: I have to sort by ele_order to make any sense of what's there. In the form_form table, sorting by ele_id is necessary as well---is there a problem with the way form details are written to the database? Or is the problem Formulaire doesn't/won't allow the same elements (user name, email, etc) to be used in different forms?

I could really use some help with this...this issue with the details being our of order is really frustrating and I'm ready to dump Formulaire and go back to the Liaise module.

Edit: We've removed the need for the file upload element in a form, so we've removed Formulaire from our site. I still think it's a great module so best of luck to everyone using it. Thank you.

I think I've finally found the problem with the details showing out of order when viewing form details...a < i > seems to be the cause (see below).

modules/formulaire/admin/consult.php, line 164:


modules/formulaire/admin/consult.php, line 245:


I removed the < i > from both lines and so far it seems to have done the trick.

philou: Please check this on your end to see if this is indeed a fix---I couldn't understand why < i > was being used (in the code) to display the details (as a list) when html is not used to write the form details; I removed the < i > and so far, so good.

EDIT: DISREGARD THIS POST...this doesn't fix anything!

What's the difference between Formulaire v3.01 and v3.02? I've downloaded both and can't see a difference between the two of them...maybe that explains "Powered by Formulaire 3.01 © 2005 philou" which shows in the backend on modform.php? I thought I had v3.02 but I guess I don't...

Also, what's going on with the Formulize module? Is this someone's copy/clone of Formulaire? I had originally tried Formulize before Formulaire but got rid of it since it didn't offer the file upload option when creating forms. The information at dev.xoops.org seems to indicate that these two modules are being combined...

I really need to get this module up and running, but without the backend problems. This is probably one of the most valuable contributions to XOOPS we've seen (from our perspective) and it's crucial we get the kinks worked out because this particular module will likely benefit our members more than any other in the long run.

I just cannot seem to get away from the problem with the way form details are displayed on the consult.php page---no matter if I uninstall, delete the directory and reinstall the module, and no matter how many times I create different forms, the information is consistently appearing jumbled when displayed. Am I the only experiencing this issue with Formulaire?

Edit: Apparently there's an issue with using two of the exact same select box elements within the same form: If you use two select box elements with different names but use the same select box information, the displayed information on consult.php appears 'jumbled' and out of order. FYI, changing these elements or deleting them does NOT fix the issue of the details being shown out of order. Something else is going on, but I can't seem to pinpoint the problem...EXAMPLE OF THIS ISSUE: We have a genealogy site and we could really use multiple select boxes (with the same selections) within the same form: Birth Location element shows a select box with 10 countris listed and Death Location shows the same. As it is, I'm unable to duplicate an element this way within the same form, even if the elements have two different names...

I apologize on suggesting the above change---I think I may have jumped the gun on this one...

There is one problem remaining: On the admin/consult.php page, the form details appear jumbled, so its obvious I'm missing something somewhere. I thought it may have been line 158 in consult.php but I think I'm wrong again.

Can someone help out with this?

FYI, changing line 158 in modules/formulaire/admin/consult.php from:

$date[$idd] = $j.'/'.$m.'/'.$a;

to:

$date[$idd] = $m.'/'.$j.'/'.$a;

...will display the date (on the consult page only) as 05/25/2005 instead of 25/05/2005.

gtop00:

I think I have a work-around for your date issue...

Open your www/include/calendarjs.php and look around lines 86-87 for:



Open your www/class/xoopsform/formdateselect.php and look around line 62 for:

(lines will be longer---I moved the code around so it doesn't stretch the page here)

What you'll need to do is change both formats to the same setting in each file and it should work for you.

My setting (F j Y) displays the date as May 25 2005. The following are the various date formats you should be able to use:

'D d M, Y' displays Sun 18 Aug, 2002
'D d M, Y g:i a' displays Sun 18 Aug, 2002 4:38 pm
'D d M, Y H:i', displays Sun 18 Aug, 2002 16:38
'l d M, Y', displays Sunday 18 Aug, 2002
'l d M, Y g:i a', displays Sunday 18 Aug, 2002 4:38 pm
'l d M, Y H:i', displays Sunday 18 Aug, 2002 16:38
'D M d, Y', displays Sun Aug 18, 2002
'D M d, Y g:i a', displays Sun Aug 18, 2002 4:38 pm
'D M d, Y H:i', displays Sun Aug 18, 2002 16:38
'j F Y', displays 18 August 2002
'j F Y, g:i a', displays 18 August 2002, 4:38 pm
'j F Y, H:i', displays 18 August 2002, 16:38
'jS F Y', displays 18th August 2002
'jS F Y, g:i a', displays 18th August 2002, 4:38 pm
'jS F Y, H:i', displays 18th August 2002, 16:38
'F j Y', displays August 18 2002
'F j Y, g:i a', displays August 18 2002, 4:38 pm
'F j Y, H:i', displays August 18 2002, 16:38
'F jS Y', displays August 18th 2002
'F jS Y, g:i a', displays August 18th 2002, 4:38 pm
'F jS Y, H:i', displays August 18th 2002, 16:38
'j/n/Y', displays 18/8/2002
'j/n/Y, g:i a', displays 18/8/2002, 4:38 pm
'j/n/Y, H:i', displays 18/8/2002, 16:38
'n/j/Y', displays 8/18/2002
'n/j/Y, g:i a', displays 8/18/2002, 4:38 pm
'n/j/Y, H:i', displays 8/18/2002, 16:38
'Y-m-d', displays 2002-08-18
'Y-m-d, g:i a', displays 2002-08-18, 4:38 pm
'Y-m-d, H:i', displays 2002-08-18, 16:38
'j. n. Y', displays 18. 8. 2002
'j. n. Y, g:i a', displays 18. 8. 2002, 4:38 pm
'j. n. Y, H:i', displays 18. 8. 2002, 16:38
'd. m. Y', displays 18. 08. 2002
'd. m. Y, g:i a', displays 18. 08. 2002, 4:38 pm
'd. m. Y, H:i', displays 18. 08. 2002, 16:38

Remember, change both settings in each file or it won't work. FYI, I also had to change my 'start' year in calendarjs.php to 2005 for this to work. I'm not sure if it will work if you're using 1970 as your 'start' year. Good luck.

Below is a screen shot (blurry because its reduced in size) of how we're using philou's Formulaire module:

Quote:

Just figured out that this is not an issue with the Formulaire module at all: This is a problem with the webmail client (Neomail) that I'm currently using. FYI, I'm now receiving both the form and the autoresponder from the group email that the form is sent to. Also, I wasn't too keen on the boxes (bordering the form details) in the email, so I opened up the /modules/formulaire/index.php file and changed the colors from black to white and #C0C0C0 to #FFFFFF, which looks better to me (the form looks less like an Excel or Word doc as its displayed in the email).

All in all, this is probably one of the more useful modules I've added to our site and I've very pleased with it. We really needed this module, believe me. Much thanks to philou.

PS Still trying to figure out nos. 1, 2 and 4 in my earlier post...

gtop00:

I've had the same problen with changing the date format, and I think it's calling this format from the database (mysql) somewhere in the php code (not an expert on this).

To change your year setting (you should be able to set it back to 1970, which I think is the earliest or farthest back you can go with php/mysql), you'll need to open calendarjs.php (yoursite.com/include/calendarjs.php) and look around line 37 for this:

cal.setRange(2004, 2015); <---this is how mine is set up

Change the 2004 (or whatever your file shows) to 1970 and it should work (I think).

animas:
I wish I knew the answer to that one as well.

I fixed no. 3 by adding $req = true; to the above mentioned elements in the elements.php file...

I agree with animas...its refreshing to see a XOOPS mod developer on top of their projects and updating them when necessary. Bravo to philou for all the hard work...

However, I do have a some additional concerns and/or questions about Formulaire that I'd like explained/answered:

1. In the Modify menu, where you can see and edit/add/delete the form elements, I've noticed that re-sorting ("New sort") elements removes any "required" checks you may have for your elements and you have to re-check all the "Required" checkboxes of the elements all over again. Is there a way to fix this?

2. Related to the above issue, when you re-sort any "Join a file" element in a form, any changes you've made (file type, file size, etc) to this element automatically revert back to the default settings when you're done re-sorting. Can this be changed in the php code somewhere?

3. I've also noticed that there is no "Required" checkbox (when editing elements) for the "Select box" and "Join a file" elements (other elements lack this as well but these are the two I'm concerned with). On our application form, there are four select boxes that really should be required. Is there a way to add this to the php code?

4. I have a few test accounts (all with different emails) that I always use when adding new modules to our site. With Formulaire, if I fill out our application form with any test account and submit it to the specific group it should go to, the email of the test account doesn't receive the autoresponder email from the group email address that the form is being sent to. What happens is the autoresponder email is sent to my main (admin) email account---it appears that my own IP is being recognized as the (sender) origin of the form, rather than the email that's been entered into the form itself (which is where the autoresponder should be going to). Is there a way to fix this?

5. Finally, and related to no. 4, is there a way to forward or send the information input into the form to the person who fills out the form and to the group email the information is to be sent to? As it is, the only thing the group email receives is a copy of the uploaded image, and none of the information that's been entered into the form---this information is sent as an attachemnt and doesn't display in the email itself. This would really be useful for our site since our members will be paying yearly dues for our organization.

I'd appreciate some input or suggestions on these issues. Thank you.