I have data in my spreedsheet. Since yesterday it stopped by sync with app. Everything worked until last few days. I notice this yesterday. I didn't change any of previouous code.
Spreedsheet have 110 rows.
Example last line, last value is False in Spreesheet.
Is there a way how to empty web request?
You do not really show any of the blocks you are using that are fetching the data from your spreadsheet?
You also need to confirm that your spreadsheet is accessible to the app.
I can't share to much because of data sensitivity. Spreasheet is accessible to app. It load all columns and values but after manual update in spredsheet, app still load old value.
Like in last example, True is updated in False but it still load True value.
Is it possible make request empty and load it again?
Check the raw response content
Taifun
If that doesn't bear fruit, setup another spreadsheet with some dummy data, and run your blocks against that. Can you replicate the issue ?
Here are examples with dummy data.
Screenshot of data in label in app.
Code:
Data in from spreadsheet.
OK, your web component is renamed to filter, so what is the "filter" / url (you do not need to show the ss url)? In essence what are you calling to return the data? If simply returning entire rows I cannot see why you are getting back different values for your boolean column. Is FALSE really just FALSE, or is this a display value with an underlying formula that might actually be TRUE (e.g. if=TRUE, then FALSE)?
I will try first update data in one cell in spreadsheet and then call web request again?
Can you help me how to update cell M1 in spreadsheet?
Here is current code.
I follow steps from this tutorial.
This google apps script web app will change the value of selected cell in column M
function doGet(e) {
var ss = SpreadsheetApp.getActive();
var sh = ss.getSheetByName('Sheet2');
var row = (e.parameter.M);
var data = (e.parameter.DATA);
sh.getRange("M"+row).setValue(data);
return ContentService.createTextOutput("Row: "+ row + " updated");
}
You can then call back the sheet data
BLOCKS
One question, are you calling back the data from the correct sheet, you don't have a sheet with duplicate (old) data ?
I did something wrong. I change sheet name since I only have Sheet1.
After Button1 click I get this error. Looks something wrong with range. Why do you parse two values from TextBoxes? Why not define M1 cell in app script instead of selected cell? Is Textbox1 number of selected cell and TextBox2 data sent to that cell or vice versa?
There should be an & before DATA, not a ?
You also want Textbox2.Text for DATA ?
Problem solved.
Trick for everybody.
If data from Spredsheet are not sync with app, first send some value in spreadsheet in cell and then call web request. Updated cell will refresh all data in spreadsheet and reequest will get new data.
Thanks TimaI2 for help with Google App script.
More questions than answers !
Does that apps script now work ?
Do you mean if the data on the app is not the same as the data on the spreadsheet ? How would an app user know this ?
Would you do this on the spreadsheet, or send a new value from the app (e.g. google apps script) ? Which data is more up to date ?
You should only need to get the data from the spreadsheet in order to sync? Unless you are looking for a two way sync, so if you change a value in the app, it must update the spreadsheet?
This is not true, it will only update the value of the cell. There is a built-in apps script function that can ensure all spreadsheet operations are completed before moving on to the next line:
SpreadsheetApp.flush();
Yes it does.
Example you, as admin, add new data into spreadsheet but data are not visible to app user. App user can expect new data every day, depends on app.
Send new value from app into spreadsheet with google app script.
Until I update cell in spreadsheet, web request fetch old data from entire spredsheet. After update just one cell value, web request fetch new data from other cells.
OK, we are on the same wavelength 
