Syncing table data/automation question
Is what I have below possible to accomplish in QuickBase? If so, what steps should I take to accomplish this?
Anytime an assignment gets scored in QuickBase, it pulls each individual's assignment score, cached date, score, attempt, and a lot of other data (from a gradebook sync).
|
Name |
Assignment group |
Assignment Name |
Cached Date |
Score |
Attempt |
|
Name1 |
A |
(1)- 9/12/2022 |
9/13/2022 |
0 |
1 |
|
Name1 |
A |
(1)- 9/12/2022 |
9/20/2022 |
0 |
2 |
|
Name1 |
A |
(1)- 9/12/2022 |
9/21/2022 |
1 |
3 |
|
Name1 |
A |
(2)-9/19/2022 |
9/25/2022 |
1 |
1 |
|
Name2 |
A |
(1)- 9/12/2022 |
9/13/2022 |
0 |
1 |
|
Name2 |
A |
(2)-9/19/2022 |
9/25/2022 |
1 |
1 |
|
Name2 |
A |
(1)-9/12/2022 |
9/20/2022 |
0 |
2 |
Ideally: anytime someone's assignment gets graded (and it's a group A assignment):
- A new row would be added to the below table (assignment name)
- There could be a field that calculates that individual's maximum assignment score
|
Name |
Assignment Name |
Max Score |
|
Name1 |
(1)- 9/12/2022 |
1 |
|
Name1 |
(2)- 9/19/2022 |
1 |
|
Name2 |
(1)- 9/12/2022 |
0 |
|
Name2 |
(2)- 9/19/2022 |
1 |
Thank you.