Help Needed: Updating Multiple Evaluations in One Row

[mpibanez]

Hi everyone,

I’m building an app to automate employee evaluations using three tables: Teams, Tasks, and Evaluations. The goal is to update both the self-evaluation and manager's evaluation fields in the Evaluations table, automatically in the same row, when a row is added or modified.

Currently, when I upload the evaluations, they are saved in different rows.



However, I want both evaluations (self-evaluation and manager's evaluation) for the same task and person to be saved in the same row, as shown in this image:

Any advice on how to ensure the row gets updated properly?

Thanks in advance!

[WillowMobileSys]

Please describe a little more about your upload process.  What is being uploaded and how?

It seems apparent that there is something about that upload process that thinks that data is separated into 2 different transactions.  Most likely you need to do something so that data is combined and treated under a single transaction. 

Otherwise, if the data is separate, you need to create an upload process that controls the ability to "look ahead" and see if the row already exists.  If it doesn't, add a new row.  If it does then UPDATE the existing row.  It is not a trivial task.

[mpibanez]

Hi there! As you mentioned at the end, I should implement something that allows me to "look ahead," check if a record already exists, and update that row; otherwise, it should add a new one.

The app works as follows: all users who log in can either evaluate their direct subordinates or themselves through a form (if they don’t have anyone reporting to them, they’ll only be able to evaluate themselves). The list of tasks to evaluate in the form is based on the job role of the person being evaluated (the task dropdown changes depending on the job role). When I evaluate someone else, the response is saved in the "Manager's Evaluation" column, while if I’m evaluating myself, it’s saved in the "Self-Evaluation" column.

Now, once a task has already been evaluated for a person, that task disappears from the dropdown so it can’t be evaluated again (distinguishing between self-evaluations and manager evaluations, so it only disappears when relevant).

The data is stored in separate rows because there are effectively two different views with two distinct form submissions:

Could you help me figure out how to make the app check if the ID (I’m thinking it might be a combination of the person’s name, evaluated task, and a timestamped year) already exists, and if found, save the evaluation that wasn’t completed in the same row?