Please read and follow the COMMON ISSUES first!
Always add your version information in every new post! Thank you!

Form2Content Forum

Questions and answers for Form2Content, a Joomla CCK.
  1. Lukas Oertli
  2. F2C field types
  3. Tuesday, January 19 2016, 07:23 AM
  4.  Subscribe via email
Hello.

I use a database lookup field to display member names as dropdown list. its working fine but in the article, it shows me the id and not the name of the member. (see the attachments)

Thanks for help.

Joomla: 3.4.8
F2C: Pro version 6.11.0
Attachments (3)
Accepted Answer
Stephen Shorter Accepted Answer
Hi I have a similar db lookup in my Form2Content application and I "think" if you change your Query to"

select name from #__personal_personals where abteilung = 'A/Gyn + Woch.'

Again no expert but by using "id,name" you are selecting id but displaying name in the lookup.

Try it, if it doesn't work nothing lost and my apologies if it does then great.

Cheers Shooter.
  1. more than a month ago
  2. F2C field types
  3. # Permalink
Responses (3)
Lukas Oertli Accepted Answer
PERFECT! Thank you;) The id is only needed by "Database Lookup" with (Multi Select).
  1. more than a month ago
  2. F2C field types
  3. # 1
Gilles Testard Accepted Answer
Hello, i am on a similar question with a single select datase look up (get id but not title), but not working at the moment for me
  1. more than a month ago
  2. F2C field types
  3. # 2
Gilles Testard Accepted Answer
And now, i have tried my adding a field database look up multi select and works fine, thank you
  1. more than a month ago
  2. F2C field types
  3. # 3
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.