ContributionsMost RecentMost LikesSolutionsRe: Rich Text StylingHello Thomas, I believe the best way to ensure that the text remains inside the Rich Text box is to replace all the <pre> tags with <span>. I believe <pre> forces the browser to adhere to all formatting, so if there is not a <br> in the right place, which would be nearly impossible to ensure with your end goal, your text will overflow past the edge of the rich text box. So, just update all oif the <pre> opening tags with <span style='font-size:9px'> and the closing </pre> tags with </span>. I believe this will solve your overflow and font-size issues. Changing the font is a whole new beast and often is not easy because so much of it depends on the OS being used, what fonts are actually installed, browser, etc., etc. So, in my opinion, if changing the font is purely just because you like the font better, then I would avoid changing the font. Otherwise, the best approach is to just look at the W3 Schools information about the font-family property and make your decision. I am not even sure if Gotham Book would be a viable option. ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Search Bars Too SensitiveThank you, Mark. That did exactly what I needed it to do. ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Search Bars Too SensitiveHello Mark, Yes, it would be best if I could use this for the filter box and the search boxes that you can place on Dashboards as well. I think that formula field would be useful for sure!! ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Search Bars Too SensitiveI have been getting all kinds of calls from users complaining about how sensitive the searches are when searching for companies, contacts, etc. Is there any way to adjust this in Quick Base or any other kind of solution? For example, we work with a company called Hill's Interiors, if you just search for Hills, this company does not show up in the results. I have informed users not to be extremely specific when searching, like adding the punctuation to Inc. or searching by typing "ABC, Co. Ltd." and so forth, but it still seems that there should be some leniency in the searches from the Dashboards, or the Filter bars at the top of reports for examples like that above, or if you have AB Company that may be input as A.B. Company. ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Copying a customized button bar?Hi Janna, I have actually created a post similar to what you are looking for. Here is the link. ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Adding duration to date / time fieldHello Chris, Rather than starting from scratch, what is the formula you currently have and what is the syntax error that you are getting? ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Formula date field third WednesdayErmias, This formula should work as well. You are always just going three weeks after the previous Wednesday, unless it is a Wednesday, then you are just going three week from that day. if(DayofWeek([Assignment Date] !=3, PrevDayofWeek([Assignment Date], 3) + Days(21), [Assignment Date] + Days(21)) ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Formula date field third WednesdayUnderstood. The question is, if the Assignment Date is on Thursday the 19th, would the End Date still be April 8th since it was assigned in the same week, or would it get pushed out to the 15th of April since it was assigned after the nearest Wednesday? ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Formula date field third WednesdayHello Ermias, I think the best way to achieve this would be to use the NextDayofWeek([Assignment Date], 3) to find the next Wednesday and then add 21 days. I think this may work. if(DayofWeek([Assignment Date] !=3, NextDayofWeek([Assignment Date], 3) + Days(21), [Assignment Date] + Days(21)) The only caveat is you did not really explain what happens if the assignment date is a Thursday. Is it then the third Wednesday after the next Wednesday, or is that next Wednesday part of it, then that would make the formula more complicated, but still doable. ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------ Re: Pipelines - Mailchimp Connection Amazing Don, They do not currently have a Channel for Constant Contact… So, not at this point for Constant Contact at least. If Constant Contact has public API's, you may be able to access those through the Quick Base Webhook channel. Unfortunately, unless Constant Contact has the ability to send their own webhooks, I am not sure if you will be able to trigger on Constant Contact events. They have a functionality that allows you to "Link a Record", but I have not played with that to see if it works through generic webhooks or if it only works with current active Channels. I am a bit surprised that Constant Contact is not a channel they have and was not in the planning stages, at least before they removed all the Upcoming Channels for us to view and now just show this... "Disclaimer: We are working to launch these channels, but plans may change and we cannot guarantee specific delivery dates or that we'll ever deliver certain channels at all." ------------------------------ Brandon Drake JHI Group Monroeville OH ------------------------------