Update text property of label or textbox

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)
Presiding------------Pres Day
Conducting---------Bishop Brooks
Organist-------------Johnathan Summers


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.

1 Like

Check my post in response to a similar issue