![]() ![]() ![]() To construct complex Yes/No values: in an app that captures orders, a virtual column named Important? may be defined with the app formula, OR(( > 1000.0), ( > 100)). To construct conditional values: in an app that captures contact information, a virtual column called PreferredPhoneNumber may be defined with the app formula, IF(,, ). To combine other columns: in an app that captures a FirstName and a LastName, a virtual column could construct FullName with the app formula, CONCATENATE(, ", ", ). Here are three common use cases for virtual columns: ![]() They do, however, impact your app, behaving much like an ordinary column. Their values are not actually stored anywhere, so they won't show up in your spreadsheet once you create them. Instead, it is automatically computed via an app formula expression. A virtual column is a column that doesn't correspond to an actual column in the underlying spreadsheet. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |