Access data from another existing table connected by reference field.

[Settld-Admin]

Is it possible to set up a column that can access data from a document in another collection that is referenced from a field in a row in the current table? For example I have an Inspections table that includes a reference to the user in the users collection that booked the inspection and a reference to the property in the properties collection that the inspection is for. Is there a way to use that reference to access the value of a field in the document referenced to populate a new field in the current table? For example, populating a cell in the same row of a new column with the user name from the referenced user document.

Please see attached screenshot for further details

[siurna]

I think you could do that by making a connector field and adding a cloud function to populate the field using your document id when you update "Property"

[Settld-Admin]

I was wondering if you could use a connector field but isn't that limited to returning a list of options from another table that a user can select from? In this case the selection has already been made. It's more like a derivative field only accessing values from another referenced table instead of the same table.

[Settld-Admin]

I appreciates Siura's initial response but can anyone else assist with my question? At the moment I don't have a way forward.

[harinij]

@Settld-Admin In this case you can use the derivative column to get data from same table's row or any other collection as well. It is very flexible. For example, to get data from another collection you can use the db field to connect and retrieve data from another collection like so db.collection("collectionId")

[SudgeFunday]

did u ever figure this out Settld-Admin?

[koyamasann]

I also this req, can anyone make a guide step by step?