Hello AppSheet experts, I am trying to make ...

references
(Eric) #1

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.

(Suvrutt Gurjar) #2

Hi @Eric,There can be a few approaches to achieve what you are looking at.

I request you to take a look at sample app

of dependent drop downs and also refer to another concept of references between tables

appsheet.com - Dependent Dropdowns - How to create a dropdown menu with values that depend on earlier choices

Also please take a look at the article

https://help.appsheet.com/ux/dropdowns-in-forms/dependent-dropdown

For referencing between tables please take a look at

https://help.appsheet.com/data/references/references-between-tables

Dependent Dropdowns - How to create a dropdown menu with values that depend on earlier choices appsheet.com