How to "autofill" email and address fields for user on form?

[blue-mouse]

Hi,
I have Fabrik 3.0.6.1. and GitHub from 22.08.2012 version.

I try to find an idea how to "autofill" 2 fields on form.

The field1 that "should be observed" is user plugin with label "name" as for example "John Blue":

In Fabrk: edit element (field1) is:
----------------------------------------
Name: customer_name_auto
Label: Our customer name
{myjoomla_customers_comp___customer_name_auto}
Group: CC-8-Customers-Complaint
Plug-in: user (but i try use it as database join to myjoomla_users and is no change with autofill)
User Data: Name

---My Joomla database for users is:
myjoomla_users
and that field is from: myjoomla_users____name


------------------------------------------------
What i need is to add 2 fields with value "email" and "address" for choosen in field1 "user" -"Our customer name" and that field2 and field3 should be mapped to:
myjoomla_users___email
myjoomla_comprofiler___address (field from table of Community Builder 1.8.1)

I need options:
- edit oiginal record - Yes
- autofill on load - Yes
- confirm - No
------------------------------------------------------------------------------------------------------------------
I try to use autofill for one field - field2 -"email" without success:

On Fabrik:edit form --- Plugins - i add "autofill"

Field to observe: "Our customer name"
Trigger -
-------
List - "My Joomla users list1" --- it is my list - i created it especially for that purpose with "autofill".
List - "My Joomla users list1" simply include Joomla database table with Joomla users: myjoomla_users
I created that list becouse my version 3.0.6.1 of Fabrik use "List" not "Database table" like myjoomla_users
--------
Map data -
{"myjoomla_users___email":"myjoomla_customers_comp___customer_email"}

- edit oiginal record - Yes
- autofill on load - Yes
- confirm - No
----------------------------------------

The problem is: nothing new appears on form concerning "autofill plugin".

What can be wrong?

Have you any idea how in other way add automatically field2="email", field3="address" for choosen in field1 "user" (as plug-in user not databasejoin)? ???

 

[blue-mouse]

Hi,
I read Fabrik Tutorial - Category 5 - Forms Plugin - Autofill and i have no idea what to change to autofill work for me? I try autofill for my other list+forms and it is the same - it doesn't work, nothing appears - concerning autofill - on my forms.

What else or different should be set to have working autofill?

Need any help - it is one of my main issue in my fabrik.

 

[rob]

If you were using IE then there was a bug in the code that I fixed today, so first try updating from github to see if that resolves the issue

-Rob

 

[blue-mouse]

I will try to update from github but i have any general problems with autofil.

I use Opera browser on linux to write in joomla + fabrik and to test firstly if things work. I use PC with windows and other browser: firefox and IE8, IE9 - later if things work on my 2 computers with linux + Opera (+ Iceweasel).

 

[blue-mouse]

I didn't update from github yet, so i see i have other subproblems...

I will try to find what i need in 2 steps:

Now is step 1. --- please help me understand or change this:
I have created a test 2 list:

1. Ships : ccjom_cc_tests_ships___
fields:
___id
___ship_name
___ship_type
___ship_colour
___ship_passengers_num

2.Trips: ccjom_cc_tests_trips__
fields:
___id
___passenger
___cruise

___ship_name --- databasejoin to ccjom_cc_tests_ships___ship_name
___ship_type
___ship_colour
___ship_passengers_num

Map data is:

{"ccjom_cc_tests_ships___ship_type":
"ccjom_cc_tests_trips_____ship_type,
"ccjom_cc_tests_ships___ship_colour":
"ccjom_cc_tests_trips__ship_colour,
"ccjom_cc_tests_ships___ship_passengers_num":
"ccjom_cc_tests_trips__ship_passengers_num"}

The autofill works for me under linux and Opera browser but is one problem:

An option: Edit original record
doesn't work in that way what i need.
I can change original fields in Form: "Trips" :
___ship_type
___ship_colour
___ship_passengers_num

but my change are only saved on List with "Trips" not in Original List "Ships".

I need when use an option "Edit original record" to save change not only in record on List "Trips" but also make change in "databasejoined" table ccjom_cc_tests_ships___

How to make that issue?

 

[blue-mouse]

Step 2

I need some more advanced autofill:

observed field:
ccjom_users___name --- Joomla table with users

Mapped fields should be:
ccjom_comprofiler___adress
ccjom_comprofiler___phone
ccjom_comprofiler___cb_companyname1 --- Community Builder v.1.8.1 table with other user parameters,

I check that is "connection/mapping" ---
{"ccjom_users___id"} ={ccjom_comprofiler___users_id}

===========================================================
My problem, when our worker fill in the form:

I have a list, something as "Handling a complaint"
table: ccjom_cc_customers_complaint___
fields:

ccjom_cc_customers_complaint___device_num
ccjom_cc_customers_complaint___device_description
ccjom_cc_customers_complaint___device_damage_description

ccjom_cc_customers_complaint___name --- plugin databasejoin to ccjom_users___name

ccjom_cc_customers_complaint___address --- i am looking how to autofill it
ccjom_cc_customers_complaint___phone --- i am looking how to autofill it
ccjom_cc_customers_complaint___cb_companyname1 --- i am looking how to autofill it

---------------------------------------------------------------------------------------------------------------------------------

My problem, when our customer fill in the form:

I have a list, something as "Handling a complaint"
table: ccjom_cc_customers_complaint___
fields:

ccjom_cc_customers_complaint___device_num
ccjom_cc_customers_complaint___device_description
ccjom_cc_customers_complaint___device_damage_description

ccjom_cc_customers_complaint___name --- plugin user, options: User Data: name ( and this is from table/field ccjom_users___name)

ccjom_cc_customers_complaint___address --- i am looking how to autofill it
ccjom_cc_customers_complaint___phone --- i am looking how to autofill it
ccjom_cc_customers_complaint___cb_companyname1 --- i am looking how to autofill it
----------------------------------------------------------------------------------------------------------------------------------

Please, any draft of idea "how to make this advanced autofill" - so i am to small advanced with Fabrik and php coding to see the way to solve it,

 

[blue-mouse]

Summary:
In this moment i can autofill "email"
I have still problem how to "autofill or something like that" from table of Community Builder - i need: address, phone and companyname (own field in CB).

Very please any advice.

 

[rob]

Map data is:
Code:
{"ccjom_cc_tests_ships___ship_type": "ccjom_cc_tests_trips_____ship_type, "ccjom_cc_tests_ships___ship_colour": "ccjom_cc_tests_trips__ship_colour, "ccjom_cc_tests_ships___ship_passengers_num": "ccjom_cc_tests_trips__ship_passengers_num"}

you are missing quotes off the end of lots of these strings, might this be the problem?