Manipulating multiple values with list functions and expressions
In this section, we will learn what list column types are and also how you can create lists. Thereafter, we will learn about various list functions and expressions with examples.
As you will be aware, in AppSheet, in columns of date, datetime, time, URL, text, phone number, name, number, price, image, or other types, the user can enter a single value per record – so users can enter a single date value in a date-type column, a single time value in a time-type column, a single phone number value in a phone-number-type column, and so on.
However, at times, you may need multiple values of a single data type in a single record. Consider a case where you would like to refer to multiple phone numbers of a customer in their record in a customer table. Those phone numbers may have been entered in another table, such as one called Customer Contact Details, in multiple rows, but you want to display them together in...
