- Forums
- Support and Presales
- Professional Members Support
- Query Drop Down value substitution in an email
Query Drop Down value substitution in an email
- softforge
- OFFLINE
-
Elite Member
- Posts: 193
- Thanks: 20
- Karma: 12
6 years 4 months ago #300030
by softforge
If you like our plugins, please consider writing a review on the Joomla Extension Directory or the Community Builder Directory ...
Query Drop Down value substitution in an email was created by softforge
Hi, I have a Query Drop Down which connects to a table of ids and areas.
The id is stored and is what is returned if the field is brought back in an autoaction email action body.
Is there a way to do a database lookup in an auto action so I can turn the value returned from the id to the value.
The id is stored and is what is returned if the field is brought back in an autoaction email action body.
Is there a way to do a database lookup in an auto action so I can turn the value returned from the id to the value.
If you like our plugins, please consider writing a review on the Joomla Extension Directory or the Community Builder Directory ...
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68492
- Thanks: 9080
- Karma: 1434
6 years 4 months ago #300063
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Query Drop Down value substitution in an email
If using [FIELD_NAME] substitution you'll always see the raw stored value. For the displayed value be sure to use [cb:userfield field="FIELD_NAME" /] substitutions. Note [cb:userfield field="FIELD_NAME" /] substitutions are subject to access permissions and the field also needs to be set to display on profile (it can be on a tab in a not shown on profile position though).
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
Moderators: beat, nant, krileon
- Forums
- Support and Presales
- Professional Members Support
- Query Drop Down value substitution in an email
Time to create page: 0.267 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Professional Members Support
- Query Drop Down value substitution in an email