cformsII Support Forum
Current User: Guest *Frequently Asked Questions*
Search 
Search Forums:


 




Dynamic form, populated from db

Add a New Topic Reply to Post
Post

cb - Guest

6:25 pm - May 13, 2008

Please replace the ??? with your data!

  • Your URL:www.vtselect.org
  • The browser used: Firefox
  • cforms version: 8.4.2
  • Your Wordpress version: 2.5.1

[desc

Hello,

I gather user information via cForms on my web site. The form has a hidden field, "Approved". I would like to create an easy way to go through the users and update which are 'Approved'.

I imagine dynamically creating a form that looks like a table, with the user's name and a checkbox, one row per user. Upon submitting the form, I would update the db with the relevant changes.

Is this possible? Is there a better approach?

(Of course, I can update the db via phpMyAdmin, but I don't want to give other manager's access to my hosting account...)

Thanks for any suggestions.

cb

Oliver - Admin

8:58 pm - May 13, 2008

posts 3899

If you track your form submissions, and go to the tracking page, you can view all user submission details (& hidden fields). You can also change any of the data, e.g. set the 'approved' field to 'yes' etc.

cb - Guest

10:05 pm - May 13, 2008

Thanks, that's very handy, but I am trying to find a way to allow someone other than a site admin to make changes.


Two related notes:

-- Is there a way to allow a non-admin user to download the cformsdata?

-- There is a problem with the XML format; it is not well-formed.

Thanks for the reply.


Oliver - Admin

10:10 pm - May 13, 2008

posts 3899

-- Is there a way to allow a non-admin user to download the cformsdata?

cforms supports the RoleManager plugin. So you could setup a user who can only access the cforms tracking page (nothing else), of course that users sees all forms that are tracked.

-- There is a problem with the XML format; it is not well-formed.

I've just followed an example, but I'm happy to consider alternatives.

cb - Guest

11:03 pm - May 13, 2008

The Roles facility is great. I copied the Author role to 'Coach', added 'Track cForms' to the new role, and created a user with role 'Coach'.

Unfortunately, when I log in as my new user, Manage->cForms II->Tracking is available, but none of the data is displayed.

What am I dioing wrong?

Thanks for the help...


Oliver - Admin

7:06 am - May 14, 2008

posts 3899

The actual (form) data is not being displayed and the page as such is?

Or do you get a white screen with nothing on it?

cb - Guest

1:47 pm - May 14, 2008

The page is displayed, with the Form Submissions control with the "View Records", "Delete Records" and "Download Records" butttons, but no data is displayed.

cb - Guest

5:46 pm - May 14, 2008

Oliver said:

-- Is there a way to allow a non-admin user to download the cformsdata?

cforms supports the RoleManager plugin. So you could setup a user who can only access the cforms tracking page (nothing else), of course that users sees all forms that are tracked.

-- There is a problem with the XML format; it is not well-formed.

I've just followed an example, but I'm happy to consider alternatives.


I think it is as simple as putting all the <entry> elements in another element. According to XMLSpy, this is well-formed:

<?xml version="1.0" encoding="utf-8"?>
<entries>
<entry form="Player Information" date="2008-05-07 08:55:34">
<data><![CDATA[Xippy]]></data>
<data><![CDATA[xippy@gmail.com]]></data>
<data><![CDATA[555-555-5555]]></data>
<data><![CDATA[11/20/1889]]></data>
<data><![CDATA[Male]]></data>
<data><![CDATA[]]></data>
<data><![CDATA[]]></data>
</entry>
<entry form="Player Information" date="2008-05-07 08:51:07">
<data><![CDATA[Sparky]]></data>
<data><![CDATA[sparky@gmail.com]]></data>
<data><![CDATA[555-555-5555]]></data>
<data><![CDATA[11/20/1989]]></data>
<data><![CDATA[Male]]></data>
<data><![CDATA[]]></data>
<data><![CDATA[]]></data>
</entry>
</entries>

Oliver - Admin

10:03 pm - May 14, 2008

posts 3899

The page is displayed, with the Form Submissions control with the "View Records", "Delete Records" and "Download Records" butttons, but no data is displayed.

Ok, I think I know what's wrong. I'll send you an update via email.

I think it is as simple as putting all the <entry> elements in another element. According to XMLSpy, this is well-formed:

Thanks for that, I'll compare and have closer look asap.

Add a New Topic Reply to Post


Reply to Topic: Dynamic form, populated from db
PLEASE READ THE FAQs FIRST! THANK YOU.

NOTE: New Posts are subject to administrator approval before being displayed

Guest Name (Required):

Guest EMail (Required):

Guest URL (required)

Math Required!
What is the sum of: 11 + 1        (Required)

Topic Reply:


 
© Simple:Press Forum - Version 3.1.3 (Build 356)