How to auto-populate a field?
create a user-user data field called "department" with a validation of "KNTA-Department-Enabled"
give it a token called "DEPT"
the column relating to this token is USER_DATA1
create a rule called "Auto-fill_dept"
the sql behind the rule will be:
SELECT USER_DATA1, VISIBLE_USER_DATA1
FROM KNTA_USERS
WHERE USER_ID = [SYS.USER_ID]
The results will be:
[REQ.DEPARTMENT_CODE] and [REQ.DEPARTMENT_NAME]
give it a token called "DEPT"
the column relating to this token is USER_DATA1
create a rule called "Auto-fill_dept"
the sql behind the rule will be:
SELECT USER_DATA1, VISIBLE_USER_DATA1
FROM KNTA_USERS
WHERE USER_ID = [SYS.USER_ID]
The results will be:
[REQ.DEPARTMENT_CODE] and [REQ.DEPARTMENT_NAME]
0 Comments:
Post a Comment
<< Home