First of all, thank you xnau for an awesome plugin! Really top notch job.
I HAVE read through all of the postings here, and I DO realize that it is not possible to have multiple databases at the moment (maybe in the next version?), so I get that. I did want to see if there was a workaround for my particular problem, however. Hence this posting. Hopefully you'll have some creative ideas for me, as I'm open to wide range of suggestions in order to make this work using this plugin.
The scenario is that I have a site for signing up kids at a Science Fair. There needs to be three sign up forms (student, parent, coach). Each form has a different set of questions on it. Knowing that there is no way to run multiple databases, my original idea was to create a single sign-up form with just a couple pieces of common information (name, email, phone) and then collect the rest later. That didn't work out so well because the pdb_record page got very confusing. :-)
My next idea was to add three sign up forms with the common information, and then add the hidden field (post->post_title). This seemed to work better, in that I now have three nice separate forms, and I can differentiate where they signed up.
That gets me part of the way, but now I start to bog down on how to separate out these three constituencies. They each have some common information (about 5-6 fields), but then they diverge quickly. For example, the student form has four additional questions about events and past history. The parent form has 7-8 questions about emergency contact information and indemnification. The coach form has five questions about schedule and time availability.
When users get sent to the pdb_record page, there is no way to distinguish which section they should fill out. Especially if they don't read my instructions. ;-) The students fill out some parts and ignore others. The parents completely skip other sections. Required fields don't work because they're only required in CONTEXT of the person filling out the form, so I can't force people to fill out some information.
Ideally I'd like the ability to use shortcodes such as [pdb_record group=parent] for one, [pdb_record group=coach,common], etc.., to decide which group of questions should be displayed for that user on that page. ID numbers would be fine too.
This could also be extended to [pdb_signup group=student], for example. This would also give me the ability to create separate sign up pages without having to resort to the hidden field approach. Or even, if the two shortcodes could just take a list of comma separated fields numbers -- that would be acceptable too.
As it stands right now, I'm stuck with one GIANT long page of about 40 questions, divided into three big sections. I have to rely on each group only filling out their section, and doing so perfectly each time. I can't use required fields, so I have to trust them that they will fill out what is needed in each case.
Is there any other solution out there? Again, I'm open to any suggestions, including if you have some code patches that I could make (I'm a PHP developer, but prefer not to modify plugins unless absolutely necessary).