ContributionsMost RecentMost LikesSolutionsRe: Finding Duplicates in Quickbase Just Got a Whole Lot EasierAlex that's a great idea, and sounds like a promising substitute for whatever Google is doing when I try to search for "pusta recipes" and Google asks "did you mean pasta recipes". But what text function are you using to extract consonants from words?Re: Finding Duplicates in Quickbase Just Got a Whole Lot EasierHow does this impact performance?Using the result of one report formula in anotherI'm trying see how we're doing in customer acquisition costs. I have a summary report which tabulates the cost of each lead: The Converted Leads column is a report formula (formula-checkbox where Status field = "Converted"). I'd like to add 2 more columns: Cost per Conversion. For a given month, this would equal the number of conversions divided by the total cost (so, the 2nd column/1st column). Conversion Percentage. For a given month, this would equal the number of conversions divided by the total number of leads (so, 2nd column/3rd column) It seems like I'd need to use the results of one report formula (Converted Leads) in 2 others, but I don't see that as an option when I try to configure the report. How to do this? ------------------------------ Jonathan Heuer ------------------------------ Re: Open beta has begun for new table reportsLike :) @Alice HinshawRe: Open beta has begun for new table reportsI've noticed that on the new reports, when any filters are selected, the URL doesn't change. The old reports reflected any selected filters in a revised URL. This is a really useful feature for sharing dynamic views with co-workers. To be clear, an unfiltered report has a URL like this https://homesquare.quickbase.com/db/bij5u3shf?a=q&qid=7 while a filtered report has something that looks like this https://homesquare.quickbase.com/db/bij5u3shf?a=q&qid=7#dynamic/{%22sidebar%22:[{%22facetid%22:44,%22data%22:{%22value%22:%22EZBZ%22}},{%22facetid%22:52,%22data%22:{%22value%22:%22Current%20Customer%22}}],%22searchString%22:%22%22,%22ver%22:1} Will this functionality be captured in the new reports?Re: Open beta has begun for new table reportsBrian a couple of notes about the still-in-beta new table reports (which in general are great): It doesn't support the All-Star Action Menu super button app, which has been quite a boon for my users, enabling the combination of several buttons into one dropdown menu. I'd love to see this supported. The drag-to-rearrange feature of old table reports was useful, if occasionally glitchy. Be nice to see it supported. I'm a little unclear on why you require 2 clicks to start filtering on some field (1 click on the Filters arrow to review the column filters, and a second click to expose the filters for a given column). The filter box doesn't take up a lot of vertical room. It would be great to be able to clear all currently applied filters with one click. Re: Find position of text string in larger stringI haven't implemented it yet, but I think it would work fine. I was just hoping to find a solution which didn't limit the size of the array. Right now there are <10, but it could grow by quite a bit. ------------------------------ Jonathan Heuer ------------------------------ Re: Find position of text string in larger stringNeil I'm sure I didn't clearly explain. Once I search for "V23" and obtain it's position, I'll ultimately want to get the value after the hyphen, "4072". But if I can find "V23" in the larger string, I'm fairly confident that I can extract the part after the hyphen. ------------------------------ Jonathan Heuer ------------------------------ Re: Find position of text string in larger stringThanks Neil- yep I know about Contains. The problem is I need to extract the actual value from the text string, not just whether it's there or not. ------------------------------ Jonathan Heuer ------------------------------ Re: Find position of text string in larger stringThanks Mark, I like this approach. The problem is that the length of the array in the summary text field is arbitrarily long; that is, it may well have more than 26 elements in it. ------------------------------ Jonathan Heuer ------------------------------