Hi – I’m an oldish dude (73 Yo) trying to teach myself some coding skills from scratch and am starting with ai2 so please go easy on me. I have done extensive searches and have not found an answer that I understand to the following.
I need to extract the content of cell E2 from the Google sheet and place the result in the text box (TB2) to the right of the “NUMBER IN =” label.I will use that result to trigger a Notification
The Formula for Cell E2 =Countif(C:C,"In")
The app is to inform the last person in a private Student boarding house to set
the alarm when they leave.So when Inners = 0 when they change status then the notifyer will kick in with a flashing notification telling them they are the last person in and to please set the alarm as they leave.
I have worked out how to fill the list etc but am stuck on placing the contents of a Google Sheet Cell in a text box.
[mod: fixed image]