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
JakeRattner1's avatar
JakeRattner1
Qrew Cadet
6 years ago
Hey Brad, 

Thanks again for your help.  I've recreated the Rich text field you showed in your screenshot.  Now I'm going to create the Report Link.  I'm a little confused about this part.  I think I need to create another rich text field in my Parent table.  Do I copy paste the same code into that field as well?  If yes, how would I get around the errors (the fields references will not work on the parent record)

Thanks,
Jake

------------------------------
Jake R
------------------------------
BradLemke's avatar
BradLemke
Qrew Assistant Captain
6 years ago
Both the rich text and the report link fields are parent-table only.  When setting up the report link field, you're not pointing it at any other table, you're not telling it to go from 'point-a' to 'point-b' like usual - you're telling it to go from 'point-a' to 'point-a', the same field in the same table.

------------------------------
Brad Lemke
------------------------------