Use Value in One Record to Determine if Additional Records Appear in Report

Question

I have a table with records that only contain two fields "Name" and "Value". What I want to do is have a value in one record determine if additional records appear in a report.

For example, if "Value" in Record 1 = "Show Additional Records", Records 2 and 3 would appear in the report along with Record 1, otherwise, they would not.

I can't figure out how to control what shows in a report based upon a field in one of the individual records. Is this even possible?

Any help would be appreciated.

------------------------------
Royce Patton
------------------------------

MarkShnierYou · Answer

I don't think there's a way to do that with a simple report.

But here's a thought that you could build on.

You could make a helper table with just one record in it. Enter that record and it will be record ID of one. Relate that table to every one of your detail records with a reference field that has a formula of one. Now this one magic record is related to every single one of your detail records.

If you know what your report filter is going to be you can make a summary field on that relationship Detect if you have any of the special kinds of records which trigger other records being shown. That information can then be passed down to all the detail record To be used in a report filter.

You would put an embedded report on that special single record

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community