Hello AppSheet experts,
I am trying to make my app easier to use by automatically filling out specific cells in a row. To be more precise, the app is used to keep track of student test results, and a new row is inserted for every test a student has completed. A single row looks like this:
Student Name: [Insert Name Here] i.e John Student Year Group: [Insert Year Group Here] i.e 4th Grade Student Subject: [Insert Topic]
i.e Maths Test Name: [Insert Test Name] i.e Test Paper 6 Test Result: [Insert Student Result] i.e 80%
Now unlike some of these questions that change every row (i.e test result), some questions are pre-determined (i.e student age group and topic). For example, a student called John would always be selected as 4th Grade and will always have Maths as a topic. What I am trying to do is that as soon as the name ‘John’ is inserted in the ‘Student Name:’ section, the year group and subject are automatically filled out. How would I go around doing this? Thanks in advance.