Forum Discussion

HagosHagos's avatar
HagosHagos
Qrew Member
3 years ago

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.
No RepliesBe the first to reply