Read Only
scope if you want to provide limited access that is restricted to only listing spreadsheets or reading data from Google Spreadsheets.Read Only
scope, you'll have to provide read access to your Google Sheets and Drive.Save and Authorize
button once you have selected the scope. You'll be navigated to the Google Login screen. On successful login, you will be shown the permissions screen where you will authorize Google Sheets and Drive for a read only or a read and write access based on the scope you selected for datasource. On Successful authorization, you'll be redirected to the datasources page. You can choose to add a New API by clicking the New API + button.Action not supported
will be displayed when you hover over it.AppsmithEmployeeDirectory
rowIndex
when creating a new spreadsheet and adding data.AppsmithEmployeeDirectory
.onClick
event of a Submit button.settings
tab.{{<FORM_NAME.data.CHILD_WIDGET_NAME>}}
in a mustache {{}}
sign.Submit
button, the query executes, and data is added to the existing sheet Sheet1
of the AppsmithEmployeeDirectory.
Row Index
+ Table Heading Row Index
+ Modifier for the 0 indexed Google Sheet
). The modifier for the 0 indexed Google Sheet is a constant set to 1.(4 + 1 + 1) = 6
.TestDeletion
. You can also supply the URL for the spreadsheet by enabling the JS label.TestSheetDeletion
. You can also supply the URL for the spreadsheet by enabling the JS label.Delete One
operation for a Sheet only works when there is more than one sheet in the spreadsheet.AppsmithEmployeeDirectory
. You can also supply the URL for the spreadsheet by enabling the JS label.Row Index
+ Table Heading Row Index
+ Modifier for the 0 indexed Google Sheet
). The modifier for the 0 indexed Google Sheet is a constant set to 1. (3 + 1 + 1) = 5.
{{<JS_OBJECT_NAME.FUNCTION_NAME()>}}
embedded in a mustache {{}}
sign.AppsmithEmployeeDirectory
. You can also supply the URL for the spreadsheet by enabling the JS label.where
Clause.AppsmithEmployeeDirectory
. You can also supply the URL for the spreadsheet by enabling the JS label
.{{<QUERY/API_NAME>.data}}
embedded in a mustache {{}}
sign.AppsmithEmployeeDirectory
. You can also supply the URL for the spreadsheet by enabling the JS label.rowIndex
, without which the updates will fail.Row Index
+ Table Heading Row Index
+ Modifier for the 0 indexed Google Sheet
). The modifier for the 0 indexed Google Sheet is a constant set to 1.(1 + 1 + 1) = 3
, and (2+1+1) = 4
respectively.Action not supported
tooltip when you try to select an Entity.columnname1
and columnname2
are the column names in the Google sheet.filter by
.[ { "column": "columnName", "order": "Ascending" } ]
For example, you want to sort the data on the employee’s full name in ascending order. You can add the code for the sort by condition:[ { "column": "FullName", "order": "Ascending" } ]
JS label
for the Filter By
and add it to the text field.