If you want to access your data which is saved to the online database in the control panel, you need a way to tell where your database is and which table you would like to connect to get the information.
SpreadsheetWEBInternalConnection can be written in a cell as a formula for e.g.
=SpreadsheetWEBInternalConnection
in CELL A1 of the worksheet, what this variable does is it will automatically locate the database server for your application. So at this point we have automatic information for our database location but we still need to connect to the table and retrieve the information, In order to do that we use the Application ID's please look at the screen shot below.
The Application ID here is: 2675e39b-afaf-411e-a1af-98580c44f484. This is the table information we need to connect to our saved data in the control panel. Now that we have both information we can try to connect to our application using this format, assuming there is an Application Called "Customer Satisfaction Feed Back Form 01" and we have saved all the input retrieved from our users which can be found in the application tab in the control panel.
To connect to this data we need a cell reference say cell A1 which has a Statement as for e.g.
=SpreadsheetWEBInternalConnection
And an Application ID as Table which is in this example: 2675e39b-afaf-411e-a1af-98580c44f484.
We can construct our SQLOpen Statement which would bring all the records from the table as
SQLOPEN ("SELECT * FROM [2675e39b-afaf-411e-a1af-98580c44f484|2675e39b-afaf-411e-a1af-98580c44f484], A1)
Please note: The A1 is actually a cell reference in Excel file with the following statement
=SpreadsheetWEBInternalConnection