how to create a dependent drop down by refere...

ux
(Jagadeesh .G) #1

how to create a dependent drop down by referencing the colomn from the other table?

(Jagadeesh .G) #2

For example consider an app called school there are two tables BASIC INFORMATION & ACADEMICS in basic information columns be like NAME ROLL NO in ACADEMICS

columns be like CLASS SUBJECTS and i want dependent drop down for

NAME, ROLL NO, CLASS, SUBJECTS

(Suvrutt Gurjar) #3

Hi @Jagadeesh_G,

There can be a few different approaches but based on your information given, you can use references for pulling Na me and Roll Number information from BASIC INFORMATION into ACADEMICS table. References because there is unique combination of Name and Roll Number for each student. You may wish to go through article listed at the bottom of this post for how to create references.

For pulling in name into ACADEMICS table, you can set Name column of ACADEMICS table as Column type “Ref” and Referenced table name as BASIC INFORMATION in that column’s definition.

For Roll number column, you can write expression such as [Name].[Roll Number] in Roll Number column of ACADEMICS table. Here [Name] is the name of the Name column in ACADEMICS table.

Your CLASS and SUBJECTS column, if they are not dependent on any other column, you can use simple Enum type columns for these columns.

You can also store this CLASS and SUBJECTS information in another third lookup table and write a formula like SELECT(LOOKUPTABLE[CLASS],TRUE) in CLASS column of ACADEMICS table and similarly SELECT(LOOKUPTABLE[SUBJECTS],TRUE) IN

SUBJECTS column of ACADEMICS table.

help.appsheet.com - References Between Tables References Between Tables help.appsheet.com

(Jagadeesh .G) #4

Any sample apps??

(Jagadeesh .G) #5

HI dependent drop down is not working after referencing!! and imagine every column is dependent on each other like roll no is dependent on name &class dependent on roll no and subjects dependent on class.

(Suvrutt Gurjar) #6

Hi

For drop downs , I shared a sample app in my first post in this thread.

For table references , you can please refer following app

appsheet.com - Table References - A basic demo of table references Table References - A basic demo of table references appsheet.com

(Suvrutt Gurjar) #7

Hi @Jagadeesh_G, You may wish to go through the following

article help.appsheet.com - Dependent Dropdown Dependent Dropdown help.appsheet.com

(Suvrutt Gurjar) #8

You may also refer the following sample app

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