Clients and form list sorting?

[dethompsOWU2]

One of my clients has mulitple forms that she maintains via the FormTools back-end. She would like to adjust the order of the list of forms so the forms are organized to match up with her process.

But, when she is logged on, there is no notion of a "click column header to sort by that column" functionality like there is when I'm logged on as the FormTools admin.

Is this by design, or is there a setting somewhere that I'm overlooking?

Or, is there some other way for me to control the order in which the forms she has access to are listed?

Thanks in advance for any help you can provide,

Doug Thompson
Manager of Web and Electronic Communications
Ohio Wesleyan University

[Ben]

Hi Doug,

Ack... you're quite right - that's a little surprising. I see there's no search option either.

I'll include the sort in 2.0.5, and I may well add a simple search as well. But in the meantime, I'm afraid she's rather out of luck...

Sorry about that - I hate not being able to provide at least a workaround.

- Ben

[Ben]

Hi Doug,

I just took a quick look, and adding the sort & search was a very simple addition, so I've attached a fix to this post.

Just upload the files to the following locations (may as well back-up the old files, just in case):

/clients/index.php
/themes/default/clients/index.tpl

Note: even if she's using a different theme, still just upload it to /default. The other themes will inherit that file from default. (Or at least, they will unless they overwrite them... I don't think any do, though).

I'll include these same updates in 2.0.5 so you'll be able to upgrade safely.

All the best!

- Ben

[dethompsOWU2]

The fix worked perfectly!

Thanks!

[dethompsOWU2]

FYI...I just discovered this morning that, since replacing those two files, FormTools now brings up an error whenever the user tries to log in and view the submissions for the forms she has access to.

The error message:

It appears that your user account hasn't been assigned to any form Views, so you won't be able to see any data. Please contact the administrator for further help.

Debug:

No further help available.

Luckily, I figured out a workaround:

1. Log into FormTools as the admin.
2. Edit each affected form.
3. Remove the user from the Client list for the form and click Update.
4. Go back in and edit the form again.
5. Add the user back to the Client list and click Update again.
6. Fixed!

So, I was able to resolve the issue for her...I just figured it would be good to report the error to you, in case you need to make tweaks as you implement these changes in the next version of FormTools.

Thanks again for your help, and for creating such a useful program.

[Ben]

Hi Doug,

Interesting... thanks for posting that. I think however, it may be unrelated to the files I posted.

A few other people have reported issues where the permissions of the client accounts get dropped and they need to manually reset it. Unfortunately, I haven't gotten to the root cause of the problem yet. But thanks again - if you notice problems again, be sure to post!

- Ben