Forum Discussion

JakeRattner1's avatar
JakeRattner1
Qrew Cadet
6 years ago

Creating reports that show only the columns where values are present

Hi Everyone, We get bids from vendor on projects (RFPs). For each project we end up having different information submitted. As a result we often end up with an embedded table on the project record ...
Formulas and functions
reports and charts
BradLemke's avatar
BradLemke
Qrew Assistant Captain
6 years ago
How well-versed are you with API manipulation?  Have you done an Iframe Embed into a form before?

I could see there being a way to create an Iframe embedded 'Api_Genresultstable' where the clist (column list) is dynamically generated via formula.    

Here is the code I would start with in a Rich Text Formula Field in the Parent Record: 

Customize and manipulate to your needs, of course.  Then create a Report Link field that matches this rich text field exactly to this rich text field:

Lastly, add that field to your form and see if you like how it works.  


------------------------------
Brad Lemke
------------------------------
ShaneMiller1's avatar
ShaneMiller1
Qrew Cadet
2 years ago

Hey! A few years late, but is this still possible? I tried it and when I went to save it said "

There are one or more problems with your entry

Only text, Quickbase-accepted functions, fields, variables, and certain HTML tags are allowed in this field. JavaScript is not supported.

Is there a workaround to get a report that only shows columns which have data points on child records?



------------------------------
Shane Miller
------------------------------