Enabling the Smart View Extension for Google Sheets

Users can use Smart View features in Google Sheets only if the Service Administrator has enabled it at the application level.

The Service Administrator must enable support for Google Sheets from the application settings of every business process that users want to connect to using Smart View in Google Sheets. It is not enabled by default.

When Google Sheets support is not enabled and users connect to their business process from Smart View, they can only reopen saved sheets, view sheet information, adjust data values, expand or collapse cells, and change Smart View Options. However, when users try to refresh or submit saved sheets, update and submit data in grids, refresh functions in a sheet, a message appears stating "This operation is not supported by the provider. Contact your Administrator to enable support for Google Sheets" and they cannot proceed further with submitting or refreshing data. Similarly, when they try to open the Smart View Home Panel, a message appears stating "Administrator has not enabled Google Sheets support for this instance".

Once the Service Administrator enables support for Google Sheets, then users can open the Smart View Home panel to view the library, work on forms and ad hoc grids present in their application, refresh and submit data, and use Smart View features.

To enable the Smart View extension for Google Sheets:

1. Open the web application for your business process.
2. Click Applications and then click Settings.
3. In the Smart View Add-on section, select the Google Sheets check box. This check box is not selected by default.
   
   
4. Click Save.