Okay wonderful! So the article you linked I had stumbled across before but didn't understand. However, with help from support chat, I was able to get something that sort of worked but with a few tweaks I have something working.
For others who stumble across here looking for a way to do the following:
- Have a list of firebase auth account.
- Be able to click a user and have it display which documents they have in their collection.
- see the data of those documents.
here is the way I managed to get it to work:
- I did this on the firebase demo retool thing. But added another query which was firebase auth to my user list.
- get the table there as follows:
{{ selectCollection.value != "users" ? getDocuments.data : getUsers.data.users }}
This now uses the existing getCollections and getDocuments that are on the demo table and should display the users. Unless I've missed steps. It's been a long day. The editor window next to it should now display the user information when you click a user.
- Make another query. I called mine 'document' as a placeholder. It is a service type=firestore, action type 'query firestore' with the Collection or subcollection ID as follows:
users/{{ userTable.selectedRow.data.uid }}/blocks
- make a table which parses that stuff:
{{ document.data }}
If my instructions were written out properly then it should now display which ever user's documents list that you select in the table above.
Thank you community channel for all the help getting here