Update text property of label or textbox

[khawschurch]

I’m trying to get either a label or textbox to display data from Google Sheets.
I’m manually updating data in Sheets, so no need to update data from the app.
The data in the DataViewerList and the label loads fine on app start, but then once I change the data in Sheets, the label.text or textbox.text will not update. I’ve tried several methods using different Get or even setting variable procedures.
Using a DataViewerList or Grid, the data updates fine in these. But unfortunately, these do not give me the formatting options I need, hence I’m using labels/tb’s.
How do I get the text property of labels or textboxs to update after the data changes without having to exit/restart the app?

Sample data in Sheets (two columns - Title and Name)
Title-------------------Name
Presiding------------Pres Day
Conducting---------Bishop Brooks
Organist-------------Johnathan Summers

Blocks:

Screen on startup with correct values:

Screen after Sheets is updated and update button pressed: (It puts the original/startup text back in the label no matter if I set it to blank or even change it first. You can see the DataViewerList updated, but the label.text did not)

Sounds simple enough. But can’t make this work. Ideas greatly appreciated.

[muneer]

Check my post in response to a similar issue

Refresh Google Sheet Data Source while the app is open

There seems to be a problem with the Get value block taking the values from cached source but the Get row object seems to have the updated values [image] Using this method you will get all columns then you need to use the object properties to retrieve the required column. [image]

[khawschurch]

The get value block used this way still does not work. Any ETA?
The Get row object using the corresponding property updates the text box, but only once. If additional updates are made, it will not update again unless the app is restarted. This is the same using both the web preview and the Live app (android). Can this be made to work for subsequent updates to the spreadsheet?
Better yet, is there a way to link the text in a textbox to the corresponding line in the DataViewerList, since the DataViewerList seems to update each time without issue? That would seem most efficient.

Thank you once again.