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

Qrew Assistant Captain

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

JakeRattner1

Qrew Cadet

5 years ago

Thanks Brad! This is exactly what I'm looking for. I'm not familiar with this technique, but I'll give it a go and let you know how it works out.

------------------------------
Jake R
------------------------------

Forum Discussion

Creating reports that show only the columns where values are present