I have a use-case for which I am trying to find a solution.
So I have a board called Student Database which contains names of students and other relevant information. I also have different Activity Boards for activity given to students (Since nature of activities are different and each activity require different submission technique, these activities cannot be combined in one board) . For each activity submitted by students , points are allocated to them (stored in number type column).
I want to calculate all points across all activity boards for a particular student and display the sum / score for student in student database in total points column.
Can anyone help me with how do I achieve this?