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
2697 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
0
sikhivahans
over 8 years ago
@judym Fantastic.!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
judym598
Certified Senior Developer
over 8 years ago
@sikhivahans - I've updated my main rule to account for the third dropdown but I'm having trouble getting the grid rule to work. Basically, I'm not adding a cascading dropdown for the assignments (areas of expertise). I have a query rule that brings back a list of expertises based on the userId. So I created a local!selectedUserId variable to use in my query rule that displays the dropdown list and added an a!save statement to update that local variable with the selected user id. But I get an error when I access this form because the query rule cannot find a userId. Here's the error I'm getting and I've attached my updated rule for the grid.
Expression evaluation error in rule 'ips_getexpertisebyuserid' (called by rules 'ips_assignuserrolesgrid' > 'ips_assignuserrolesmain') at function a!applyComponents [line 100]: Error evaluating function 'queryruleexec' : No value received for input [userId] in query rule [ips_getExpertiseByUserId]. What am I missing?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 8 years ago
@judym Please find my response to your question at new post -
forum.appian.com/.../e-170455
.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
<