Conditional Visibility For A Different CMS

Design help CMS
#1

I notice that there’s conditional visibility but it only uses the CMS fields that it is on. Is it possible to use fields from a different CMS?

Ex: Two CMS are authors and books, I have conditional visibility I want to set on books but use the fields from authors.

Currently trying to find a workaround for this.

#2

I thought using custom code and using if statements will do it but don’t know exactly what to write