ContributionsMost RecentMost LikesSolutionsRe: Timeline or Duration shown visually as a field? I'm guessing the person is looking for a status bar like Salesforce can fo (rather than a bar that shows a dynamic distance based on how long the record was in that phase). And even if that wasn't the original ask, now I'm curious if that's possible? Amber Gartner Predecessors - conditional drop-down or selection?Hello, I'm using predecessors in tasks, but when I go to select a preceding task, it gives me a list of ALL tasks, not just ones actually associated to the specific project I'm in. Is there a way to make the pop-up list of available predecessors limit itself to the tasks within the same project? Thank you! ------------------------------ Amber Gartner ------------------------------ Re: Move Legend in Pie ChartThank you! ------------------------------ Amber Gartner ------------------------------ Color-Code a Series in a Chart if the series is a Report FormulaHello! I'm making a bar chart and grouping like objects with a report formula. For example, all store types that contain the word "New," I want them to just be called "New." We have New-A, New-K, New 5.1, etc. I have created the summary formula, so the series does work. However, the report gives the "New" doors an automatic color that I can't seem to easily change. Does anyone know how to do choose the color or even know if it's possible? Thank you! ------------------------------ Amber Gartner ------------------------------ Move Legend in Pie ChartIs it possible to move the legend in a pie chart from the bottom, where it looks very messy, the right, where it would be better balance and left-justified? Thanks! ------------------------------ Amber Gartner ------------------------------ Dynamic Form Rules & RequirementsIs there a way to change requirements on a form after a user takes a specific action? For example, only 2 fields are required normally, but if the User selects "yes" from a drop-down or marks a checkbox yes, then other fields become required? We want people to be able to use the form and enter whatever info they have as they get it, but we don't want them "submitting" it until the form has all of the info. Thanks! ------------------------------ Amber Gartner ------------------------------ Re: Query to find all records that have a date field in the same monthI think I may have replied to you directly before somehow... but I did update the OAB to OBF -- THANK YOU for that. I had to keep in the FirstDayOfMonth formula in order for it to work, but then also changing the OR (back) to AND worked as well. So again, thank you thank you!! ------------------------------ Amber Gartner ------------------------------ Line Graph of records in the same status each day over timeHello! Does anyone know how to create a line graph that shows how many records are in a certain status each day, over time? I don't know how to take a snapshot of each day and plot that in quickbase... Thank you! I'm thinking it would look like this: TIA again! ------------------------------ Amber Gartner ------------------------------ Query to find all records that have a date field in the same monthCan anyone help me figure out how to query to find all the records that have a certain date field that's in the same month (and year)? This is what we have, and it's correct for April, but then it's doing a backwards running total, so March is including April and March. Feb is including Feb, March and April. Thank you! var text query ="{48.OAF.'"&FirstDayOfMonth( [date field] )&"'} OR {48.OAB.'"&LastDayOfMonth ( [date field] )&"'} "; Size(GetRecords($query)) BTW - I tried using "AND" instead of "OR," but that returned a number of 1 or 0 usually, when it should be more like 10-30. Thanks again! ------------------------------ Amber Gartner ------------------------------ Query to find all records that have a date field in the same monthCan anyone help me figure out how to query to find all the records that have a certain date field that's in the same month (and year)? This is what we have, and it's correct for April, but then it's doing a backwards running total, so March is including April and March. Feb is including Feb, March and April. Thank you! var text query ="{48.OAF.'"&FirstDayOfMonth( [date field] )&"'} OR {48.OAB.'"&LastDayOfMonth ( [date field] )&"'} "; Size(GetRecords($query)) BTW - I tried using "AND" instead of "OR," but that returned a number of 1 or 0 usually, when it should be more like 10-30. Thanks again! ------------------------------ Amber Gartner ------------------------------