⌨️ Get Cell BG Color
Using this block you can get the background colour of the specific cell of your spreadsheet from your app itself. Below its explained how you can perform this action
You need the GetCellBGColour block to perform this action
Input :
columnName : Name of the column where the cell in located
rowNumber : Index of row where the cell is located
Let’s try to execute this when button 1 is clicked, you can use it at any other event as well
Over here I have used all manual inputs, if you dont have the row number then you can also use the query block offered in our CloudsheetsClasssic extension
Now we are done with this, we will now move to the last block which is the response block
We have to use 2 blocks here, GotCell and ErrorOccurred Block
Writing this is really simple as shown below
This completes our process of getting the background color of a specific cell using the CloudsheetsTools extension
Documentation by Tanish Raj
Copy link