Create a PM Table (or a Table in your external database) which is named USER_OPTIONS and has the following fields:
ID (int, autoincrement, primary key)
Add records to the the table that contain th options that you want for each user in FIELD1 and FIELD2.
Then create a Dynaform which has the following fields:
* Textbox with the ID and variable "currentUsername"
* Dropdown with ID "selectField1" which has the following SQL query:
SELECT FIELD1, FIELD1 FROM PMT_USER_OPTIONS WHERE [email protected]@currentUser
* Dropdown with ID "selectField2" which has the following SQL query:
SELECT FIELD2, FIELD2 FROM PMT_USER_OPTIONS WHERE [email protected]@currentUser
Then create the following trigger:
@@currentUsername = @@USR_USERNAME;
Set this trigger to fire before the above Dynaform.
https://wiki.processmaker.com/3.2/DynaF ... SQL_Format
Amos B. Batto ♦ ProcessMaker Forum Manager since 2009