- This topic has 1 reply, 2 voices, and was last updated 8 years, 10 months ago by
.
-
Posts
-
Hello,
I have version v9.0.9 of Wp emember. I have also installed a plugin ‘Calculated fields form version 10.0.246’
What I require is some of the data that emember collects when subscribers fill out their registration form for emember, to pre-fill out a form i have created in the Calculated field form plugin.
What I am Currently doing with-out the desired result:
In Calculated forms,
1. Drag and dropping a ‘line text DS field’ (line text data source) onto my form
2. It then requires me to define a data source
3. I select ‘Database’
4. The next 3 fields i leave blank (Host, username,Password)
5. The 4th field i type in emember
6. I then hit test connection
7. A pop up message from word press says connection ok
8. I then select ‘custom query’
9. I then type the following code into custom query feild
10. SELECT meta_value as value FROM wp_usermeta WHERE meta_key=’last_name’ AND user_id=<%fieldname1%>
11. I hit test query and the following message pops up ‘Your query includes variables, so it cannot be tested from the form’s edition’
12. So i delete some of the code back to the ‘ after name, and hit test query again, i then get the following message
Array
(
[0]=>Array
(
[value]=>
)
[1]=>
(
[value]=>Aylward2
)
)
12. This is a WordPress last Name Aylward2 which I put in to identify where i am getting the data from.
so I dont even think i am getting data from emember, the data I am after to pre-fill my calculated forms are ‘last name, first name and company’please help. Kind regards
This will have to be done as a custom job. You can use the following page to get in touch:
- You must be logged in to reply to this topic.