-
New Commercial Services Section
We have now opened a commercial services section here on the forum for registered users. If you have a Fabrik project that you wish to have someone work on for you, post it under Help Wanted. If you are an application developer and wish to earn some money helping others, post your details under Fabrik Application Developers.
Both of these are unmoderated. It will be up to both parties to work out the details and come to an agreement.
-
Joomla 5.1
For running J!5.1 you must https://fabrikar.com/forums/index.php?wiki/update-from-github/ or include the new file manually https://fabrikar.com/forums/index.php?threads/joomla-5-1-and-fabrik-cannot-find-files-error.54473/post-285151 See also Announcements
Fabrik autofill plugin - How to? - Round 2 ^^
- Thread starter laztech
- Start date
Here is my newest attempt. I have cleared out the other lists and started over with this. I have created a list titled Community Builder. This list connects to database "jaig1_comprofiler_fields" with the key: "name".
I then have the settings as shown in the image on the plugin
Still nothing in the field.
I then have the settings as shown in the image on the plugin
Still nothing in the field.
Attachments
rob
Administrator
ok so there was a bug in the way we were loading js classes for form plugins which i have now fixed.
However, if I have understood correctly, the autofill plugin set up is not right for what you want to achieve.
It seems to me from the settings you have set in the plugin that you want to do a search on some kind of joined data set between jaig1_comprofiler_fields and jaig1_comprofiler_field_values which is the table that contains the actual values for the fields defined in jaig1_comprofiler_fields?
I think what you will need to do is to create a mySQL view to create a single view of the custom defined fields AND their values.
You then might be able to point the autofill plugin at that mySQL view to get the correct data set.
However, if I have understood correctly, the autofill plugin set up is not right for what you want to achieve.
It seems to me from the settings you have set in the plugin that you want to do a search on some kind of joined data set between jaig1_comprofiler_fields and jaig1_comprofiler_field_values which is the table that contains the actual values for the fields defined in jaig1_comprofiler_fields?
I think what you will need to do is to create a mySQL view to create a single view of the custom defined fields AND their values.
You then might be able to point the autofill plugin at that mySQL view to get the correct data set.
I can honestly say I have no idea how to do that 
What I want to do, is simply pull the data from the currently logged in user's fields and place it into the personal info on the quote page.
I'm using jaig1_comprofiler_fields because I thought that is where the current logged in user data is stored, I honestly can't verify that and if it is not where the data is, I can't figure out for the life of me where it actually is.
It's using comprofiler because I'm using community builder to have additional customized fields in user profiles. If there is an easier way to do this, I would highly appreciate help in that direction.
What I want to do, is simply pull the data from the currently logged in user's fields and place it into the personal info on the quote page.
I'm using jaig1_comprofiler_fields because I thought that is where the current logged in user data is stored, I honestly can't verify that and if it is not where the data is, I can't figure out for the life of me where it actually is.
It's using comprofiler because I'm using community builder to have additional customized fields in user profiles. If there is an easier way to do this, I would highly appreciate help in that direction.
rob
Administrator
ok I re-installed community builder, created some custom fields and modified some users, and in fact the data is stored in the db table #__comprofiler, so you should link to that in the autofill plugin, not jaig1_comprofiler_fields.
No need to create a view as I previously thought.
-Rob
No need to create a view as I previously thought.
-Rob
Alright, we're a step much closer, now can you show me an example of how to do this like you did on the first page, only this time using the comprofiler? I've been trying different settings with this new location but to no avail.
Sorry for my inept abilities on this subject, this autofill plugin seems to have become the bane of my existence
Sorry for my inept abilities on this subject, this autofill plugin seems to have become the bane of my existence
rob
Administrator
http://screencast.com/t/Mc1sWQYQs
Works for me
I have the list 'Community builder' which points at the db table #__comprofiler
I have a user element called 'user' where the person filling out the form selects the user.
I have the mapping so that the look up is done on the user id in #__comprofiler and the returned data set will update the last name field
Works for me
I have the list 'Community builder' which points at the db table #__comprofiler
I have a user element called 'user' where the person filling out the form selects the user.
I have the mapping so that the look up is done on the user id in #__comprofiler and the returned data set will update the last name field
rob
Administrator
I don't think you do
You should first write down in plain English what it is you need to achieve, to clarify things for yourself.
e.g.
* when the user enters data in [field to observe]
* query the fabrik list
[listname]
* get the first record where [lookup field] = [field to observe's value]
* If a record is found then update the form with the map data field:
e.g. to insert the community build company value, into the quotes company field:
{"jaig1_comprofiler___company":"quotes_listed___company"}
I've altered your form so that it works, if you enter a client name as 'Greniewicki' - it will look up that and match against the community builder last name.
However! Really you should be doing look ups on id values, hence why in my previous post I said i had a user plugin (which stores the user ID) as my 'Field to observe' T
If selection was not appropriate, then you could hide the user element and set the autofill plugin to 'autofill on load': yes - to automatically map the users data into the form.
You should first write down in plain English what it is you need to achieve, to clarify things for yourself.
e.g.
* when the user enters data in [field to observe]
* query the fabrik list
[listname]
* get the first record where [lookup field] = [field to observe's value]
* If a record is found then update the form with the map data field:
e.g. to insert the community build company value, into the quotes company field:
{"jaig1_comprofiler___company":"quotes_listed___company"}
I've altered your form so that it works, if you enter a client name as 'Greniewicki' - it will look up that and match against the community builder last name.
However! Really you should be doing look ups on id values, hence why in my previous post I said i had a user plugin (which stores the user ID) as my 'Field to observe' T
If selection was not appropriate, then you could hide the user element and set the autofill plugin to 'autofill on load': yes - to automatically map the users data into the form.
I want it to automatically load the user's information into the contact portion of the form as soon as they open the quote page without filling in any data. It sounds like that is what your saying in the bottom of your response.
Example:
User registers on site. Fills in their contact information, name, address, phone number, company name when they register their account.
This information is now saved to their user profile.
This user logs in and clicks on "request a quote"
The quote page loads and all of the user's contact information is already filled in without the user typing anything.
All the user has to do now is fill out the mailing services portion of the form.
Example:
User registers on site. Fills in their contact information, name, address, phone number, company name when they register their account.
This information is now saved to their user profile.
This user logs in and clicks on "request a quote"
The quote page loads and all of the user's contact information is already filled in without the user typing anything.
All the user has to do now is fill out the mailing services portion of the form.