Discussions

 View Only

Syncing table data/automation question

  • 1.  Syncing table data/automation question

    Posted 08-17-2022 16:34

    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.