Figure 12: Error Alert (List)There are several cool things that can be done with lists in Excel, for example, creating expandable lists, or dependent lists. If you want to restrict the length of a text entry you can do it as well.
For example, let’s say you want make sure that only text is entered in a cell.
A computed column expression can use data from other columns to calculate a value for the column to which it belongs.
You can specify an expression for a computed column in in SQL Server 2017 by using SQL Server Management Studio or Transact-SQL.
Figure 10: Error Alert (Date)In some cases, you want to force the user to enter values from a specific list.
In our sample form, user is required to select his place of birth in cell B14 from a predetermined list of places.