Easily configure named ranges for cells in your Spreadsheet document using the online editor. Create named ranges for single fields as well as for tables. Enter the cell named ranges that fit your purposes. Use them when setting up bots for pre-filling data from the datasource of your choice as well as for creating and updating new records using data entered by users.
Let’s review how this is done:
1. To create a named range, right-click the selected cell or multiple cells in your Spreadsheet document. Then, in the Options menu, select Define Name.
To create a named range for a table, click the cell and select the number of cells you need for the table by dragging the cursor to the right. The number of cells should correspond to the number of fields in the table. To use a named range as a separate field in bot settings, select a single cell.
Note: Bots can only use separate named ranges or named ranges created for tables.
2. In the New Name modal window, enter a name for your cell. Then, select OK to save changes. This name will correspond to the field name that will be used by bots.
3. Proceed to the cell type dropdown. Select the cell type from the list that will correspond to the named range field type. Be sure to define the needed field type for each cell in the table.
Note: The cell type is set to General by default and equals the Number cell type. Use the Text type to pre-fill text values from a data source.
4. To view a list of created named ranges, click the arrow next to Named ranges. Then, select Name manager.
The Name Manager window will then open. Here you can edit, delete, or create new named ranges.
