Fetch Parent & Child records Quickbase API_DoQuery
I have a table A and Table B.
A is parent of B
What I want to do is perform a quickbase API call API_DoQuery to get the records in table A with all child records, something like this
id, name child:[id, name]
how can I do that right now I only got the values in table A and a number in the relation field . What I need to do ?
Thanks.
You can use a Combined Text summary field on the parent table to pull all child values into a single comma separated field on the parent table. Since Combined Text fields only work with strings, the Name field should work fine, but for the Record ID you need to first convert that to a string (text) in a new formula text field on the child table.
Summary field on parent:
Formula field to convert Record ID from numeric to string:
- Pass international phone format while updating phone number with Quickbase Restful API
- Quickbase pipeline connected to webhook JSON will not import mixed array
- Quickbase and Docusign
- Maximum number of bytes in report exceeded Error while using API do_query in Quickbase
- QuickBase: download QuickBase files on external site
- Is there a way to get access to QuickBase tables using python API?
- How to create a inflow outflow table where we need to use 2 different date fields
- Issues with Quickbase API call
- Exporting tables from QuickBase
- Can't Render Data with API Call
- How to Render Data from a POST API call in React
- React API call, render data with QuickBase's new RESTful API
- How to parse paginated JSON API response with complex nesting and unnamed array?
- Is there a way to show number and percent in stacked bar graphs in Quickbase?
- Using REST API JSON response as data to build reports in Python
- How to properly perform like queries with Quickbase
- how to properly insert into quickbase via Curl in php
- Fetch Parent & Child records Quickbase API_DoQuery
- Is there a way to concatenate across rows and columns in QuickBase?
- QuickBase AddRecord API Call
- Is there a way to create the type of line graph described below in QuickBase?
- How can I calculate the average of maximums in QuickBase?
- Why my html element is not shown in the following function
- Is there a way to use dynamic "mentions" in a rich text field using scripting in Quick Base?
- Quickbase usertoken to supersede current user credentials/permissions
- vlookup-like javascript to map input value from one field to another
- Quickbase gantt chart Jquery change
- Need assistance in my script in quickbase for Jquery
- QuickBase: Load javascript file every time it searches in tables
- drop down list formula in Quickbase