Hi,
Im currently trying to create a simple invoicing application for my small business. I have enabled the user_profiles plugin in Joomla so each user has their address stored in the joomla database.
Ive created a list called invoices and in that list I have a database join called invoices___client_name, this is a drop down which selects a user from the registered joomla users and stores their ID, in this example Im using John Smith who has a Joomla ID 81. Ive then created a field called invoices___address_1 which I would like to autofill with the address1 data stored by Joomla when I select the client name from the dropdown.
Ive installed the autofill plugin and watched the tutorial but after several days Im getting nowhere. Im not too good with SQL but keen to learn. Can anybody advise me on the best way to do this task and I can then adapt it for the rest of my form.
Ive attached a picture of the structure of the user profile table in Joomla if it helps.
Thanks in advance for any assistance.
Im currently trying to create a simple invoicing application for my small business. I have enabled the user_profiles plugin in Joomla so each user has their address stored in the joomla database.
Ive created a list called invoices and in that list I have a database join called invoices___client_name, this is a drop down which selects a user from the registered joomla users and stores their ID, in this example Im using John Smith who has a Joomla ID 81. Ive then created a field called invoices___address_1 which I would like to autofill with the address1 data stored by Joomla when I select the client name from the dropdown.
Ive installed the autofill plugin and watched the tutorial but after several days Im getting nowhere. Im not too good with SQL but keen to learn. Can anybody advise me on the best way to do this task and I can then adapt it for the rest of my form.
Ive attached a picture of the structure of the user profile table in Joomla if it helps.
Thanks in advance for any assistance.