Field select user

erica
Topic Author
Offline
Senior Member

7 years 5 months ago - 7 years 5 months ago #68218 by erica

Field select user was created by erica

Hello,
In my form, I want to add a select field in order to select one or more user which is registered in flexicontent user (local/administrator/index.php?option=com_flexicontent&view=users).
I know the select field but I don't know how to link to an user.
Thank you for your help.

Last edit: 7 years 5 months ago by ggppdk.

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

ggppdk
Offline
Administrator

7 years 5 months ago #68221 by ggppdk

Replied by ggppdk on topic Field select user

Hello

1. Create a select or multi-select flexicontent field
2. Enable SQL mode
3. Enter sql query:

Code:

SELECT id AS value, username AS text FROM #__users

Code:

SELECT id AS value, name AS text FROM #__users

Code:

SELECT id AS value, CONCAT(name, " [", username, "]") AS text FROM #__users

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

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