ContributionsMost RecentMost LikesSolutionsRe: Formula query for totalSumValues(GetRecords("{9.GT.'"&Date(2022, 3, 31)&"'}",[_DBID_RIDES]),11) How did I do Mark!? ------------------------------ Annalise Sansouci ------------------------------ Formula query for total **EDITTED- I figured it out! But now I can't figure out how to delete this post...there is not enough caffeine in the world today... Hi All- my brain is fried and I can't figure out this but hoping one of ya'll knows this easy peasy (Looking at your genius Mark Shnier!). Basically I have a table that I want to create a formula query to get totals from another table after a certain date. So there is a total field on one table [Total Ride Cost] and a date field [Date of Ride]. I want it to pull and total all of the total ride costs after April 1 and put that into a second table. Thoughts? ------------------------------ Annalise Sansouci ------------------------------Formula for address fields?Is there a way to calculate the mileage between two different address fields? ------------------------------ Annalise Sansouci ------------------------------ Calendar LegendIs there a way to create a legend for a calendar report? QuickBase newbie so still figuring out the basics and not super fluent in it all yet :) ------------------------------ Annalise Sansouci ------------------------------ Pins in map reportIs there a way to color code the pins in a map report? ------------------------------ Annalise Sansouci ------------------------------ Re: Search Bar helpThank you Mark! This is exactly what I need. I'm still learning all about formulas (I'm a QuickBase newbie) and for some reason it's giving me a syntax error. What am I doing wrong? var text URL = list(" ",[Tags], var text Words = " "; "<a name=" & URLEncode([URL for file]) & "</a>" ------------------------------ Annalise Sansouci ------------------------------ Search Bar helpHello all! I have a report that I want used in a search bar on my dashboard. For this case, it is a list of resources and one of the columns is tags/key words. I want this field to be searched for in the search, so that it will pull up records with that tag. However, I don't want to the tag field to be shown in the report that comes up after the search. Any ideas? ------------------------------ Annalise Sansouci ------------------------------ Re: Formula IssueThank you so much!! That makes so much sense and I'm kicking myself for not realizing this. I so appreciate your help! ------------------------------ Annalise Sansouci ------------------------------ Formula IssueHello all, I'm fairly new to QB so I apologize if this is a stupid question. Here is what I'm trying to accomplish. I have a list of dates and I need to capture dates within a 6 week time span. In essence, I want to be able to highlight events happening from now through the next 6 weeks, not including ones that have already passed. I first created a checkbox field which worked and would check the box when within that timeframe but didn't drop off past events. So I created this formula: If([Date]<=Today()+Weeks(6),"Current", [Date]<Today(), "Past", [Date]>Today()+Weeks(6), "Future") The current and future work great but the past still isn't working for those dates that have passed. Open to any and all suggestions! ------------------------------ Annalise Sansouci ------------------------------