Hi all,

I want to get values from an entry in one form, probably into variables, and then use those variables to populate a new entry in a second form.

I was pretty sure that there is an article in this sites documentation, but I cant find it.

Any help would be appreciated.

Cheers

This?

Display info from different form

or the method that superceded it

Pass parameter in url

I think it was the first link,

Not sure if it will work though. Here's the scenario

I'm building website for dog training. The member applies to join the organization to train their own dog by filling out a form. This form is the Joomla registration form also. Once accepted. The trainers will be able to see the data from that form.

In the trainers area there will be notes on the dog and the owner. SO i need the info from the first form; member id, first and last name, and t he dogs name to auto populate the new form. so the trainer just has to make the notes and submit the entry. I should be able to do the rest through the directory links.

I think the first link might do it but Its not clear what their "First form" or the "Second Form". I'm guessing the 'hash' field has to go into the application form so it can be called upon.

The trick however is making sure I get the right member id out of the many in the table.

Are you giving each member a unique Id on registration?
Either way sounds like you need a form where the trainer enters the members Id and pass that to another from in the URL then using that Id in that form 'select * where MemberId ='xyz' is that about right.
Never tried that from the Rsform submissions tables but does work as I have a seperate club membership database that works exactly like that to save anyone having to fill a form out on membership renewal

Yes, I use the Joomla userid number as the member id.
The members application form is the joomla registration form and carries the userid. This is the main form with all of the data we need to access. So for example, and to squeeze your brain for a little more info. The application / registration for has, among other things, the fields,
member id, first name, last name, dog's name. These are the four fields that I'm looking to transfer. Lets call the form 'application' for this purpose

Now, the trainers can access this data through the submission forms, but I think getting the data through this layout, being the display submission feature for rsForms, is a little too difficult, for me at least.

Basically I need to be able to grab a members id and field data from the trainers selecting from a submission list. That one is beyond me.

Just been playing with your scenario using the registration form, finding it an absolute pain to be honest. I would create a separate database table for the data, it becomes much easier to retrieve and prefill a form for trainers to add notes then.
Do your applicants need to have a registered user account? It's quite easy in a straightforward application form to assign a membership number which can be used to retrieve their data by your trainers.
At what point is a particular trainer assigned to a user and how is it determined which trainer it will be and how many are there? I'm asking because when you retrieve the data for a particular owner/dog you could use conditional fields to only show notes from each only

Mocked up the basics here using three forms and a table added to the Joomla database, for anything bigger or more complex you could use a separate database

Form 1 is the intial application - randomly generated membership number and data mapped to new table in database on submit
Form 2 enter the users surname and membership number
Form 3 displays the returned data from form 2

Ooops! forgot to put the site back online - works now