Chapter 14 – Solving Complex Problems through Multiple Apps Within a Workbook
Exercise 1
When adding a new property, we want the ID to be unique, and in typical databases, it is achieved by setting the column as primary key and making it auto-incrementing. The formula we added is meant to achieve the same.
The GetRow function is provided with the table as a source of rows, the current row as the context row, and -1 as the offset to get the row above the current row. The returned row is then dereferenced to get the value of the Id column and we add 1 to that to set the value of the cell. The value of the IDs is instantiated in row 2 by setting the value 1 in the cell.
Another way of achieving the same result is to use cell references by setting the =A2+1 formula in cell A3 and then copying and pasting the formula to all cells in the Id column.
Exercise 2
As discussed in the Client details screen section, the functionality to add is similar to the changes made...
