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/
------------------------------
- DanielCamacho5 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
------------------------------- 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
------------------------------