Solved: adding multiple rows combing data from two tables - Page 2

Instituto_San_1 · 03-07-2023 06:20 PM

Hi

I need to create an action, bot or workflow which can populate a table combining data from two tables:

Table A: students Table B: subjects

the common column between the two tables is Course

So I have 300 students divided into 6 courses, about 10 diferent subjects per course.

the result should be Table C: Marks whith a total of 3000 new rows combining each student with his/her 10 specific subjects.

Any help/idea appreciated.

Claudio

Instituto_San_1

I followed your advise and created a simple script in AppScript to generate the entire table, another for adding new students, and one for ading new subjects; of course one for deleting the whole table. All four processes can be called directly from a bot in the Appsheet App, two of them using parameters (new student, and new subject). So I produced a full School students roster linking tables like: Students, Courses, Subjects and Teachers. This is An Administrators app and a also al developed a simple teachers app (filtered by their email address) to edit the students marks.

View solution in original post