What took so long?!
Just added myself to the Seattle Qrew! I'm a Solutions Consultant on our Strategic Accounts team here at Quickbase, approaching my 2 year anniversary (April). I reside in Seattle. Looking forward to connecting with you all here in our online discussions and hopefully one day in person! ------------------------------ Chad Ravancho ------------------------------Seattle meetup anyone?
Hello Seattle!!!! I'd love to see a group of Seattle Quickbase enthusiasts, or Qrew, come together in person and share some tips and tricks? Would anyone in this Qrew be interested in helping me get a meetup organized? Feel free to reply below, email me or book a meeting (contact deets below)! Thanks! ------------------------------ Ben Simon bsimon@quickbase.com Do you have Feedback on how to make Qrew Discussions a better experience? Let's chat! https://calendly.com/bsimon-2 ------------------------------
Image display
Is there a way to embed an image in a new form? Use case: Need to have a different image displayed every time I add a new form. Not file attachment. Ideally, be able to pick the image from a file explorer or paste the image on the new form. I have a "Parts" table and want to display the image of the part. ------------------------------ ed cooper ------------------------------Military time conversion
Trying to find a way to solve this: I am doing time and date tracking for a support app. I have a date field. I also have a start time and end time fields where I would like to user military time: Date:_05/12/2021____ Start Time:__1000 End Time: ____1130 I would like to convert the military times in the Start Time and End Time fields and subtract the Start Time from the End Time so the value in Total time needs to be in hours and minutes Total Time: __1.5 hours Help!! ------------------------------ ed cooper ------------------------------
Summary Report Formatting
Hello: I am trying to create a CSV output file from a Summary Report that must list the content of 12 fields. I will be grouping and Summarizing content in only three fields. It seems Quick Base limits this report content to only 6 Fields? Can someone confirm? Are their any other options? Thank you for any help you may provide. Dirk ------------------------------ Dirk Ruana ------------------------------Total Revenue Formula
Greetings. I have a small issue with a formula. The fields (indicated below) do not total if there is a null value in the the [Total Equipment Price] field. If you look at image file attached, they do not total left to right. I know this is probably a basic issue, but I just can't figure it out. Help is appreciated. Dirk [Total Labor Cost]+ [Total Materials Price]+ [Total Materials Mark-up]+ [Total Sub Contractor Price]+ [Total Sub Contractor Mark-up]+ [Total Equipment Price] ------------------------------ Dirk Ruana ------------------------------Date Formatting
Hello: I am just trying to change date formats in Quickbase. Normally I would have: 07-22-2020 Would like to change the hyphens to backslash: 07/22/2020 I am outputting a CSV file for import into an accounting program. Accounting program does not recognize hyphens. I am hoping this is a simple fix. Thank you, Dirk ------------------------------ Dirk Ruana ------------------------------Syntax Error
Hello: Having trouble identifying syntax error. Below is the formula and related error message. The first line is supposedly "expecting comma." If anyone can help, I'd be very appreciative. Dirk ---------------------------------------------------------------------------------------------------------------------------------------------------------- If( [Work Type]="RD-Reactive"or [Work Type]="RP-Reactive Project"or [Work Type]="PJ-Planned Job and [Schuchart Cost Code]<>""[Schuchart Cost Code], [Work Type]="RD-Reactive"or [Work Type]="RP-Reactive Project"or [Work Type]="PJ-Planned Job and [Schuchart Cost Code]="",([Building - Group Identifier] & [Record ID#]), [Work Type]="250K Project" and [Schuchart Cost Code]=" ", [Schuchart Cost Code] ) ------------------------------ Dirk Ruana ------------------------------Text Formula Field Error
Hello once again. I am probably looking right at it, but I can't seem to find my formula error. Please see pop-up message below: Text Formula Field Error Formula syntax error Please check the syntax of your formula. Look for mismatched parentheses, missing quotes, or extra brackets. If( [Cost Code]<>"",[Cost Code] [Cost Code]="",[Building Group Identifier] & [Record ID#]) Your critical scrutiny is appreciated. Dirk ------------------------------ Dirk Ruana ------------------------------
