درحال‌حاضر صفحه درخواستی به زبان شما دردسترس نیست. می‌توانید زبان دیگری را در انتهای صفحه انتخاب کنید یا بااستفاده از ویژگی ترجمه داخلی Google 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
4790963780083825922
true
Search Help Center
true
true
true
false
false