Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I am trying to have a form when a name is selected from a text multiple choice [Employee Name] search for the last time they checked something [date last tested] So when they select their name it auto pulls the date they last tested automatically.
Good afternoon,I pulled a combined text summary field over from another app to a connected table. The initial field was a rich text formula with a List function to display a name and address in a label format. However, when it displays on the new app instead of line breaks it has \r\n: Mr. Joe Brown\r\n123 Anytown St\r\nAnytown, MA 01234I've tried SearchAndReplace(CombinedTextField, "\r\n" , "") and SearchAndReplace(CombinedTextField, "\n" , "") and a variety of other options, but none of them work. Any thoughts? Thank you!
When logged edits are enabled, text is red - can this be changed?
I was reviewing this link in QB Help : https://helpv2.quickbase.com/hc/en-us/articles/30472167462676-Build-document-templatesIt says this: "1. Go to the table settings for the table you want to add a template to. Select Document templates."However, when I go to a tables settings, I do not see option called "Document templates".Is this no longer an option?These are only Table options I see:
Is there any functionality in Exact Forms that would display page numbering on printed forms (i.e. Page 1 of 5)?
I have a parent table (Requests) and a child table (Activity Log) - each Request can have multiple Activities. I am trying to get a summary of the Status logged in each activity to get an understanding of the current status of the Overall Request.
Hoping someone can help me out. I feel like I'm almost there, but not quite!I basically want to strip everything out of my comments to get the first comment without a datetime stamp and stopping when it gets to the second comment [ date time stamp.My formula:Trim(NotLeft(NotRight([Comments],"["),"]"))What my Comments field looks like:[FEB-14-25 12:31 PM Stephanie] in aliqua irure Lorem ex ea adipisicing laboris eu non minim voluptate enim pariatur veniam cillum sint nisi dolor mollit cupidatat do sunt incididunt velit sit mollit aliquip ipsum quis exercitation et id in laboris deserunt ullamco[FEB-04-25 3:38 PM Quickbase Administrator 2] 12341[DEC-02-24 4:47 AM Quickbase Administrator] New RecordWhat the formula returned:in aliqua irure Lorem ex ea adipisicing laboris eu non minim voluptate enim pariatur veniam cillum sint nisi dolor mollit cupidatat do sunt incididunt velit sit mollit aliquip ipsum quis exercitation et id in laboris deserunt ullamco[FEB-0
Hello, I have an application tracking quality defects, one of the fields for capturing information is the catalog unit. that catalog unit is typically 7 digits, for special units where we specialize a standard catalog unit for customer speicifications we typically add 5 digits on the end. I was able to make a formula for seeing if something was special by having [Catalog Number]>999999999 unfortunately, they are starting to use alpha characters on these unit numbers now. is there a formula that can do what I have done prior but also allows for characters to be entered? thanks,
There are two relevant tables for this report, 'Parts' and 'Part Requests'. The Parts table is just a list of all available parts with their available stock, and the Part Requests fields include 'Related Part', 'Quantity' and 'Project Number'. I have a request for a report where users can enter the project numbers for the projects they are focused on, and they want to see the quantity on hand from the parts table compared to the sum of the quantity requested in the Part Requests. My problem is I cannot figure out a way to give them a dynamic filter for which project numbers to use. I was hoping if I just did a table report then they could just use the column filters, but they aren't giving the drop down with the option to select multiple project numbers but instead are just giving the single the option to enter a single text string.
Hello,I want to have multiple data rules to stop an import if the information is not correct but I'm not sure how to word them. I want to be able to check fields and change the values if needed and to make sure an option is not created in my dropdown field.There are 2 fields for a name that I would like to check for capitalization and if it is not proper to change the field. I would also like for it to check to see if there is a comma and space where it should be.I need to check for any spaces in front or behind the information and delete them.I want to be able to stop the import if it has something different than the choices in my dropdown field.Thank you
Hello all! I hope you're all having a lovely kickoff to your 2025 :) We are so excited to get our Qrew meetups back on track this year, and I'm here to let you know that our Februrary Women's Qrew Meetup is scheduled for 2/18 at 1-2PM EST. Since the topic of positioning your Quickbase development experience has come up several times in discussions prior, we wanted to dedicate an entire Qrew meetup to this topic. Join us to hear firsthand how your fellow Quickbase developers, Quickbase partners and even employees describe their development experience and use their technical chops to better market themselves. Stay tuned for an update on speakers!I know there have been some challenges with the invites in the past, so I thought it might be helpful to clarify the process. Use the Events Page as your source of truth for Qrew meetups. Our internal Qrew team ensures that this is kept up to date across all customer events.Register for the event using this registration link. We will co
In my Pipeline, I have a “start date” and “end date.” The start date is {{ today.now }}. For the end date, I want the pipeline to add 5 business days to the start date. Is there a way to do that?
Hello, With the new custom email, I don't see anywhere to CC anymore - I swear I had seen this before when it first came out.Am I missing something?
I am trying to calculate the distance between two addresses. I put the below formula in but came up with a distance of 5000 and it should be 3. var number OriginLat = [LatitudeVendor];var number OriginLong = [LongitudeVendor];var number DestLat = [LatitudePlant];var number DestLong = [LongitudePlant];var number Distance = Round(((69*($OriginLat - $DestLat))^2 + (53*($OriginLong - $DestLong))^2)^0.5);If($OriginLat =0 or $DestLat=0,0,$Distance)------------------------------Sarah Burres------------------------------
When I apply a filter and scroll down the report header does not stay aligned to the columns. The report header moved to the left. I've tried Edge, Chrome and Firefox and it happens on all three. Has anyone else experienced this issue?
When a new record is created (not saved), I would like the 'start time' to auto fill to now. With the now selected in the field settings, the time changes to 'now' when saved. Any help would be greatly appreciated.
I have a formula with multiple Null and Not Null values, one of the nested statements needs to look at two fields so I used AND, but this generates an error "AND" cannot be applied. If(IsNull([Pallet Grp "C"]),0,((Nz([Low, Carton "C"] and (IsNull([high, carton "C"])),1)[high, carton "C"]-[low, carton "C"]+1)Can someone recommend a solution--if possible.
I have created an email button using the formula-url field. Within the body of my email, I would like to have a hyperlink to email for help.ex: &"If you see missing tests or errors in the upload process, please provide the error report to abc@abc.com for review and repair."I want abc@abc.com to be a hyperlink to open an email . How can I make this happen?
Will we be meeting up in person at Empower? I see slots for Qrew meetups, but no actual events/times. Just wondering before I book my return flight for Tuesday night or Wednesday. :)
I want to be able to put a text field into a cell and it be the table alias, then another formula field that converts it to the DBID.Reason being when we copy an app, the tables stay the same, but the DBIDs all update and we have to go manually change all the juiced URLs.
We are looking to rebuild our QB database. Does any one have a good recommendation for a data base expert?
So I have a table, Purchase Orders. That table is a one to many child of Jobs. It's also a one to many relationship of Daily Reports.Daily Reports is also a child of Jobs.What I want is for user A to login, and enter 5 POs, and link them to Jobs.Then, user B logs in and clicks the "Related Daily Report" field and it's limited to ONLY the jobs selected by user A.Is this possible?
I'm creating a graph to show each of the 12 months (January, February,... December) data.I added the data values for January, February, etc. however, after October, I couldn't add November or December. The "+" is faded out on October data value.This happens whether I do a regular bar chart or horizontal bar chart.Is there a limit up to 10 choices of what to add for data values? The idea is to have each of the 12 months data show for each vendorI also want to create separate reports (for drill downs) for each vendor to show the 12 months of data.Is there a different way to set this up? Any is helpful.Thank you!
I have a button that was created to redirect the User to an external webpage that opens in a window that relates the quickbase record they are on. There is a variable in the URL formula that switches out a placeholder in weblink with the related record id for the external webpage based on the QB record. (Adding this piece of information in case that is my issue). This button as is works great. However, I want to now use this button as a trigger to start a pipeline by checking a box on the current record in addition to redirecting to the external webpage. I can get it to check the box but gives an error when trying to execute the next request to go the external site. I've used various methods I've seen on the forum, but it keeps giving me an error. Any help would be appreciated! Below is my latest attempt: var text URL="https://XXXXXXXXXXXX";var text mPower=SearchAndReplace($URL,"mPower",ToText([License
Hi everyone,I'm having some issues building the following: I need to build a table where a laboratory analyst can record analytical standards that they have prepared. I have one table that records reagent inventory and relevant reagent information like lot number, date received, expiration date, manufacturer, etc. For analytical standards that use only one reagent, this is simple to build with a one-to-many relationship. However, some standards are made with multiple different reagents. How do I get multiple parent records on a single child record? Any help would be appreciated!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.