After a form is submitted, the admin area of com_forme has a \"View Data\" button that lets you see the submitted data.

But how on earth do we edit it? There isn't an edit button up there, and when people make typos on these things or when facts change over time, the users will want to write-in & ask that their submissions be changed...

Is there really no way to edit these without using PhpMyAdmin? Or did I overlook something?

Thanks,
Luke

Alex wrote me to say that this will not be available until Version 2 of RSform...

I guess I'll be editing inside PhpMyAdmin until then...

Have you tried editing the data through phpmyadmin? If yes, did you encounter any problem displaying the edited data afterwards in the rsform admin?

I tried it and I got issues listing one of the edited form:

www.rsjoomla.com/index.php/RSform-How-To...tabase-Manually.html

and I'm still not sure how to get way round it.

What are you using the form for that you need to edit submission?

They're really currently designed for...submittal of data such as contact us forms, submission forms, feedback etc. They're not for database management and access.

I'm using the form for team submission, and i need to edit the form for typos as well as changes in the team players.

Tell me about it... I'm using RSforms so that my membership site can post form-based reviews of web 2.0 sites. Each one would have 10 questions or so, and they don't need to edit them later... But when they make a big mistake, _I_ need to edit them occasionally. (I don't want to, but sometimes they really look dumb!)

I think RSforms would be perfect if Alex added a \"Edit\" button beside where the \"View\" button is now inside the backend controls.

He told me already that it doesn't exist yet, but he's working on it ver the next major upgrade.

-Until then I'd like to use PhpMyAdmin... If only I can find the right Table!

(Performs had 3 tables clearly marked in my PhpMyAdmin DB. DBQ had 9. Facilforms had 15 freaking tables... But I can't find a single one of them for RSforms!)

Any clues, guys?

Thanks

Hi,
find this table
jos_forme_data<br><br>Post edited by: lenamtl, at: 2008/02/20 00:38

Yep, I finally found it... Four \"jos_forme_\" tables I missed before.

Unfortunately, I went inside the Data table, found my feild that I wanted to change, and simply changed an Url to add a folder in the path... That's it, I didn't touch anything else on the page at all but editing a path (NOT at the ends, in the middle of the link, mind you...)

But apparently I was supposed to edit something else on the page...

When I saved it like that the entire data cell/row/item/listing went wonky.

Instead of all the divisions showing up in their seperate boxes on my display forme_list page, suddenly just that record dispalyed ALL of its' results within the first box!

So I can only conclude that I don't know what in the heck I'm doing inside PhpMyAdmin...

Was there something I was supposed to do, such as set that text field to a certain setting before saving?

Any PhpMyAdmin gurus here?

Thanks in advance everyone...
Luke

I actually have a question. Why would you want to edit the data? RSForm is not a database management solution. It's a form processor that just happens to keep a record of submissions. If you're collecting data that may needs to be changed, have your form submittor, submit a new form.

The problem people are having is that they're trying to go beyond the scope of the component. Thing data collection and submission, not data management.

If you want form fields that people (and Admin) might need to change, use Community Builder and create new profile tabs and fields. Then the data can be used as data management.

I seriously doubt that CommBuilder would allow me to make new sections of my front-end and back end that all do the jobs I've barely gotten RSForms to do.

I am using CommBuilder on that site, but I've seen no options at all from it that would Display any form data outside the profile. (So no \"Library\" section, which is my main objective here.)

-This collected data should not be linked to a profile, except perhaps to give the author the ability to edit it which is frankly overkill in my situation.

What exactly are you trying to do then?

It sounds like you're trying to use RSForms for input and retrieval which is really beyond the scope of RSForms. You could change the data in the database but that still wouldn't change the fact that the original input that was sent to the user, will NEVER get changed.

Yes, I'm trying to use RSform for a limited bit of retrieval as well, which I thought at first the Mod_Forme_List was designed to do.

I've set up my joomla site to display the results of a form's 10 questions in a content item. I want my whole membership to be able to go to one page where the forms are and submit the resources they know about, and then go to another page where they can go view all of the results from everyone.

As I said above, I'm using RSforms so that my membership site can post form-based reviews of web 2.0 sites... It's quite simple and I have already tried to use DBQ, FacilForms, and Performs all before I found RSform.

The first three needed me to become a rocket scientist or at least an SQL programmer to get their forms to actually do anything. (Excepting, FacileForms, which worked great to collect the data but couldn't display it on the front-end at all.) With this one and the com_forme_list mod, I can get it to do everything I need minus the edit.

Something I'm not able to do at all that I would LOVE to do is have the front-end users be able to sort results by certain data rows... I've seen nothing online at all that powerful however.

Do you know of a more suitable extension for my needs?<br><br>Post edited by: lukeparker, at: 2008/02/20 20:30

Wait, so all you want to do is make it so that people can post comments and reviews about a film?
Have you thought about using a comment component?
There are quite a few out there that will do exactly what you're talking about.
I really think it's a matter of going beyond the scope of RSForm.
RSForms should be thought of a just a plain old form creation and processing application that sends the results to specified email address and stores the results in a datatable for backup references.

It really is not designed for pulling data out of the database.

Do you know of a comment component that would let me create 10 or so feilds, make some of the checkboxes, some of them text fields, some radio buttons or prices, and let me sort by high price or checkboxes selected?

Good god man...How much information do you want your customers inputing? You'll chase them away with extravagant forms.

Dude, you're loosing me. The last message you said you just wanted people to comment. Now you want a bunch of other information?

Tell me EXACTLY what you want to collect and why?
Show me an example or at least, let us know your website so we can get an idea for what you're trying to implement.

Are you a video store?

Hi lukeparker ,

I never realised that all form data where into the params field well this is not easy to manage

Like you I'm using DBQ but it's not very easy to use and take time to implement,.

I'm using jmovies maybe it's that will suit your need and this will be easy to add new fields.

unfortunately I cannot PM you, there is no PM option ont this forum.<br><br>Post edited by: lenamtl, at: 2008/02/21 00:54

I never said it was about films. I said my community reviews Web 2.0 sites.

Here's the setup: Some of them have used YouTube, some used Revver, some tried out Blink.tv, and so on... The members area of this site is just for paying members who want to know the best way to make money with the right web 2.0 sites for their skillsets.

So it's a community shared library. Depending on the strategy they are using, some people will be looking for the site that pays them the most up-front. Others will be looking for the site that pays the most in residuals (Per page view, for instance.)

My 10 questions for that form would be things like:
\"How Much Money do you make Up-Front per submission?\"

And the answer form would be just a text box, or in other cases it might be a bunch of checkboxes, like for the question \"Which payment methods do they offer?\"
In that case the checkboxes will say \"Paypal, Check in the mail, Wire Transfer, eGold, moneybookers, other.\"

And that's just ONE of the forms' purpose.

Another form would be for social bookmarking tools, for instance, and it will compare features that that tool (Such as Digg.com) is good for.

I have Five forms right now and I'm offering my members different kinds of bribes to fill them out.

Hope that helps you see it clearly in your mind. It's hard to describe, I know, and it's in a paid members area so It wouldn't be fair to the users to let anyone in to see.

Cheers,
Luke

I would love to see this ability (to edit) added to RSForm.

One thing to note, if you update the database directly, you will lose the formatting of your data because the code in mod_forme_list is using explode on \"\n\" and that gets trashed when you modify #_forme_data.

Yeah Luke, that didn't help. So far it looks like you're just looking to create a simple question form. It doesn't explain what you're trying to do with the data.

As for comparing data, it cannot be done with this component.

It disappoints me that Alex hasn't better described what this component does. It should be this:
That's all that RSForm is.

Dave:

As I understand your comments, individual records in jos_forme_data can not be edited or changed without \"messing up\" how that information is presented in \"View Data\" and that, currently, if that information needed to be changed (for whatever reason) it would have to be done by submitting a new form? Is this correct?

Thanks