Hi all,
I am still on my long journey making an app for my sports club.
Is there an easy way to read from different cells of a google spreadsheet an write the content in different labels?
For example: writing the content from "Sheet1 / B3" to label 1 and the content from "Sheet1 / F7" to Label 2
I know how to read from 1 specific cell, but I have no idea how to handle more than one
The alternative is to send a google apps script a list of the cells you want, so that these can all be fetched and returned in one call.
Or you can create a separate sheet on your spreadsheet, set formulas to capture each of your cells on other sheets, then call that sheet with one call to return them to your app.
then use the same formula as previously, and as per my example, use the range "A1:A3" and include the sheetname: &sheetname=appData
[edit - I just looked back and you are already using google apps script, you previously wanted to set a value] If your spreadsheet is set with Anyone with the link, then you can make a simple call to your spreadsheet like this: