Filter in Dropdown Custom Field

[janssenf]

Hi,

in one of my tables PERSONALCOACH in my database I have the following 2 fields:

• fldEmail
  
• fldStillActive
  

What code should I create in a Custom Field (type: dropbox) which filters out all records which match the email field of the Account table with mentioned PERSONALCOACH.fldEmail AND where PERSONALCOACH.fldStillActive = TRUE?

Thanks for your help.

[janssenf]

Hi,

maybe more in general: what Smarty code should I use to put the value of column FIELD1 from table TABLE1 into VARIABLE1? I'm struggling with extracting a field value into a variable.

Thanks, Freek

Hi,

in one of my tables PERSONALCOACH in my database I have the following 2 fields:

• fldEmail
  
• fldStillActive
  

What code should I create in a Custom Field (type: dropbox) which filters out all records which match the email field of the Account table with mentioned PERSONALCOACH.fldEmail AND where PERSONALCOACH.fldStillActive = TRUE?

Thanks for your help.

[andy_12-12]

Hi,

maybe more in general: what Smarty code should I use to put the value of column FIELD1 from table TABLE1 into VARIABLE1? I'm struggling with extracting a field value into a variable.

Thanks, Freek

Hi,

in one of my tables PERSONALCOACH in my database I have the following 2 fields:

• fldEmail
  
• fldStillActive
  

What code should I create in a Custom Field (type: dropbox) which filters out all records which match the email field of the Account table with mentioned PERSONALCOACH.fldEmail AND where PERSONALCOACH.fldStillActive = TRUE?

Thanks for your help.

Sorry, I can't help but also trying to find an answer to this!

[zeeshan002]

What code should I create in a Custom Field (type: dropbox) which filters out all records which match the email field of the Account table with mentioned PERSONALCOACH.fldEmail AND where PERSONALCOACH.fldStillActive = TRUE?