New Lookup Table User Interface

The way we manage Lookup Tables is changing. The interface has gotten an upgrade, and is now basically like working on a spreadsheet, with the powerful tools that comes with. 

1. This means that we can do things like highlight rows, change fonts, copy/paste, and freeze panes, which provides a major quality of life improvement for people who maintain Lookup Tables, without affecting the underlying database functionality at all. 
   
   
2. The functions of the Table and Data tabs in the old interface are all available, without having to switch views.
   1. If you are creating a new table, when you click Save you will be prompted to name the table, by renaming the Sheet.
      
      
       
   2. Double clicking the Sheet tab at the bottom opens the name for editing.
      
      
   3. The new interface has the same data integrity protections as the old one.  For example, you'll find that unlike in Excel or Sheets, once a column header name has been saved, it cannot be changed.
      
      
      
      
       
3. To change the data type for a column, first click the column header, which will activate the button. The button will be labeled based on the current data type: Text is the default, and Number and Date are also available with the usual formatting options.
   
   
4. Clicking Text will open the format popup, and Apply will save the changes.
   
   
5. The formatting tools are across the top, and right clicking a cell or cells gives additional options.
   
   
6. There is also an Export button that will open a save dialog. You can choose from Excel or PDF formats.
   
   
    
7. The Insert tab is used to manipulate columns and rows.
   
   
    
8. The new interface even provides limited support for formulas, although because it is still a database it doesn't store those themselves, but rather the results. If you enter one, it will perform the calculation, but only until the Lookup Table is saved . For example, =SUM(A2:A4) might give us a result of 12. If we change the values in the range, the result will update, until we save the the LT. At that point, we will still see the 12, but the formula that produced will be gone.