Hi Kyle,

I have tried using the Query field from the 5 query options. It is also using CB Conditional.

The Dropdown works as expected. The query field just does not display in the registration form at all at all. I have left the query field in place - cb_pcn. This is after I deleted the text field as one forum post showed that a new field worked where the edited field didn't.

I have added you as a Super User - see secure part of post.



I know it is likely to be an error on my behalf but in my defence the instructions on the plugin are a bit vague.

Many thanks
David

Hi Kyle,

As with most database driven membership schemes we need to keep data integrity. We want to make registration simple for the user but we still need all the data added to their profile. Most users will have no idea of their NHS locality, neighbourhood, or PCN (Practice Code Number) so we wanted to automate that. It made sense to have this happen at registration. The thought process was based on the US State, County, Town, ZIP example in the tutorials.

We have the full table already in-situ and my intention was that as they chose their main place of work as GP Practice, the registration would display the appropriate fields starting with Practice Name. Once selected the Query plugin would populate the remaining fields. So are you saying that even though the Practice Name is selected the subsequent query cannot access that field? This is not what I have seen with US states example.

Having the data added at registration would then show in their profile so users would start to recognise the data that they currently do not know. The data is also required for administrators as it will be used for training records, invoices and other administrative tasks.

If you are saying that registration is not the place to do that, then I guess we will have to look at CB Auto Actions populating the fields but not sure how that would work to determine the correct values associated with the Practice Name in the #__practices table.

To me this seems like a simple way of ensuring data is in a profile but without relying on each member of staff knowing data about the practice that they themselves would not normally use.

Does this make any more sense?

Many thanks
David

Hi Kyle,

Thanks for the definitions. I need data to be stored as RSForms and RSEvents will need to use the data for course bookings and certificate generation.

I think I will have to look at using the other field types or consider CB Auto Actions to populate fields on triggers such as saving registration or changing profile etc.

Thanks for persisting with my descritions.

Cheers for now
David