@Richard555
Consider this example for OnVisible of Screen1 (to test it, first use the formula in OnVisible of Screen1, then create a blank Screen, click that Screen, and then click Screen1 again).
ClearCollect(myColl,{token: "xxx.text.01", hour:Now(),status:"waiting"},{token: "xxx.text.02", hour:Now(),status:"waiting"},{token: "xxx.text.03", hour:Now(),status:"waiting"},{token: "xxx.text.04", hour:Now(),status:"waiting"},{token: "xxx.text.05", hour:Now(),status:"waiting"},{token: "xxx.text.06", hour:Now(),status:"waiting"},{token: "xxx.text.07", hour:Now(),status:"waiting"},{token: "xxx.text.08", hour:Now(),status:"waiting"},{token: "xxx.text.09", hour:Now(),status:"waiting"},{token: "xxx.text.10", hour:Now(),status:"waiting"});
Patch(myColl,Index(myColl,3),{status:"done"});
To trigger the above formula, click on another screen (if you don't have one, create a new, empty Screen, and then click that screen), and then, click Screen1 again.
Now do this:
Now click on the ellipses to the right of Settings, and then click Collections:
Notice the third item is changed:
To use a different record, just put something else other than 3 in the Index function's second argument:
Patch(myColl,Index(myColl,3),{status:"done"});
//replace 3 in the above with which Record you want changed. For example, 5 will change the 5th record.
See if it helps @Richard555
