[H3Dott]

I have a dropdown in dynaform that wants to show [first name + space + last name} from USERS Table. for example: Jon Tomasson. I want the next task will be assigned to this user.
Can I do this with sql Property in dynaform?
and Can I do this with place a Trigger before dynaform?

[H3Dott]

I have a dropdown in dynaform that wants to show [first name + space + last name} from USERS Table. for example: Jon Tomasson. I want the next task will be assigned to this user.
Can I do this with sql Property in dynaform?
and Can I do this with place a Trigger before dynaform?

I insert the following code in sql Property but don't show any things. (this code work in PHPMyAdmin database)
SELECT concat(column1, ' ' , column2) from table_name

[H3Dott]

I have a dropdown in dynaform that wants to show [first name + space + last name} from USERS Table. for example: Jon Tomasson. I want the next task will be assigned to this user.
Can I do this with sql Property in dynaform?
and Can I do this with place a Trigger before dynaform?

I insert the following code in sql Property but don't show any things. (this code work in PHPMyAdmin database)
SELECT concat(column1, ' ' , column2) from table_name

The problem was solved with this code
SELECT id, concat(column1, ' ' , column2) from table_name

[kirkwg]

Dropdown's structure is key/value pair. A list of Values will be shown when clicking the dropdown. But the Key is selected based on its value. So usually for SQL property will be like that:

SELECT surname, surname FROM <table-name>; or
SELECT concat(firstname,' ', surname), concat(firstname,' ', surname) FROM <table-name>; or
SELECT companyNo, concat(companyNo, ' - ', companyName) FROM <table-name>