You did the tutorial at Retrieve location specific Phone Numbers (or other data) from an appropriate Google Spreadsheet - #10 by SteveJG and it now works after you set your GoogleSpreadsheat to SHAREABLE. Great.
You now have a very different problem. The problem appears to be what to do when the GetText responseCode is not 200.
There are many ways you could provide default phone numbers Samira. What you do depends on what you want to happen when you check the location but the Web is taking too long.
Here is a simple possible solution. This is a modification of the code in the tutorial. You need to modify the blocks in two places. The changes might do what you want to do.
Remove the clearVariablesAndLabels Procedure Block and add the additional code Blocks.
---- **edited **
When the Web.GetText does not return 200 (that means it does not make a valid connection) thePhoneList become a default list of the phone numbers.
The default is made from this csv Table nom service,numero telephone \ngendarmerie,1055 \npolice,1548 \npompier,14
AND you must also make this change to
to the code in Button3
Delete the clearVariablesAndLabels Procedure block. Replace it with getTheSpreadsheetCSV
Is this what you want to do? If this is not what you need to do, please give a better explanation. Google Translate is not providing a clear translation.