TateForgey
7 years agoQrew Assistant Captain
Use New/Updated Flag in Report Filter
QB Update: Update: In late 2021 New and Updated Flags will be reach End of Life and will no longer be available, and this post includes information on this feature. Use report filters and formulas to dynamically filter and flag records you want your users to act on. Unlike new and updated flags, as an app builder you can rely on your reports and formulas to behave consistently for all your users.
[Learn more about: Quick Base’s general approach to retiring features | New and Updated Flags retirement]
I realize that many people don't want to see the new/updated flag, but I've got some people who LOVE it. In fact, I have created reports on all the tables in their app that shows only new/updated records so it can be displayed on their homepage, which is easy enough using the checkbox to do that at the bottom of the report definition.
However, we have hit the 9 report limit on their homepage and they want more. It seems to me that these new/updated reports are largely wasted space most of the time or sometimes duplicate other reports that are showing "In Progress" records, for instance.
So, what I'd really like to do is have those flag values as an actual field. That way, I wouldn't just have to show only those records I could create an "any" filter to show status = in progress OR flag = updated or new. Can you access these values in any way? For instance, could I create a calculated field that somehow had a value set based on what the flag value was?
In lieu of that, if there was a way to use the results of one report in another report I could keep the new updated report and use that as a condition in an "any" filter. I don't really see a way to do that either, though.
[Learn more about: Quick Base’s general approach to retiring features | New and Updated Flags retirement]
I realize that many people don't want to see the new/updated flag, but I've got some people who LOVE it. In fact, I have created reports on all the tables in their app that shows only new/updated records so it can be displayed on their homepage, which is easy enough using the checkbox to do that at the bottom of the report definition.
However, we have hit the 9 report limit on their homepage and they want more. It seems to me that these new/updated reports are largely wasted space most of the time or sometimes duplicate other reports that are showing "In Progress" records, for instance.
So, what I'd really like to do is have those flag values as an actual field. That way, I wouldn't just have to show only those records I could create an "any" filter to show status = in progress OR flag = updated or new. Can you access these values in any way? For instance, could I create a calculated field that somehow had a value set based on what the flag value was?
In lieu of that, if there was a way to use the results of one report in another report I could keep the new updated report and use that as a condition in an "any" filter. I don't really see a way to do that either, though.