Table Connector not working properly

[RakanMSD]

I'm new to Rowy and I'm liking the power of the platform!

however, I'm a little bit stuck because of an issue and found no solutions so far

1. I have two collections in my Firebase "Books_collection" and "Authors_Collection" both collections have been built as tables in Rowy and they are configured and working fine (any edits in the Firebase collections are reflected in Rowy Tables and Vise versa)
2. I have enabled Rowy and Algolia extensions in Firebase and they are configured and working fine
3. I wanted to create a column in the "Books_collection" table with the type "Connector" linking it to the "Authors_Collection" Table's Field "Author_ID" I used the code below as per the instructions here & here but I get empty values in the same number of documents in the collection
   

Here is the function code I used is this:

`const connectorFn: Connector = async ({ db, query }) => {
const collectionRef = db.collection("Authors_Collection").limit(5); // Specify the collection name in Firestore
const queryField = "Author_ID"; // Specify the field name in Firestore
const resultsFormatter = (doc) => ({ id: doc.id, snapshot: doc.data() }); // Define the ID and Label Formatter

if (query === "") {
return (await collectionRef.get()).docs.map(resultsFormatter);
}

const end = query.replace(/.$/, (c) => String.fromCharCode(c.charCodeAt(0) + 1));
const queryResults = await collectionRef
.where(queryField, ">=", query)
.where(queryField, "<", end)
.get();

return queryResults.docs.map(resultsFormatter);
};

export default connectorFn;`

thank you guys in advance

[RakanMSD]

UPDATE: I Figured it out! I used:
ID: id
Label Formatter: {{snapshot.Author_ID}}
and it worked like a charm