Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello all, I'm still very new to Quickbase, and I could use some help, please.I need to be able to have Quickbase automatically extract all the customer information from a form into a CSV file once an application hits one of the "Approved" stages in the Kanban board, so we can then ideally FTP it to an external ERP. We can make is work with email, but FTP is ideal. This is an important part of the workflow. How can I do this?Your help would be greatly appreciated. Thank you in advance.
Hi Everyone! Great seeing you in April and looking forward to our next in person meetup in June. We're going to skip May due to Empower and looking forward to hearing about your Empower experience and questions when we meet next. In April, we had a great conversation about Quickbase, AI, and a FastField presentation by Industrial West.In June, we're excited to hear about what you learned from Empower and what questions you have after Empower. We'll also have a Quickbase FastField SME join virtually to answer all your FastField questions. Let's make the June meetup much larger than March and April so be sure to tell all your Customers and future Customers to come join us!
What’s the best way to normalize data in Quickbase without overcomplicating the app?
We have tables Company, Contact, Team Member, Opportunity, and Activity.An Activity is something that a Team Member does (for example a phone call or a meal) with a Contact from a Company. It may or may not relate to an Opportunity that is in work with (the same) Company.Right now we have a regular QuickBase form to add an Activity when needed. There are conditional dropdown fields on it so that once you pick a Company, it only shows the relevant Contacts and Opportunities. If you need to add a new Company and/or a new Contact in order to complete entering your Activity, you can.But sometimes, when an Activity is an event like a big dinner with multiple Contacts (maybe from multiple Companies) then the users have to go through the process multiple times.What they want is a single form where they enter the date and type of Activity, then add multiple Contacts (maybe from multiple Companies) and when they press enter - voila, multiple Activities are crea
Hey everyone, The Dallas Qrew will still be meeting in May, but we're switching things up and going virtual this month since many folks will be focused on Empower, Quickbase's annual user conference. We'll meet online on Thursday, May 28th at 2pm CST. Same Qrew energy, just from wherever you happen to be that day. Bring your Quickbase questions, ideas, lessons learned from Empower, or anything you're working through on the platform. Meeting Link: https://quickbase.zoom.us/meeting/register/KPOq6bwHTait6r9l45NJrA Come one, come all! Whether you're brand new to the Dallas Qrew or have joined us before, we'd love to have you there. Any questions, feel free to drop them here for myself and Jeremiah Glenn. Where: Virtual via Microsoft TeamsWhen: Thursday, May 28th, 2pm CSTWhat to bring: Your Quickbase questions, Empower takeaways, and your best energy.Who can come? Anyone who wants to learn some Quickbase and connect with other builders in the community.
I've been going in circles on this and can't figure out if I'm making a mistake or hitting a platform limitation. Would really appreciate any insight.What I'm trying to doI have a Rich Text field called [Jira ID - Description] that contains HTML like this:<p><b>Tool Link(s):</b> <a href="https://example.com/...">Group 1</a><br/> <b>Request Note:</b> N/A</p>I'm trying to extract the link text ("Group 1") using standard text formula functions.The weird partThese two expressions on the same field, same record give me contradictory results:Contains([Jira ID - Description], "Tool Link") → True Find("Oak Link", [Jira ID - Description]) → 0How can Contains find the text but Find can't? I've tried every capitalization variation, I've triple-checked the record ID in the formula checker, and the field preview clearly shows the content is there. Length() returns 800, so the field isn't empty.What I've already triedMid() — always returns blankL
Hey everyone, following up on the code-pages thread!Here's the first look at the thing we mentioned coming to the Exchange: The Hub (Lite). It's an app for your Quickbase realm — a single place to access, organize, and manage every app, with a release notes feed and feedback tracker built in. It really improves the way all users navigate through QB. This is definitely a labor of love for the Quickbase community.Quick walkthrough + a way to grab time with us if you'd like to see it live: https://levery.quickbase.com/db/bu77rzdv3?a=dbpage&pageID=19We're waiting on Exchange approval — but we've decided to go ahead and open installs to anyone who is looking to get their hands on it earlier. Would love to hear what you think.
I have a summary report which when I add dynamic filters to the report and filter like with status. The report goes blank then refreshes and display the data without filtering but on top the filter is still selected. I don't know if there's something the QB Engineering team is working on but I've tried on different reports and the menace is still the same. I am a cooked potato today please help if you ever had the same issue. Thanks in advance.
Hey everyone! Not sure if you all have spent much time playing around with the capabilities of code pages, but Kojo and I wanted to just say... there are some incredible things you can do in there. Especially when you leverage AI tools like claude / codex...A full customer-facing website — We just completely moved our customer-facing website (EOTI) into a code page. Yes, a real website, living inside Quickbase. A flappy bird style game — We also built a game with a live leaderboard (we'll be doing a full on competition at empower!)Something free coming to the Exchange — We have something really exciting in the works that we can't wait to share. It'll be free, and it's the kind of tool that could genuinely benefit anyone's realms!Feel free to reach out anytime!— Cam
I use to have an add on called exact forms and now Qbase bought the company, and the only way to access it is by upgrading QBase to higher package then we have which is thousands of dollars more plus the add on. There must be a different way to be able to have a template and print. another provider for an add on perhaps. I could even take the template and put it to excel instead of word. Does anyone have ideas?
Hello all,I just wanted to share how I was able to successfully set up a print button to print using a Dymo label. I have been searching online for a solution and I was being pointed to Trinity and that just wasn't an option with my organization. So below is the steps I took to get what I needed.Step 1Create a Formula Rich Text field with the address information. Below is the formula I used to get it my address in one field. Everywhere you see brackets, those are my field names. I have Name, Organization, Street Address, Street Address-2, City, State/Region and Postal Code. You will need to change those names in my formula to fit your field names. Also, we have some [Organization] that are very long so we I had to add some adjustments to the font if the character length got to a certain size. My formula is attached in the word document labelled "Step 1 Formula".Step 2Create a form on that table that specifically displays only the formula rich text field you created above. My field is n
Hi,I am trying to build a pipeline in Quickbase to upload a file from file attachment field to Dropbox whenever a record is created. Now I need to get back the URL of the file uploaded in dropbox to another field (text or rich text) in quickbase and store it there. How to get the URL?I want to then use this URL field in document template and sent it out. So, users can click on the link in document template, and it opens up in dropbox.Thank you
Hello Quickbase community!I'm stuck on trying to build a configuration where I can lookup & add multiple records from a child table, and add them to a parent table record.I have a primary table, Films, full of Film records. I used to have tags/labels for these records that I kept in a multi-select text field, but I now have more than 100 values, so I needed to create a related table. So, I created a new table, Categories.What I'd like to do is be able to add multiple Category records to one Film. I was able to figure out how to add 1 Category to each Film, but I wanted to be able to add 2 or more. In my screenshot, my Film record, 'Spider-Man: Brand New Day', has the Category record 'Franchises' attached to it. I also need to add the Category records 'Spider-Man', 'Actor | Tom Holland', and 'Actor | Zendaya' to the Film record. Shouldn't I be able to click a button (based on a Formula URL field) to add records one by one, which will then display in a mini table of related records?T
I am having trouble showing a formula sum as ‘percent’. The following formula returns the value as 73, which is correct. However, I need it to display as 73%.Round( ( ([Overall Satisfaction])*0.15+([Trust])*0.2+([Feeling Valued])*0.2+([Communication Quality])*0.1+([Personalization])*0.1+([Impact Perception])*0.15+([NPS Score])*0.1)*10 )If I change the field attribute ‘Display as’ to Percent, then it shows as 7300%. If I add to the formula to divide it by 100 at the end, then it shows the result as 100%.Round( (( ([Overall Satisfaction])*0.15+([Trust])*0.2+([Feeling Valued])*0.2+([Communication Quality])*0.1+([Personalization])*0.1+([Impact Perception])*0.15+([NPS Score])*0.1)*10)/100 )Where am I going wrong with my syntax on getting this to work? I have tr
Hi,We have a new-style grid report where users are trying to copy the contents of a field that has email addresses.While the email address appears normally on the report, when you copy it and paste it anywhere else (another field, into a Word doc, an Excel file, an email...anywhere) it pastes with the <a href="mailto: ..."> prefix tag and the closing </a> tag.We've attempted to strip out the html by creating a few other fields using the RegexReplace function (probably incorrectly), the SearchAndReplace function, and even just ToText function, but we're still unable to get the html cut away.We are able to copy and paste from a record just fine, but opening each record to copy and paste seems a bit backwards, when it's easier to export the report to csv and copy from there.I'm thinking this may be an issue in the new-style grid report only, but I could be wrong.Has anyone else run across this issue in the past and figured out a way around it?
Hey Everyone, The Dallas Qrew will be meeting up once again at the Workbox Coworking Space next to American Airlines Arena on Thursday, April 23rd. We'll be kicking things off at 3pm local time, wrapping up at 5pm and heading downstairs for a drink or two afterwards. Come one, come all! Anyone new to the Dallas Qrew should register here! Anyone who attended the March meetup should automatically have an invite on their calendar which we can use for your attendance tracking. Any questions, please feel free to drop them here for TaylorHardy and JeremiahGlenn ! Where: Dallas Victory Park Coworking When: Thursday, April 23rd, 3-5pm CST What to bring: Your laptop, your Quickbase questions, your best energy. Who can come? - Anyone who wants to learn some Quickbase and hang with some fun people.
Hello,Using the new-style forms and new-style grid reports, we are trying to get child records that are updated to subtotal on the parent form.I have a parent table called "Questionnaires" and a child tabled called "Allocations".On the Questionnaires form, users are able to enter a percent allocations using an embedded grid report tied to the child Allocations. Allocation records are created via Pipeline and users are only entering a percentage amount.We would like users to be able to see their total allocation so they know when they have reached 100%. I have added a summary report onto the form, but it does not update until the parent record is saved. This is fine and makes sense, however when the parent record is saved, there is a delay in totals updating.To get around this delay, I have created a "RunPauseRefresh" (borrowed from the ol' Magic Buttons app) and a "Calculate" button, which is an "Edit Record" button with a redirect to the code page. The redirect to the code page has a
Huge shoutout to one of our own for hosting us at the HD Supply space — seriously elevated the vibe! Even with a smaller crew (thanks to last-minute conflicts + sickness), the energy was thriving.We got hands-on with the new Intel Package toolset — putting it to the test with real prompts and creative use cases… including asking an AI Agent to bake cookies (no samples, but hey — now we’re inspired to build a baking request tracker app). We also rolled up our sleeves to tackle some real challenges from the group, diving into the platform together to troubleshoot and land solutions.And of course… BYOB (Bring Your Own Biscuit) did NOT disappoint. Early consensus: Martin’s and Bojangles came to win Proof that small groups can still drive big impact within the Qrew. The momentum is real, and we’re already hyped for June’s meetup with more attendance and more collaboration — get ready for BYOC (Bring Your Own Cookies)!
Have you ever had the email come across desperately crying out for help because "... the QuickBase App is broken..." as you stare at 45 separate apps wondering if they could try to be more vague... Well here is a button that can help. I use it on a bunch of my Apps and it auto emails me with the url of the exact page the user is on. It has been a god-send for me, and I wanted to share it with you all here, instead of doing a whole Empower presentation on it. First create a html page. I creatively named mine 'TicketPage.html'. Then throw in this code (replace what you need to with your own information)(This code has been updated to reflect the missing '?' after the destination email as pointed out by @Tim D below.) <!DOCTYPE html> <html> <head> <script> let oldUrl = document.referrer; var oldTable = oldUrl.substring(oldUrl.lastIndexOf('/')+1); var newBody = oldTable+'testin'; function handleonload() { window.open("mailto:support@myurl.com?subject=New%20Qui
Hi All,Hope you are having a wonderful day.I have created a Summary Report in the child table, which I wanted to embed into the form of the the parent record.However, the column widths in the parent's form appear completely different to its appearance in the child table.How do we adjust the column widths in the parent form?
I move file attachments to sharepoint and then grab the url link and add that to the record. When the attachment is a outlook message, it opens in the outlook instead of the sharepoint.Is there a way around this?
An individual is copied on several emails from MRT 2.0 that is not at our location. How can we prevent this from happening again? Our Admin is currently OOOffice and I do not have admin access as of yet.
Hi all—apologies if this has already been covered. I did a quick search but didn’t find anything that quite fits my situation.I’m a solo travel operator and have been using Quickbase for over 10 years to manage transaction accounting (air tickets, manifests, hotel stays, etc.). It’s been a great fit for how I run my business.Recently, my model has shifted a bit, and I now need to provide a client-facing portal for select clients. I know this can be done within Quickbase, but I’m looking for something that better aligns with my brand aesthetic and overall client experience.I’ve been testing Outportal and have already built a working version of the portal. I really like the look, feel, and functionality it offers. I understand this likely means going the custom API integration route, which I’m comfortable with.My question—before I go too far down that path—is this:Is there a similar solution that integrates more natively with Quickbase? Or is there a better approach I should be consideri
Hello, I am experiencing problems with form rules not working properly.On the first page of the form, in the Business Information section, I have a section with a field for type of ownership, and then another field for ownership percentages. (See attached Screenshot 1) I have a form rule for the “Type of Ownership” field which is supposed to hide the Ownership Percentages section if that field is blank, and to only display that section if one of the three type of ownership options is selected (Form Rule # 1) (See attached Screenshot 2). Once that ownership type is selected, depending on if it is One Member, Two Members, or Three Members, various fields are to be hidden and values are to be populated/changed in the fields that are then displayed in the Ownership Percentages section (Form Rule #’s: 2, 3, & 4).The way the rules are supposed to work are as follows:• Form Rule # 2: When One Member is selected, display Ownership Percentage 1 field, populate the value of 10
I am building an application that will be used to house business requirements for various outbound call campaigns. One of the aspects of the campaign is a questionnaire that needs to be filled out by the user post-call with the member. Most of the campaigns use the same question/response combinations but there may be times where a response option may change. What is the best way to allow users to choose from pre-configured question/response values (based on historical requirements) but also have the ability to request a change for their purpose?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.