JonathanHeuer
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Finding Duplicates in Quickbase Just Got a Whole Lot Easier
Alex 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?Using the result of one report formula in another
I'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 reports
I'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 reports
Brian 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 string
I 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 string
Neil 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 string
Thanks 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 ------------------------------
