How do add document in a subcollection of a firebase database

How do I do X?
1

Hello,

I am facing an issue, and for the moment I haven’t found a solution.

I have designed a firebase/firestore database with sub-collection and reference to other document inside it (like a one-to-many relation)

collection ingredients
name 
......

collection recipe :
        title
        content
        sub-collection > ingredient
                                      reference to ingredients collection

How can I create this reference during the creation query of my document ?
I have try :

{
	"ingredient": {{"projects/[FIREBASE_PROJECT_ID]/databases/ingredient/" + recipeIngredientSelect.value}},
[...]
}
{
	"ingredient": {{"ingredients/" + recipeIngredientSelect.value}},
[...]
}

But when the document is created, the type of field “ingredient” is string and not a reference to the document.

Any ideas ?

Thanks !

2

Hello, could you please send me a screenshot of your Firestore like this?

image
image1536×752 42.1 KB

3

Hello :
Ingredient :

Reference to ingredient document :

image
image1281×354 38.3 KB

4

Could you please send a screenshot of the Appsmith queries that you want to try to execute?

5

It seems that currently we can’t send a reference from Appsmith to Firestore I opened a feature request to allow us to select the type of data we want to send to Firestore. You can track it at this
link:[Feature]: Specify the type of data to load in Firestore · Issue #20691 · appsmithorg/appsmith · GitHub

6

Hello,

Thanks for the feature submission.

For the moment, I found a workaround,
I send to firebase a map object :

{
"ref_object": {
  "path" : "collection/OBJECTID",
  "id" : "collection/OBJECTID"
},
"field": "value"
}

It’s not ideal, but it’s working !

Thanks !

7

Hello, thank you very much for the solution, it will be very useful.