Notification

AppSheet will be conducting service maintenance starting Sunday, May 19th, 2024 at 12:00 PM (7:00 PM UTC) and completing no later than 4:00 PM PDT (11:00 PM UTC). Learn more

요청한 페이지는 현재 사용 중인 언어로 제공되지 않습니다. 페이지 하단에서 다른 언어를 선택하거나 Chrome에서 기본 제공되는 번역 기능을 사용해 웹페이지를 원하는 언어로 바로 번역할 수 있습니다.

Configure suggested values for a column

Every column input in a form can prompt the user with a list of suggested values. For example, a column Industry of type Text could have Tech, Media and Construction as suggested values. 

The list of suggested values is optionally defined by an expression in the column definition. The expression could be a constant (such as, LIST("Tech", "Media")) or a dynamic expression (such as, SELECT(LookupTable[Option], [Category] = [_THISROW].[Category]).

Note: The suggested values constraint is a "soft" constraint: the list is not meant to be exhaustive or constraining. The user will be able to enter any other value that conforms to the column type (and the Valid_If constraint if one has been defined).

Was this helpful?

How can we improve it?

Need more help?

Try these next steps:

Search
Clear search
Close search
Main menu
15547958452719159812
true
Search Help Center
true
true
true
false
false