Email (admin) form field ordering
Permalink Browser Info Environment
Great work on this! Does everything I could want and more, BUT just spotted something a little annoying in a fairly complex brochure-request form i'm collecting on my site. Basically, whilst the form elements are in order on the page, and they show up perfectly in order in the form results in the dashboard, the admin email confirmation is moving the first three fields (in my case, 'first name', 'last name' and 'address 1') to the end of the email field list.
By no means a huge problem, but a little bit of a pain to have to re-jig and just looks a little wrong. What could be causing this? I haven't checked, but is this maybe something to do with the ordering of the table in the database? Any way to fix this without trying to re-build my form?
By no means a huge problem, but a little bit of a pain to have to re-jig and just looks a little wrong. What could be causing this? I haven't checked, but is this maybe something to do with the ordering of the table in the database? Any way to fix this without trying to re-build my form?
| Type: | Discussion |
|---|---|
| Status: | New |
Well, i've spotted the problem -- see the attached screengrab of my the form's entry in the database. Looks like, whilst the myqID is correct, the qID has the number sequence wrong and it's making those three first fields appear at the end of the questions for that block. Oddly enough, everything works fine in the Reports page AND in the downloaded Excel file...only the admin email copy that follows the mySQL database ordering (ie. the order in the screengrab). Can't imagine quite why these would have saved in the database like this but, looking at the other couple of extended forms i've got on the site, the same thing has happened - the first three fields have been put at the end.
Quite possible that i've done something crazy to cause this but, short of trying to remake the form again, is there a fix I could implement? Change the way the rows are read through in the .php admin email page perhaps? Fiddling the ids by editing the database manually?
Quite possible that i've done something crazy to cause this but, short of trying to remake the form again, is there a fix I could implement? Change the way the rows are read through in the .php admin email page perhaps? Fiddling the ids by editing the database manually?
You'r right! That is the problem.
You could change the positions in the database, but that only works for just one form and only for you...
I think the problem is the script, the admin and recipient e-mails order by position. The reports and excel doesn't and order by qID.
I'll update the block....
Thank you for your feedback! We are just a little bit closer to a perfect world ;)
You could change the positions in the database, but that only works for just one form and only for you...
I think the problem is the script, the admin and recipient e-mails order by position. The reports and excel doesn't and order by qID.
I'll update the block....
Thank you for your feedback! We are just a little bit closer to a perfect world ;)
Nice one...glad to help! I'll updated as soon as it's posted and let you know how I get on.
Hi Corretje,
Came back on to check progress on this yesterday and grabbed the update - 1.3 to 1.4. Fields still ordering wrong in the admin email though? This still on the 'to-do' list, or am I doing something wrong?
Came back on to check progress on this yesterday and grabbed the update - 1.3 to 1.4. Fields still ordering wrong in the admin email though? This still on the 'to-do' list, or am I doing something wrong?
Have there been any updates on this? Having the same issue.
Thank you!
Thank you!
It should be solved, but it seems it turned up again.
I'm working on an update. So I'll check it out...
I'm working on an update. So I'll check it out...
Thank you for the compliments!
I checked your problem but I couldn't find anything wrong with my form. I reordered the form completely but nothing went wrong.
Can you check if the Excel version is also mixed up?
I don't know if you can take a look at the database? But could you check the table btExtendedFormQuestions. The field position should be giving the right order of the formfields....
I hope you can find some more information for me....
Thanks!