How to add an item to a sub-table and also access the sub-tables entries with the parent item.
In this documentation it is just said that "You can then add fields to the sub-table as you would in any other table." But how do I add items via a BuildShip workflow? And how can I read from the sub-table via the parent item ID?
Sub-Tables • Rowy Docs
Sub Tables or Sub Collections are a way to create a table within a table. This is useful for creating a table of related data, such as a list of products within an order.
10 Replies
AI Support Bot Information
<@1227983829856157809> you can react on the relevant answer (message) with a ✅ in this thread when you think it has been solved, by the bot or by a human!
Anyone can react on this message with a ❌ if the GPT bot is unhelpful or hallucinating answers.
Please note: Team members will review and answer the questions on best efforts basis.
AI Response
I'm unable to find specific information regarding how to add fields to a sub-table and read from the sub-table via the parent item ID directly from the uploaded files. You might find additional guidance on the documentation or you can reach out to support directly by sending a support request via in-app support. Alternatively, for any hands-on guidance, you may consider joining the BuildShip community or accessing help through the available support channels【4:11†buildship-support-site.json】.
BuildShip AI Support
Hi @Brian Yeah, this is possible, we'll share a remix for subtable and update docs with you. cc @Luis
Hi @Brian, here's a remix link https://buildship.vip/remix/763133f3-3e83-4d28-8924-cc2776e1f1d5
BuildShip - Visual backend workflow builder
Visually build workflows and powerful backend logic for your apps. Powered by AI, connect to anything with or without code.
To briefly explain how this works:
I created a "Add To Subcollection" node which we probably will publish to the nodes library. You can use this to add documents to a sub-collection. In the remix link I shared we have a parent conversations collection > messages subcollection.
Next, to access the documents in a subcollection you can use the existin collection query node. Basically, you just need to enter the path to the subcollection i.e
conversations/<conversation id>/messages
Thank you very much. Everything works
That's awesome, just letting you know we've published this node to library as well.
AI Support Bot Information
<@329034738704580608> you can react on the relevant answer (message) with a ✅ in this thread when you think it has been solved, by the bot or by a human!
Anyone can react on this message with a ❌ if the GPT bot is unhelpful or hallucinating answers.
Please note: Team members will review and answer the questions on best efforts basis.
AI Response
Great to hear! If there's anything specific you need assistance with regarding the node or any other help you might require, feel free to let me know!
BuildShip AI Support