ContributionsMost RecentMost LikesSolutionsRe: Merging TablesHi Mark, Thank you, will give this a try. Do the three source tables also need to have relationships established to the merge table? ------------------------------ Michael Zeppieri ------------------------------ Merging TablesUnder one app, I currently have three tables. Each table represents the accumulation of different business workflows that result in the generation of financial transactions. I want to now aggregate this financial data into one table so that I can generate reports from the aggregate data. I created a new table to serve as the aggregation point. My assumption is that an automation can help with this, but I am not sure which one. Because I already have over a 100 existing records that I will never modify again, there is not a create or modify trigger to copy the data. What I need is a daily batch job where Quickbase scans the three source tables and only brings over new financial records into the aggregate table. It's basically a table synchronization automation. Any thoughts on how to approach this?Re: Formula to turn a Combined Text Summary field into a vertical listThank you for sharing this. I am trying to do something similar, but can't seem to figure out where to insert your formula. I have a combined text list that I am pulling from a child table as a consolidated list in the parent table through the table relationship. When referencing this combined text field as a column in a report, it renders as a continuous list, with each item surrounded by a bubble. I want to: - Render the text as a vertical stack - Remove the bubbles - Render a bullet in front of each line item Do I insert your formula into the formula section at the report level, and is it possible to modify the formula to add bullets and remove the bubbles? Thank you! Re: Is there a way to show null values in a Summary ReportI am not sure how this would work. I have a table in which each row represents items by item creation date. The report I am trying to create is performing a count of how many items were created per month. Creating dummy items would generate noise in my items report. When I create this same report in PowerBI, there is a button you can click that says "include null values" and the system knows to associate a value of zero to the months for which there are no items. I was hoping there was a way to do this in Quickbase.Is there a way to show null values in a Summary ReportI am trying to create a Summary Report that summarizes the number of items as a normal value, and I am grouping the columns by item creation date, combined by month. The table generates as expected. The column headers for the table show January, February, March, April, etc. in correct date sequence, and shows the correct count for the number of items associated to each month. I have one problem. If the item count for a month is zero, I want to show it as zero.For my table, the months of April and November have zero items, but the table does not show those two months as column headers, with a value of zero. Is there a way to do this?