Functionality of dashboard with Forms on it
Created 3 forms for doing employee reviews with underlying grid sheets. 1 form is an Employee Self Review, 1 Form Employee Selection, and 1 Form Reviewer Form. Idea is a employee fills out self review, then sits with manager. Manager opens dashboard, selects Employee from Employee Selection Form, then clicks submit. Refresh dashboard..by refreshing web browser. This then updates Employee Review Section which are Metric fields attached to a sheet (so I retrieve same row every time), which that sheet points to the Self Review Data looking up Employee by index/match. So here is the problem: this scenario works fine when one user is using the form, but when 2 people are using it - maybe clicking submit at same time - each dashboard user may not see correct info they submitted. I have 20 plus reviewers and real don't want to make 20 dashboards and underlying submittal sheets. any thoughts on how to do this??
Help Article Resources
Check out the Formula Handbook template!