📠
Get Cell
This option will let you get the data of a specific cell of your spreadsheet. Below it's explained how you can do it too...
To Get a row, we will need the Get Cell and the Search in Sheet block
Now, We will need to use the search in sheet block to get the row number of the row we wish to update. If you already have the row number then you can skip this step.
inColumn block – Enter Name of column where you want to search the data
query block – Enter the data you wish to search
fromColumn Block – Leave blank in this case
Writing the blocks
When the user clicks the update button the app should check if the data entered by him in the query block is there in the designated column or not
The extension will either return 0 or any other integer (this integer is the index of row you wish to update)
Lets now navigate to the Got Search Result Blocks
Now, we first check the response code, if we get response code as 200 then we can proceed, else if we get any other response code then we will show an error message to the user.
Now we use the get cell block
Row Number : Response Content
Column name : Name of column whose data you want to get, eg : I want to get phone number and so my Column name where phone number is stored is “Phone Number”
Now we are left with only one bloc, i.e. the GotCell block
So this one is really simple, we will just check for the response code, if we have got a response code as 200 then that means that we have received the data. If the response code is not 200 then we will notify the user that an error has occurred.
Documentation by Team Cloudsheets
Last modified 2yr ago