Hello Appsheet Community,
I have table caseload builder which has a one to many relationship with table site notes. I am creating a virtual column in the caseload builder. Site notes has two relevant columns: noteDate and schedStatus. noteDate is a date&time field and schedStatus is just a text.
My goal is to haee the virtual column pull the value of schedStatus from the related site notes with the highest (most recent as they can’t put one in the future) noteDate. I’ve tried constructing the below but it doesn’t quite work. If there are multiple site notes it won’t pull the right sched status.
([Related siteNotes][noteDate]=LIST(MAX([Related siteNotes][noteDate])))
Any guidance here would be much appreciated! Thank you!