Auto fill forms. Is there a function in Appsh...

expressions
(Craig Clancy) #1

Auto fill forms. Is there a function in Appsheet that can suggest data from a list when users complete a form. I have a payroll situation where there are 50-100 employees. There is no relationship between supervisors and employees so a Slice or SELECT expressions aren’t suitable with an ENUM or similar.

What would be great is if the Supervisor could start typing the name of the employee and APPsheet shows a list of suggested entries as the user types the name. Like predictive text on iphone.

Does Appsheet have this feature?

Many Tx

(Reza Raoofi) #2

Yes, there is such a feature; you can use it in Enum or Text column types; when you open the column’s definition you will find a property named Suggested_Values which could accept a list of your suggested items.

You could enter expressions like TableName[ColumnName] or SELECT(…) in order to populate those list items.

Check this out for more details: https://intercom.help/appsheet/expressions/using-expressions/suggested-values-for-a-column

(Craig Clancy) #3

Thank you very much Reza. I have so much to learn.