Query from another Table by id?

Depending what is the name of your primary key in that table the code should look something like

{{formatDataAsArray(query4.data).filter(x=>x.school_id==item).map(x=>x.School_name)[0]}}

school_id just needs to be replaced with the actual key name.

Does that help?

2 Likes