ContributionsMost RecentMost LikesSolutionsQuery Writing Best Practices Hello all! I'm looking to crowdsource best practices for query writing! I've done extensive research in the community blog posts and discussion threads and can't find more than a few basic and obvious tips and tricks... This question is coming up because I inherited a relatively old app, that has slowly grown into a Frankenstein mess. It now has tables with hundreds of thousands, sometimes millions, of records with weird relationships. So, I have to turn to queries -- But my queries regularly get overridden by QB and stopped, or they try to run and slow down the whole realm. FTR, I don't have access to the performance optimizer. Thanks! ------------------------------ Harrison Ray ------------------------------ Re: Report Link - Matching Text to Multi-Select Text One more update in case anyone needs to do this in the future -- use Mark's formula but include a special character at the beginning of your strings as well, in case you have values like "testing", "test", and "ting" ------------------------------ Harrison Ray ------------------------------ Re: Report Link - Matching Text to Multi-Select Text Genius! Thanks, as always, Mark! ------------------------------ Harrison Ray ------------------------------ Report Link - Matching Text to Multi-Select Text Hello! I'm having some trouble with a report link that's matching a text field from "this table" to a multi-select text field in another table. The problem is that if I select the box to "only include values if they match exactly in both fields," the report link won't catch records from the other table that have multiple selections. But, because some of the values in "this table" have common words/phrases, if I deselect the box, then the report link will grab records from the other table that include multi-select options that simply contain the value from "this table." eg -- the values in "this table" are "test" and "testing". If I deselect the box to match exactly, the "testing" records will get grabbed by the "test" report link. Of course, I'd rather do this with record ID #s, but this is a fairly old app with hundreds of thousands of records. The relationship wasn't created correctly and the number of records is usually too big for queries.. Thanks in advance! -Harrison ------------------------------ Harrison Ray ------------------------------ Re: Help Using a Report Formula for a Line GraphFor more context, I have 1000's of entree. Each entry contains many fields, including date and include a multi-select text field. So each entree has a bunch of data, a date, and these multi-select selections: Entree 1 = multi-select "A", multi-select "B" Entree 2 = multi-select "A", multi-select "C", multi=select "D" Entree 3 = C Entree 4 = D,B,A Entree 5 = F,A,C Etc. 1000's of entrees with unique combinations of multi-select "selections" I want a line graph that shows date on the x axis and the number of times each "selection" had been chosen each day. Thanks again! ------------------------------ Harrison Ray ------------------------------ Help Using a Report Formula for a Line Graph Hello, I want to visualize some data but am not entirely sure it's possible. I currently have a multi-select text field in a table. I want to create a line graph showing the number of times per day each of those multi-select text options is selected. So the x axis would be "date", the y axis is "# of times selected", and the graph has many series - each series being one of the individual multi-select text options. I've been toying with report formulas and have figured out how to pull out one of the selections per formula. And the series references the report formula. I could make a report formula for each selection but still am only able to select the one series, so am not sure how to get the graph to display them. Is there a way to have a formula that counts the number of times each of the multi-select options is selected? Thanks for any help! ------------------------------ Harrison Ray ------------------------------ Re: Copying the Structure of the AppThanks, Mark ------------------------------ Harrison Ray ------------------------------ Copying the Structure of the AppHello! I'm in a bit of a pickle where creating a copy of the structure of the app would be very useful for us, but we're apprehensive about what the process of copying may do to our database. For context, we contracted a third-party to build out our quickbase app several years ago and no longer have connection with them. Since, we've accumulated a massive database and are always extremely cautious with any changes within our quickbase apps out of fear of corrupting the whole system, because if corrupted, we have no easy access to the original developers to fix it. Is there any reason to think that in the process of copying just the structure of the apps, there may be any risk at all to our database? I understand the existing copy will momentarily "pause" while the new copy is being made. What happens if there is a malfunction during that pause? Could the database be gone? Are there any other doomsday scenarios or is there really no reason to fear? Thanks for any words of wisdom! ------------------------------ Harrison Ray ------------------------------ Re: Copying the Structure of the AppAmazing! Thanks for the info ------------------------------ Harrison Ray ------------------------------ Re: Copying the Structure of the AppThanks Mark. One by one checking off any possible issues here! Really appreciate it. Do you know of a way to find out the size (in terms of MBs) a copy of the structure would be? We're worried about possibly hitting a data cap with our plan. When we make a copy without the data, it won't include any of the record IDs or anything other that the structure map, right? ------------------------------ Harrison Ray ------------------------------