What is a dropdown menu ? the pre-list which admin can control the data input as he or she want to.
for user who fill the form with simple and fast action.
I would like new learnners supposed to learn how to make a prelist by using Enum first,then try using valid_if
First go to Google sheet and create data table for your source database file.
column datatype
Id key unique
Items name text
Item serialno text
Items type text using valid_if
Items Date date
Item image image
Item budget enum
Item workstation text using valid_if
Item doc file
----------------------------------
make another table call items type
column data type
id unique
items name text
then fill up the table with your data as below for example.
when go to appsheet and connect to the table
column view specific the table and column
in the valid_if box
type : table name [column name]
the good thing about using the valid dropdown is that you can make many apps by using the same reference source table.
on the view app
go to the form and click on the column to test the dropdown menu.
-----------------
how to manually enter the options for the column dropdown list
on the valid if condition type {"option1","option2","option3"}
--------------------
another ways of the dropdown menu is by using the select function
you have to add another column to the table
then on the valid if condition type : select(Table name[Column Name List],[constraint column name]="TRUE"
so in sum up how to create the dropdown menu in appsheet app.
you got 3 options to do so.
- valid_if condition by reference from another table source
- manually enter the options in the valid_if condition
- Select function for some constraint value.
ไม่มีความคิดเห็น:
แสดงความคิดเห็น