DavidBrogdon
Qrew Assistant Captain
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: I need to filter report by source value, but still use report on dashboards
Hey, thanks for your reply. I have figure out how to do that part, the problem I have is that once I make the report "ask the user" QB makes it to where that report cannot be displayed on a dashboard page. My question is, how can I answer the "ask the user" question but also still use the report on a dashboard page.0Views0likes0CommentsI need to filter report by source value, but still use report on dashboards
I have a report that shows all shipped items for invoicing. I use the report on a dashboard page for grid editing in the related invoice #. However, I am also needing to link to this report from the invoice record itself via a Rich Text Formula button. When going straight from the Invoice record I need to carry the Related Customer from the invoice to use as a filter of the report. The problem I am having is that once I convert the report to an ask the user, it removes the ability to display thta report on a dashboard page. Any way to do this without creating a separate report? ThanksNot showing all records in related parent selection
I am having a situation where only some records are showing in the drop down selection for related parent record. The field is not a conditional field so it should be showing all available parents but it is only showing roughly 75%. All parent records have system generated Record ID# and should be valid. Any ideas?Re: Formula to show status for inbtween number range
Shouldn't this really be (pseudo) ---> If value > 0.99, red else if value <=0.99 and value >=0.93, yellow, else, green Reason being that 0.99 is going to be greater than 0.98 and also it will be impossible for the value to be greater than 0.98 but less than 0.93? Also, all values above will be greater than 0.92?0Views0likes0CommentsRe: Formula to show status for inbtween number range
Yes, rich text formula field. You don't need to repeat the If statement after the first time. I forgot the " before the span on the second and third. Try this--> If([On Time Shipping %]<99,"<span style='font-size: 15pt; text-align: left; color: green'>" & ToText([On Time Shipping]) & "</span>", [On Time Shipping %]>92,"<span style='font-size: 15pt; text-align: left; color: red'>" & ToText([On Time Shipping]) & "</span>", [On Time Shipping %]>=98 & <=93," <span style='font-size: 15pt; text-align: left; color: yellow'>" & ToText([On Time Shipping]) & "</span>" )0Views0likes0CommentsRe: Filtering Out Old Dates - Exact Form
Quickbase doesn't have a native option that I am aware of for seeing which users interacted with a table over a period of time. The easiest way to implement something like this would be to have an intermediate table between an "Assocaites" table and the "Projects" table and call it something like "Active Members". You could then have the project lead add or remove records to keep track of active members of the project. Another option would be to create a multi-line text field with logging enabled. Then create a formula rich text field equal to "user()". Then create a form rule that says "whenever x happens, change the value in the text log field to the user field. Then problem would then be that you have a running list of users and time stamps that would take a decent script to slice apart and perform logic to remove duplicates and check date ranges. That formula would be beyond my abilities in QB unfortunately. Maybe Dan Diebolt or someone can pitch in here.0Views0likes0CommentsRe: Formula to show status for inbtween number range
Try this --> If([On Time Shipping]<99,"<span style='font-size: 15pt; text-align: left; color: green'>" & ToText([On Time Shipping]) & "</span>", [On Time Shipping]>92,<span style='font-size: 15pt; text-align: left; color: red'>" & ToText([On Time Shipping]) & "</span>", [On Time Shipping]>=98 & <=93,<span style='font-size: 15pt; text-align: left; color: yellow'>" & ToText([On Time Shipping]) & "</span>" )0Views0likes0Comments