ContributionsMost RecentMost LikesSolutionsRe: Cannot create a summary field using a relationship where the reference field is a lookup field.If anyone was wondering, you can't fix this by using snapshot fields instead of lookup fields. I just tried and got this error "We are sorry -- at this time, you cannot use this formula and have a summary field using this relationship."Re: Collapsed Timeline report shows a bar for each set of Tasks. Need that same info (duration of the set of Tasks) on a Calendar report.This sounds very promising. I'm looking at your app now. Thanks so much for this!Re: How to create a report joining two tables with 4 or 5 joining columns between the two tables?Hi, It sounds like you have 2 tables and you need to pull a report that displays information from both tables. Are the two tables related to each other? If so, you should be able to edit the relationship and add lookup fields to pull the information from the one table into the other so that all the info is in one table. Then you would be able to pull the report from that table. I suspect your issue is more complicated than that, but maybe this answer will help someone.Collapsed Timeline report shows a bar for each set of Tasks. Need that same info (duration of the set of Tasks) on a Calendar report.Collapsed Timeline report shows a bar for each set of Tasks. I want to see that same information (the full duration of the set of Tasks) on a Calendar report. I know I can use Min Max summary fields to pull the Start Date and Projected End Date of each set of Tasks up to the Project level, so I can get the Start Date and End Dates I need, however I would end up with 7 sets of Start and End Dates. The Calendar report is only set up to work with one Start and End Date. What would be the best way to pull a Calendar that shows the same info that I see when I'm looking at a collapsed Timeline? Also, would like to color code each Task Set bar in the Calendar and would be cool to also see Milestones on the Calendar. Looks like there is not an option to collapse the Tasks in a Calendar report. Here's a visual of a collapsed Timeline: Here's a visual of the Calendar for the same Project. I've got it set to show only 1 Task per day, so I can sort of see a similar visual, however, it is misleading because so much of the info is buried in the records that don't show. For example, I'd like the Calendar to show visually that Kick Off and Creative task sets can begin on the same day that Bidding ends and that info is buried. Also, ideally I need this calendar report to be miniature and embedded on a form (as opposed to the regular sized calendar report that you see when you embed it on a form). Re: Color Coding TimelineYou're welcome... Quick Base Junkie.com has it fully documented in case you need more info... YouTube link:https://www.youtube.com/watch?v=bcDYn64J4bQ Blog link:https://www.quickbasejunkie.com/blog/how-to-iconsRe: Color Coding TimelineIn case you like this idea, here's the code of the Rich Text formula field called S. //This field takes the info in the Status, Overdue, and Needed fields and uses it to display a status bubble. The images are stored in the Images table of this Quick Base app. Red Square = Overdue, Yellow Square = Due Today, Gray Square = Due Later, Blue Circle = In Progress, Explosion = Issue, Gray X = Canceled, Blue Checkmark = Complete var text status=[Status]; var text due=[Overdue]; var bool needed=[Needed]; If($needed=true and $status="Not Started" and $due="Overdue", "<img src=\"theURLofTheImageIsHere/due.png\">";, If($needed=true and $status="Not Started" and $due="Due Today", "<img src=\"theURLofTheImageIsHere/duetod.png\">";, If($needed=true and $status="In Progress", "<img src=\"theURLofTheImageIsHere/doing2.png\">";, If($needed=true and $status="Issue", "<img src=\"theURLofTheImageIsHere/issue1.png\">";, If($needed=true and $status="Not Started", "<img src=\"theURLofTheImageIsHere/needed.png\">";, If($status="Complete", "<img src=\"theURLofTheImageIsHere/done.png\">";, If($status="Canceled", "<img src=\"theURLofTheImageIsHere/x.png\">";, null ))))))) Also, I hear that several Quick Base Solution Providers offer an add on that allows you to customize gantt charts.Re: Color Coding Timeline Re: Color Coding TimelineHi Ivan, I haven't found a way to change the color of the font or the bars in a Timeline report. On my Task Timeline report, I used a Status Icon field to show a visual indication of the status of the Task. My Status Icon field is called S (so it takes up very little column space) and is a Rich Text field that displays a 16x16 image based on the Status and the due date. I'll post the code and a screenshot in a bit.Re: When I use predescessors on a task, it does not auto-populate the start date based on the previous task's completion date. I'm wondering if this is a setting that might have been turned off and I don't know how to turn it back on? Any suggestions?Looks like this is still happening. I had the same problem and used your advice to delete the Predecessor field and create it again.Re: CopyMasterDetailDetailButton Redirect to Record Form in Edit modeQuestion for you guys... here is the code of my CopyMasterDetail button. This imports the detail records that I need but... is there something I can change in the code to make this open the record in Edit instead of View? "javascript:void(copyMasterDetailButtonHandler('&sourceRID=34&destrid=" & [Record ID#] & "', 'bxxxxxxxx'))"