Analyzing the table and column settings

When you are working on a spreadsheet, such as Google Sheets or Excel, you may not pay attention to the data types. However, data types in AppSheet are quite important to define because they will affect the other behaviors inside the app, such as actions and expressions you may use inside the app. AppSheet is a database-driven application and platform, so it is important to define how your data is going to be dealt with inside AppSheet.

There are two different places you need to visit to change settings if required:

• Table settings
• Column settings

Checking table settings

In the navigation bar, go to Data and click on the Tables tab. We have started to build a new app from a Google Sheet, and you will see one tile in this Tables tab. Expand the tile by clicking on it. The expanded tile will look like the following screenshot:

Figure 2.9 – Table settings

In this table settings tile, there...