Does any body knows why when we use gviz to take the information from an spreadsheet, and then we try to update the values, we did end even remove values from the spreadsheet
why the information in the list view is not update, it show us always the same ?
Yes the reason is, when web got text, from the list itrms you are taking only the first col.. If you want to another, then use join block and add {select list item list (get item) index (2)}
{select list item list (get item) index (3)}
Now you will see three items are added into the list view
The problem is you are having working script but blocks part not set correctly also in this query case how can you update? There is an logical error. In gviz yoi are getting data randomly from gsheet so how it can go correctly in thay place?
I think you are confused.. See you are calling only C and D so if matching value found then you will get only two items so in index you can use 1 and 2 but you have used index as 3 and 4 It shouldnt
Though col C is in 3 rd index you are getting only two items in rrspomse content