Custom Field (SQL)

  • Claus Lohmar
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 days ago - 8 years 2 days ago #80463 by Claus Lohmar
Custom Field (SQL) was created by Claus Lohmar
I'm over-howling a older project that actually never got live with the previous owner.
Therefore I use an outdated Version of Membership Pro (2.0.0) but I plan to update in 2 Weeks
(PayDay) ;)
It looks like that we can use Custom Field List with an SQL Query.
I was using Easy Profile for this, but since Membership Pro does nearly all the same and even more, I would like to use Membership Pro for Custom Field Lists.

I was unable to find any help on how to use the Custom Field with SQL.
Maybe I did not look in the right places, so my question - how to use Custom List Field with data from SQL?

Thank you for this grat Extension!
Claus
Last edit: 8 years 2 days ago by Claus Lohmar.

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
8 years 2 days ago #80466 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Custom Field (SQL)
Hi Claus

Please see membershipprodoc.joomservices.com/basic-...m-fields/field-types (look at item #12 on that page to see how to use SQL custom field type)

Tuan

Please Log in or Create an account to join the conversation.

  • Claus Lohmar
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 days ago #80468 by Claus Lohmar
Replied by Claus Lohmar on topic Custom Field (SQL)
Thanks Tuan,
I knew I was not looking in the right direction. ;)

The SQL command needs to be entered into Default Values property of the field


That was the info I needed.
Thanks again and if I can be of help (PayPal) just contact me.

Please Log in or Create an account to join the conversation.

  • Tuan Pham Ngoc
  • Away
  • Administrator
  • Administrator
More
8 years 2 days ago #80469 by Tuan Pham Ngoc
Replied by Tuan Pham Ngoc on topic Custom Field (SQL)
Great to know that you are engineer from PayPal. I will contact you for your help if needed.

Tuan

Please Log in or Create an account to join the conversation.

  • Claus Lohmar
  • Topic Author
  • Offline
  • New Member
  • New Member
More
8 years 2 days ago #80472 by Claus Lohmar
Replied by Claus Lohmar on topic Custom Field (SQL)
Your welcome.

Please Log in or Create an account to join the conversation.