Forums

I created a registration form with the 'Joomla registration' plugin in ChronosForms because I needed some additional fields to the standard Joomla registration info. I created a table and linked it to my registration form.

Now I'm working on figuring out how to edit records in the back and the frond using ChronoConnectivity.

I've got a long way to learn the stuff to accomplish this but I stumbled on an issue I can not seem to find an answer to in this forum.

Correct me if I'm wrong. All registration info including the basic Joomla registration (name, username, password, email) is stored in table I made with ChronosForms. The basic Joomla registration info is also stored in the Jos_users table.

Now I can edit this 'basic Joomla registration' in my ChronosForms table but then it will be different then the info in the Jos_users table.

Is there a way to make changes to field who are in those two tables being edited at the same time so this 'basic Joomla registration info' remains the same in both tables?

it could also be possible I'm approaching this issue from the wrong angle ;-)

Hi mackirony,

Correct, this is the issue, the 2 tables are different and NOT connected, the solution need to be done in 2 ways:

#1- creating a Joomla plugin which will reflect any Jos user changes to the Chronoforms table!
#2- adding the necessary code in Connectivity to reflect changes to the Jos Users table!

I never done this myself but they are doable!😑

Regards,
Max

Thanks for your swift reply Max

To bad that is an issue. I've been looking for some time to be able to have some extra registration fields. Up until now I've been using 'Community builder' only for the extra field functionality witch is a bit over the top since it is such a large component. A bit to my surprise there seems to be no component who handles only extra registration fields and since I'm al already using ChronosForms on my website I was under the impression, when combining it with Connectivity, I finally found a slicker solution.

I'm sorry I can not help you with the coding but I'm looking forward to testing what you come up with and providing some feedback if necessary ;-)

No problems, I understand, I will work to get this done myself but when I have some time to do it, I have been extremely busy the last 3 weeks!

Regards,
Max

Hi Max,

Any progress on this issue with the new versions?

Hi mackirony,

I think that the new version is getting the final polish right now - should be out in a few days.

Bob

Thanks Bob,

Will this new update also take care of the two tables not being connected (as described above)?

Hi mackirony,

I expect so but I haven't seen it so can't confirm.

Bob

I've been trying to figure out if this issue is solvable with the new ChronoForms_V3.1_RC5.1 and the Profile Page Plugin. I found a lot of info about populating field from a database on these forums so I got that working (unlike having some pull down menu's jump to the right selection but that's a different issue).

I made a "View/Edit my profile" form and connected the "Profile page plugin" to it. The plugin pulls the data from the database I made with Chronoforms that hold user data but I'm not able to update user data with "Editable" checked in the plugin's "Configure" tap.

Maybe I'm going the wrong way but before I go on searching and posting. Is the issue described in my first post solvable with ChronoForms_V3.1_RC5.1 and the "Profile Page Plugin", or the new ChronoConnectivity_V2_RC1?

Hi mackirony,

I believe that if your form has the profile plugin enabled and "editable" is set to yes and the table selected is jos_users and your form has fields names with the same table column names then the form should get loaded with the record data loaded, assuming you configured the plugin correctly!

Regards
Max

if im reading this correctly, the Profile page plugin will load data from a table into a form. What Ive been finding is that it submits a new record every time you use that form, even if its intended for editing that information. Does anyone have thoughts on how to use the Profile page plugin to edit data once its loaded into the form?

Hi phoe2693,

Provided that the entry for the Target Field Name is a Primary Key for the table the record should update if a matching key is found (this is generally true for Chronoforms, the autogenerated code will update an exisiting record if the keys values match, add a new one if they don't).

Bob

Hi Bob,

thats definitely not what Im seeing. Primary key is set, data loads up on the page correctly. However, any editing of the existing information or filling out fields that were blank results in a new entry being generated, every time (if I take away the uniqueness restriction on the primary key... when its there, no changes happen after the first input). Ive been wrestling with getting the edit to work now for a while with no success. Doublechecked the settings, target field that is being referenced, form labels,...

Hi phoe2693,

Provided that the entry for the Target Field Name is a Primary Key for the table the record should update if a matching key is found (this is generally true for Chronoforms, the autogenerated code will update an exisitign record if the keys values match, add a new one if they don't).

Bob

Same problem here, help please.

Hi sidus,

What problem exactly?

Bob

Hi Bob,

Set up the profiles plugin. Wish to link to the cf_user_id field. Do I need to include a hidden field on the form for this value??? Maybe I try first now that I think of it. Will let you know.

SOLVED - Added a hidden field on the form for 'cf_id' and it worked. Updates the record and not create a new one.

Just needed to write the query down to think about it I guess.

Cheers
Jamie