Hello,
I am trying to create a result sheet which displays student test results.
At the moment, I have a table called โStudentsโ, which has a column called โStudent Nameโ and holds a row for every student.
I also have a table called โRegistersโ which has a number of different rows. 3 of these rows are: โStudent Nameโ , โMaths Testโ , โMaths Resultโ
An entry for this register would look something
like this: John,
Maths Test 2, 80%
For the results sheet, I would like to create another table in my app called โMathsโ. This will be a read-only table which has 3 columns. These are:
Essentially, when an entry is made in the โRegistersโ table, I want the app to copy the โStudent Nameโ,
โMaths Testโ and โMaths Resultโ information from that entry, and paste it into the โMathsโ table.
For example:
โRegistersโ Table Student Name:
James Maths Test: Maths Test 5 Maths Result: 72%
โMathsโ Table Student Name: James (Read-only) Maths Test: Maths Test 5 (Read-only) Maths Result: 72% (Read-only)
A new row would be added to the โMathsโ table every time an entry is made for the โRegistersโ table. How would I be able to achieve this? Thank you in advance for any help or advice.
Not possible, but there may be other alternatives. What, specifically, are you trying to accomplish with the separate โread-onlyโ Maths table?
+Steve Coile I would like the table to display all of the recorded test results for each particular student.
The โRegistersโ table has entries of many different students and has several different rows.
I would like to take only the maths results from all entries and neatly pile them into rows under the according student.
It would also be very beneficial if this game in the form of a Google Sheet document so that I could then use that information in excel.
You could easily use a slice (Data > Slices) to produce a narrowed (read-only) view of the Registers table. Within the app, this a better approach than attempting to replicate data across tables.
Curious why youโre using Google Sheets if youโd prefer Excel. Youโre aware you can use Excel with AppSheet directly?
To accomplish what you want within your spreadsheet, I think youโd be better off doing it there rather than with AppSheet. Have AppSheet manage the Registers table and use a slice to provide a Maths view. In your spreadsheet, make a Maths worksheet that AppSheet doesnโt use, and use spreadsheet formulas to reproduce the desired columns from the Registers worksheet.
@Eric Have you tought to use references between these two tables? The Student could be parent record and Results as child record. You could then have as many Results records as needed for one student and no need to copy any records. Check this articleโฆ help.appsheet.com - References Between Tables References Between Tables help.appsheet.com
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |