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

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data