Forums

OK, I am brand new here, and also as user of Chronoforms.

I make some try-outs, using the tutorials, and this works well.
At the moment I have changed the registration form, and all the information is in jos_users.
yeah, so far !

Now I will have more information of the users. Something like 'address' and 'city'. So, I create a new form, at the top the user see his name and email-address. (This information comes from jos_users. Then below the 2 extra fields 'address' and 'city'.

So, the user can change here only the 2 additional fields, who are in a new table.

Now, in this table, I will see also a field with the name and email, so that if I will export to an XLS-file, it is not only an ID-number....

1. is that possible, and what if for example the email-address is changed, will this also be saved in this table ?

2. How can I display in this new form, the information of the field address and city, if this is always known. (can I put information on screen from more then one table ?)

I hope this explanation is enough (sorry for the language-mistakes if they are there)


Txs in advance for the help.

Hi LucVG,

I'm glad you managed to make some good progress, what you are trying to do is possible but you will have to write some code for it which may include SQL Join to get the data from the 2 tables, updating the email in one table will not be reflected to the other one, and to make this work it will need some amount of work or even core hacks to Joomla (Joomla applies these limitations)

if you have some time for this project then you may wait for J1.6 which I read some where that it "may" support this OR wait for our new product which "will" support this kind of operations, but its not ready yet, not before 3 more weeks I guess..

Regards,
Max

.... new product .... 3 weeks .... sounds very, very good.
No problem to wait for this.

About J1.6, this has no date for the mùoment. I have seen that there are a lot of possibilities, but I guess that a lot of people will wait for a stable version. I have seen the tests and worked with frontend and backend.

In the mean time, I see what I can do to use the information of 2 tables in one new form.