Set Cell Background Color
Using this block you can change 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 SetCellBackgroundColor 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
color : Background color you want to set in the cell (enter hex code only)
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, Successful and ErrorOccurred Block
Writing this is really simple as shown below
This completes our process of changing the background color of a specific cell using the CloudsheetsTools extension
Documentation by Team Cloudsheets
Copy link