Recent Discussions
Total work days in a Month
Hello, I am trying to calculate the total work days in a month based on today's date. Here is my formula but it is not working correctly, I am getting a total of 25 days for February and there are only 20 working days in February for this year. Dates and duration formulas in Quick Base are new for me so any help is appreciated. Formula: ToDays(ToWeekdayP(LastDayOfMonth([Today's Date])) - (ToWeekdayN(FirstDayOfMonth([Today's Date])))) My team wants to see what business day they are on (which I figured out) and then how many business days are in each month. Thanks ------------------------------ Jennifer Silberstein ------------------------------Color part of the background in a field
Hello, I have a filed that I need to color part of the text and not another, example - 30%/30% I have gotten close, however there is an invisible line break with the color formula I can't figure out. Here is my formula: var text targetl=Left([Target], "/"); var text targetr=Right([Target], "/"); var text targetlc="<div style=\"background-color:yellow;\">"& $targetl &"</div>"; $targetlc & "/" & $targetr The formula leaves me with the below text and I am trying to get them to be on the same line. I have tried a few different variations but still I end of up with two separate lines. 30% /30% Any help is appreciated. Thank you ------------------------------ Jennifer Silberstein ------------------------------
New LA User Group
We're kicking off an LA User Group! We're so excited by you LA. This feels like a long time coming. We're going to kick it off with an event in the afternoon / evening of 12/19. We'd love to see you at this event - it is going to be a casual social gathering hosted by Quick Base with some light content, snacks and drinks. Going forward we see these meetups as part social, part working sessions. You may come to learn something new about the platform, talk to another customer that has already solved your problem, or be someone's no-code hero. Even if you can't attend this kick-off, joining this group will put you in touch with local builders that love Quick Base. Join the group We're coming for you LA! ------------------------------ Jacob MacIntyre Manager Quick Base Portland OR ------------------------------
QuickBase Expert
Hello, I'm currently searching for a freelance APP builder to give us hand with our Two Apps. Our Programmer left and we have no one to help us with more detail app reporting You can contact me @ felipem@equisolar.com ------------------------------ Felipe Manriquez ------------------------------
What is the most interesting or unique item you have on your desk or in your workspace? 💾
What is the most interesting or unique item you have on your desk or in your workspace? 💾 ------------------------------ Roderic West Program Data Technician | Quickbase Developer Orange County Department of Education Costa Mesa, CA ------------------------------
