Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello everyone! Just a quick reminder that today is the Pipelines Qrew meet up featuring MichaelFrishman but it will start at 1pm instead of the normal 12pm EST. I will be logged in to zoom at 12:55pm EST. Registration/login link: https://quickbase.zoom.us/meeting/register/tJEpd-6srTstGtaxNVjc0xeMzsZgzx0t9fXb Thanks and hope you can make it!
I have a form in which I would like to display the same image at the top of the form every time it is opened. Is this possible? Is it possible to control the size of the image?How is this done?Brian
I feel like I'm going insane this should be extremely easy. I'm trying to make a formula email field that simply gets populated with 1 email field (primary contact) if that's in fact filled out. Otherwise, populate with the referring attorney email field value. Both are lookups from two different tables. The email field for the referring attorney lookup is the key field for that table.For some reason QB is expecting a textlist, not text. I've tried all sorts of type conversions, as well as part/split functions (since Split is what comes up under Textlist Functions, though the email field would never have more than a single value in the first place). I know this is going to be ridiculously simple in the end.
I'm attempting to create a connection with Netsuite and I get this error message.ERROR: duplicate key value violates unique constraint "ServiceTableDefinitions_pk" Detail: Key ("SessionId", "SessionResourceId", "ServiceTableDefinitionId", "LCName")=(t20434735s121413_38826vFk1JV2DG6CAVTXW25SDDXSBW4NM, 1JV2V7HFGFHT8V7ZP11D3V5SK, , country) already exists.I don't know what it means.Any help would be appreciated.Scott
The Copy Record API does not appear to function with New Forms. a=GenCopyRecord Does anyone know if a fix for this is on the New Forms roadmap?------------------------------Michael Rose------------------------------
Is there a way to give permission to users who are not app administrators to create and update notifications?I'd like to have my future-anticipated team be able to create and manage notifications, however it seems that my current end users who have nearly universal access to my app but are not administrators can not get to that section.If it's not possible, I'd love to suggest that to be incorporated if possible since it would not interfere with the app's architecture in any way!
Hello Everyone! Just wanted to give folks a quick update: Quickbase Office Hours will be available only on Monday and Friday this week. No office hours Tuesday-Thursday of this week. If you need technical support, you can post on the discussion board here, the Discord channel, or contact our support team by clicking the "?" on the top right corner within Quickbase to open up a support case. Click here to learn more.
I have a form rule that automatically puts text into a rich text field but I would like the rich text field height bigger. How can I do that? I added the the formala rule to set the height to a certain number of pixels but it doesn't seem to be affecting it.
I’m trying to create a formula that calculates the completion percentage based on a series of multi-select checkboxes.For example, if there are four checkboxes and three of them are selected, I’d like the formula to return 75%. Is there a way to achieve this in Quickbase? Any help would be greatly appreciated!Thank you in advance!
I'm using the HTTP "Make Request" step in several pipelines to make HTTP calls from Quickbase to my applications API. The way you configure the URL and authentication information for that API is via the "Connection" where you configure an "HTTP account". I can see how to create a new "account" there, but I can't figure out where to update or delete those accounts. I've searched the Quickbase UI and couldn't find anything, and the docs didn't contain anything that I could find. I considered using "variables" to try to specify my URL and reference the variable in the "HTTP account", but that context doesn't seem to support variables, which seem like they were built for use in formulas, not pipelines. Can anyone tell me how to manage (edit, delete) my HTTP accounts used in my pipelines? Thanks!
We have an app for tracking form internal processes. There is a paper printout that will travel with a part throughout the plant. I want to add a barcode to that printout so when someone needs to update the record, they can just scan the barcode (we already have USB barcode scanners at all the computers). Is there a way to take the value of a field and create a barcode?
When making relationships between parent and children records I understand how to add additional lookups. But when you do that then those fields need to be "updated" when adding a new child. What I am seeking is a way that when a child record is created, and related to a specific parent, that the child record would show the value of additional fields from the parent.Example:Parent record has Name, Address, Phone Number, Favorite ColorChild record has Child name, lookup field to select parent which would bring down the Parent Name and Favorite ColorCurrently when setting the relationship I would connect on Related Parent then add the lookups for Parent Name and Favorite Color, but when actually creating the new Child record once I select the related parent, the Parent Name and Favorite Color are not populating. If I want those to display the value, I have to manually update those fields (thus not benefiting from setting the relationship to the Parent).What am I missing? This seems like
Hello,I have a form with two fields named "Year" and "Quarter". The Quarter field is a dropdown with options such as "Q1", "Q2", etc. The Year field is a numeric field where users enter a year (i.e., 2025).What I need help with is displaying a error message when users have duplicate Quarters for a single given year. Example: If a user has a record with "Q1" for the Quarter and "2025" for the Year, they cannot enter another record for 2025 with Q1. They may only select "Q2", "Q3" or so on for 2025.Hopefully I explained this well enoguh for someone to understand. If I can elaborate more, please let me know.
Hello!I cleaned up an app that I'm inheriting on Wednesday, and now am retracing my steps on a field that I *may* have renamed. I see the "field_update" in audit log, but is there a way to see what it was before the update?
Hello Qrew Members, I am reaching out to see if there is any interest for a Qrew meet up for those near the Twin cities of MN?
I'm pretty sure this is a simple many-to-many relationship, but my brain hitting a wall and cannot comprehend how to set this up.We have an app in development where employees can submit reports of things happening in their day to day. Each report is then "assigned" to a person or department from a Responder table to follow up. I most cases, each report will only have one Responder so I have a normal one to many relationship set up currently. Now, occasionally, we have a situation where there will be a Primary Responder, but another department/s or person/people are included for line of sight/further conversation, ie Secondary Responder/s. I would like to have two fields, one for primary and one for secondary so I can differentiate between the two when the Pipeline kicks out the email to everyone. Is this a simple many-to-many relationship or is this going to be a bit more complex? Thank you!
I will be creating a new app. In one table, is it possible to have a form with around 50 pages, and each page would have anywhere from approx 10 to 50 fields (probably only a few pages would have 30-50 fields, most pages would have 10-20).Therefore, the total number of fields in the form would be anywhere from approx 1,000 to 2,500. Of that total, around 200 fields would be derived fields (formulas). I would also like to have form rules that hide certain pages based on a field selection. NOTE: for each record, only about 60-100 fields would be populated.Are there limits that would prevent me from adding that many fields? Or could so many fields cause performance or other issues, like problems with form rules functioning properly?While it is possible for us to pull out most fields into other tables and connect to the main table using relationships, for our users ease of use and ease of reporting, we are hoping to contain all fields in one form in one table.
I have a report that needs to go out to 6 people weekly. But, each needs to see only their own section of the report. The report does have their name on each of the records. I don't see that the Subscription feature allows this, without writing 6 different reports different only in that they filter for one section. I can then use 6 different subscriptions to send them out. Wondering if there is a better way to do this. ------------------------------Charlotte Morin------------------------------
I am driving myself crazy on this. I have a user that needs to print a report but the print option is not showing. I remember this being a security setting somewhere but cannot find it. How do I enable printing for him on the report and/or table?
I am trying to build a formula in a table that pulls the current cost for a product based on an effective date, this is so that I can see the most current cost based on the a table that has multiple cost adjustments to products.
I have a form with multiple pages. The first page has the main fields, and remaining pages have additional fields.Is it possible to hide or show certain pages based on the value selected in a field on page 1? What I would like to happen:If Service field has value "A" then hide Page 3, Page 4 and Page 5. If Service field has value "B" then hide Page 2, Page 4 and Page 5. If Service Field has value "C" then hide Page 2, Page 3 and Page 5. Etc.orIf Service field has value "A" then show only Page 1 and Page 2. If Service field has value "B" then show only Page 1 and Page 3. Etc.
Hello Qrew Community! Maria and I are doing a community contest where the top three thoughtful replies can win a Qrew T shirt. What do they look like? Winners can choose the size and color of their Qrew shirt. How can I enter to win? Answer the following Question: Which of the four Bid Management Memes below do you relate to the most and why? Pick from numbers 1,2,3,4 below and share a paragraph of your story, a reason, or share words of wisdom related to the meme with the community. Meme #1 Meme #2 Meme #3 Meme #4 A huge thank you to RobSalaj for being our Quickbase Meme model. The Steelers Jacket is a great touch! Votes from the Qrew will be considered into deciding the 3 winners so be sure to scan the replies below this post and "thumbs up" the responses you liked! Check out our post about it on LinkedIn. Got questions? Feel free to reach out to Maria and EstherLaVielle Thank you and Good luck, everyone!
Hello, I'm trying to implement a regex replace to remove all special characters from a field. However, it's not working as expected. The result still shows certain special characters and line breaks. Here is an example.Could you provide the regex pattern you're using and the example text? This will help me understand the issue better and offer a more precise solution.RegexReplace([field_name],"[^A-Za-z0-9 ]", "")If you have any ideas on how I can refactor my formula, I'd love to hear them!
Hi all!I am my company's only remote employee! They are in Detroit, I am in Pittsburgh. I would love to connect with other QB users/admins in southwest PA who love all things QB! Qrew leadership supports my effort--thanks @BenSimonSo, if you are interested in connecting, just reply to this post or direct email me!
I am pretty new to qb and am currently trying to create an app to help my department track a student's requested thesis committee. The (hopeful) process: student will submit form with their identifying info, proposed thesis title, then choose their requested thesis supervisor, and selected reader, both fields pull from the same list of faculty (though if someone is chosen in one field they will not appear in list in 2nd field - that's for another time to figure out). So in trying to build something I came up with two different setups and am wondering which people think would be best. Which do you think will be better longterm. Attached are screenshots of both relationship diagrams. Hopefully they are decipherable.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.