×
Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues
Autofill of fields with previously entered information
Dan Crivat
New Member
Posts: 2
3 years 1 month ago #9914
by Dan Crivat
Autofill of fields with previously entered information was created by Dan Crivat
Hello,
My name is Cristian and I am working on a new software using Joomla 4 and Component Creator. This software - IDX-BB - is a CRM for selling and buying businesses. Businesses for sale and business buyers and all necessary details needed in a transaction are introduced in the CRM by different level users.
My main problem is that I need a technical solution to be able to autofill some fields with data previously entered into the CRM by the users. For example, if the name of the business for sale has been introduced once, in its respective field, then I need that value (the name of the business) to be filled in automatically in any other fields that request it, regardless of their “location” in the CRM.
More precisely, the name of the business is introduced in the first section, called Business Information, but then it needs to be filled in in other sections of the CRM as well, such as the Offer, Contract, Non-Disclosure Agreement, etc.. I would like that this operation is conducted automatically and not manually. This means that the user would only need to input information only once.
If you need any additional information, please let me know.
Thank you,
Cristian
My name is Cristian and I am working on a new software using Joomla 4 and Component Creator. This software - IDX-BB - is a CRM for selling and buying businesses. Businesses for sale and business buyers and all necessary details needed in a transaction are introduced in the CRM by different level users.
My main problem is that I need a technical solution to be able to autofill some fields with data previously entered into the CRM by the users. For example, if the name of the business for sale has been introduced once, in its respective field, then I need that value (the name of the business) to be filled in automatically in any other fields that request it, regardless of their “location” in the CRM.
More precisely, the name of the business is introduced in the first section, called Business Information, but then it needs to be filled in in other sections of the CRM as well, such as the Offer, Contract, Non-Disclosure Agreement, etc.. I would like that this operation is conducted automatically and not manually. This means that the user would only need to input information only once.
If you need any additional information, please let me know.
Thank you,
Cristian
Please Log in or Create an account to join the conversation.
Ryan Minnig
New Member
Posts: 10
3 years 1 month ago #9917
by Ryan Minnig
Replied by Ryan Minnig on topic Autofill of fields with previously entered information
I believe you can do this with an 'SQL field' in one of your forms that would allow you to query the database to give the user an option to choose the returned results form the query. When adding a new field to your form, you can choose the 'SQL field' to return results from a query. I'm working on the same thing now and have had success with returning 1 column, but trouble returning the results from 2 columns concatenated together.
Please Log in or Create an account to join the conversation.
Time to create page: 0.049 seconds