ContributionsMost RecentMost LikesSolutionsRe: Pipeline Step to Refresh record Mark, is this still the case? ------------------------------ Ashley Harris ------------------------------ Re: Counting records with the same Concatenated Values Hey Mike, No, I need to count the # of Transactions based on the Concatenated Field that I have created. Records where the value in the Concatenated Field are the same, I only want to count once. Does that make sense? ------------------------------ Ashley Harris ------------------------------ Re: Counting records with the same Concatenated Values Hey Simon, My Concatenation field is what identifies the 2 records that should be counted as 1. Its the ID that is the same between the 2. I tried counting with the Distinct Count function on the summary field while summarizing on my Concatenated field, and it's still counting each record individually. In my example below there are 10 Transactions but when Combined via the Concatenated field there should only be 6 Transactions. ------------------------------ Ashley Harris ------------------------------ Re: Override a date formula field? Hey Julie, Try creating a regular Date field and another Formula Date field. Make the Date field your "manual" entry. Personally, I like to include "Manual" in the field name. In the 2nd Formula Date field, use the formula below. Nz([Call Date (Manual)],[Call Date +14]) ------------------------------ Ashley Harris ------------------------------ Counting records with the same Concatenated Values I have a Transaction Table that breaks out some payment into 2 records (Principle & Interest). In another table (parent), I need to count those 2 records as 1 Transaction when I am summarizing up so that I have a correct calculation for # of Transaction over a period of time. I created a Concatenation (formula field), and have tried Summarizing but I can only use the Combined Text function. I need the Count function. What is the best way to count records where the value in the Concatenate field is the same, so I can Summarize up to the Parent with a number value? Thanks in advance for the help. Ashley ------------------------------ Ashley Harris ------------------------------ Formula Checkbox based on Text-Multiple Choice I need help with a formula for a Formula - Checkbox field. When the value in a Text-Multiple Choice is Yes then Check the Box. This is where I am currently at. I'm getting an error on the "Yes". IF(Contains(ToText([Registered Agent for any Entity]),Yes) = true) ------------------------------ Ashley Solomon ------------------------------ Pipelines Slack ChannelI have created a Pipeline between QB and Slack, so that when a Record is Created in QB a message is sent to a Channel in Slack. How do I include a link to the QB Record in the Slack message? ------------------------------ Ashley Harris ------------------------------