Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
13 replies
Subscribers
7 subscribers
Views
2703 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I’m trying to build an editable grid that will allow a user to create a team fro
judym598
Certified Senior Developer
over 8 years ago
I’m trying to build an editable grid that will allow a user to create a team from a list of employees.
The Main screen has read only data at the top and my intent is to have an editable grid below this data that basically consists of 3 dropdown fields.
• 1st dropdown would be a list of available employees (I’m using a query rule to get all active users from a view and used an expression rule to format the data that displays in the dropdown [i.e., lastname, firstname, # teams (they already are a member of)])
• 2nd dropdown is a list of all roles associated with the team. The user would select one of these.
• 3rd dropdown will be a list of assignments. This should be a multiple select dropdown based on the areas of expertise associated with the selected user. In other words. If ‘Smith, Mary’ was selected for the role of ‘Project Lead’, she could be assigned to multiple tasks based on what her user record indicates are her areas of exp...
ips_assignUserRolesMain.txt
OriginalPostID-170338
OriginalPostID-170338
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 8 years ago
@judym Please rectify the 'value' of 'Employee Role' dropdown in rule!ips_assignUserRolesGrid() as follows and do let me know if there are any other issues:
\ t
value: if(rule!APN_isEmpty(ri!newTeamLink_cdt[ri!index]),null,if(rule!APN_isBlank(ri!newTeamLink_cdt[ri!index].userId),null,ri!newTeamLink_cdt[ri!index].userId))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 8 years ago
@judym Please rectify the 'value' of 'Employee Role' dropdown in rule!ips_assignUserRolesGrid() as follows and do let me know if there are any other issues:
\ t
value: if(rule!APN_isEmpty(ri!newTeamLink_cdt[ri!index]),null,if(rule!APN_isBlank(ri!newTeamLink_cdt[ri!index].userId),null,ri!newTeamLink_cdt[ri!index].userId))
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data