Anyone come up with a sneaky way to hide a report link that has no records - the catch being it is not from a related table so you can't use summary fields, etc. Is there anything you can extract from a Report link via a formula field that gives me any usable information for a dynamic rule?
------------------------------
Mike Tamoush
------------------------------
Question
Possible to hide Report Link with Dynamic rule that is non related?
+14
+24I don't think that will will be possible with today's toolset as you need to go out a query for a record count. At EMPOWER, they talked about a new native formula language syntax being considered to do such a query without a relationship.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
+17Hi Mike,
To the best of my knowledge over my time working with QB I haven't seen anyone find a good workaround to hide a report link when there isn't a summary field or other field to trigger the from rule off of like Mark mentioned. There is work being done to create some new ways for formulas to query but we don't have a firm ETA on that work right now. I would suggest keeping an eye open for upcoming beta opportunities though.
If your two tables aren't related but do have a consistent field you can set it up so that whenever a record is added in the one table it will edit records that have the same value in the field in the second table to check a checkbox that says "show report link" but then you need to get more creative the more complex your set up is (for example hiding it again when the last record that would show up is deleted, etc.) so it can be a bit daunting to manage.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
To the best of my knowledge over my time working with QB I haven't seen anyone find a good workaround to hide a report link when there isn't a summary field or other field to trigger the from rule off of like Mark mentioned. There is work being done to create some new ways for formulas to query but we don't have a firm ETA on that work right now. I would suggest keeping an eye open for upcoming beta opportunities though.
If your two tables aren't related but do have a consistent field you can set it up so that whenever a record is added in the one table it will edit records that have the same value in the field in the second table to check a checkbox that says "show report link" but then you need to get more creative the more complex your set up is (for example hiding it again when the last record that would show up is deleted, etc.) so it can be a bit daunting to manage.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.