Autogenerate column

Use this if you need a column to generate unique values automatically. This feature can be extremely useful in cases where identification columns like Order ID, Employee ID have to be automatically filled when a new order is placed or a new employee is added. Such columns can be used as the id column in sheet linking. 

1. Open any application. 
2. Click on “Open Sheets” in the top bar.
3. A view that displays your sheet's data opens up. Go to the sheet (Ex, Employees) where you want to create a link
4. Click on the three-dotted menu “⋮” on the column whose values you want to autogenerate. (Ex, Employee ID)
5. Select “Autogenerate”
6. The autogenerated values are number values incrementing from 1.
7. Now in an “Add New Row” screen, you do not need to add a component for this column. On submitting, the column will be populated in the sheet with auto-generated values.