Forum Discussion
BlakeHarrison
5 years agoQrew Captain
When you say "display them in a different way than a Report Link", what are you wanting to do?
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------
DanielCamacho
5 years agoQrew Member
@Blake Harrison, the out of the box solution in Quickbase will display child records in a table. There are limitations to how the child records are displayed in those table. Is it possible to use javascript and an API call to obtain the child records by querying the related table and display the results of the query inside of a Rich Text Formula field?
------------------------------
Daniel Camacho
------------------------------
------------------------------
Daniel Camacho
------------------------------
- BlakeHarrison5 years agoQrew CaptainNo, I understand the limitations of the Report Links, I'm just wondering what you're wanting to do with the data in the Rich Text Formula? Are you wanting to display those records in a table that's styled in a way of your selection or are you wanting to capture/display data that could be accessed using Summary functions or other native functions?
I'm assuming you're wanting to style the table and if so, you're right about needing to use JS to query the child records. This would require either injecting JS into the form to display your HTML immediately on opening the record OR require the user to click a button to load JS from a Code Page. The first option is what most people have used in the past and presents a possible security issue. Because of this, Quick Base will be limiting this option in the near future, so I would not recommend this option.
With the improvements to formulas coming, it might be best to deal with the standard styling until these new options are available.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------- DanielCamacho5 years agoQrew MemberThank you @Blake Harrison and @Evan Martinez, Community Manager. I'll take a look at the new functionality of the upcoming changes.
But yes @Blake Harrison, I was looking to style a table . I am curious to see a sample if you are willing to provide one.
Thank you.
------------------------------
Daniel Camacho
------------------------------- BlakeHarrison5 years agoQrew CaptainI wish I had one to show you, but I actually haven't used JS on a form in a few years because of the security concerns. I have built out custom tables on a form to showcase data, though, just not as a replacement for the Report Links. The example below shows a few custom Rich Text Formulas I built out to display data. Some of this is data available directly on the record and some is Summary and Lookup data.
------------------------------
Blake Harrison
bharrison@datablender.io
DataBlender - Quick Base Solution Provider
Atlanta GA
404.800.1702 / http://datablender.io/
------------------------------