Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
We have a couple of different apps in QB, but most of my users only have access one. They will only ever use one QB app.Is there some way to set QB so when they login it just takes them directly to their homepage of that one and only app? It seems silly that the login screen opens to the "My Apps" view where they then have to click on the app. There is no other app they could click on. Is there a way to skip that step?For myself, I have several apps so it makes sense to choose from the list, but when the list is only one, why not jump right into it? If it's possible, I'd love to know what I need to do to make it happen. Seems like there should be a place to select that option.Thanks,------------------------------Kim G------------------------------
I've long struggled with the best way to accomplish this. I've tried a few things and don't love any, and I am wondering what other people do.I have a multiple choice field, that I want to use a dynamic form rule to change, dependent on other fields changing. The issue is this:If I say, when Field A is not blank, change Multiple Choice to X selection, that works. However, if I accidentally choose wrong, and change field A, it does not update my multiple choice field.I can't uncheck the box at the bottom (fire only when changes) because there are multiple rules to change the multiple choice. If that is selected, then the other rules are over ridden dependent on order.Truthfully, I need a, 'When Field A Changes' condition, but that doesnt exist. Or I need to only fire it once the record is saved, BUT only if Field A was changed during that edit.What solutions have others come up with?------------------------------Mike Tamoush------------------------------
Hi friends,I have a pipeline that executes a lot throughout the day (roughly 2,000 executions per day). These are triggered by a remote webhook. I need to troubleshoot a few of the executions to see why updates to QuickBase aren't occurring like I expect. Unfortunately I am not seeing errors on these so they must be going through a logic path that I don't expect within the pipeline.In order to research this, I need to find the single execution I'm looking for and am wondering if the community has any suggestions on how to find that "needle in the haystack". I've looked around for an export or filter option but haven't found anything. Does anyone have a solution they could share on how to find the 4-5 problem executions within 2k? Scrolling through the activity feed is unmanageable...Thanks all------------------------------Jeremy LahnersLeadBaller------------------------------
I have a table Patients (populated through .CSV import in GDrive). I want to connect this table to States so we can track how many patients we have in each state. The Patients table has a state field which contains a state name. I created a States table, which has the State names as the primary key. I want to just make this the reference field for the relationship. How do I do this, or should I approach this differently?------------------------------Solace Sonder------------------------------
Does anyone know if after an import, you can redirect to a different screen? For example, now it takes you to "Import Results" with a button that says "Go to the application's dashboard". Is there any way to override any of that?------------------------------Jessica Feauto------------------------------
Hi all,I'm trying to use the basic functionality of a connected table. Every time we drop a new file in this folder, I'd like the table updated. The problem is I can't seem to get QB to recognize the .csv file. I correctly connected it to my gmail account, and Quickbase automatically created the "QuickBase Sync" folder. I opened my Excel, and saved it as CSV UTF-8 delimited. I then dropped the file into in the QuickBase Sync folder in the web version of GDrive. That was about 15 minutes ago and QB still doesn't recognize anything in this file. What am I doing wrong?Edit: Nevermind, I didn't realize it needed another folder inside Quickbase Sync. ------------------------------Solace Sonder------------------------------
I have the following Rich Text button on a form:var text URL= "https://dredgitenvironmental.quickbase.com/db/bskxipxmt?a=q&qid=27\n\n&ifv=1";"<a class='Vibrant Success OpenAsPopup' style='border:1px solid #000000; background-color:#000000' data-height=500 data-width=800 data-refresh=true href=\"" & $url & "\" > Select Employee </a>"It pops a window that prompts the user to enter (any portion of) an employee's name (Good Window #1). This frame/window has minimal information and is unobtrusive. Unfortunately, when a user enters text it pulls back a report (#27) that has all of the browser header information. It makes for a visual mess and is distracting (Bad Window #2).Can I strip the header information out of Bad Window #2, so it looks more like Good Window #1? If so, how? Thanks in advance.------------------------------Keith Hendrick------------------------------
Do some know what is the difference between Look Up and Search when using them in pipelines? I was told that Search can slow down the system, is this true?------------------------------Claudia Sullivan------------------------------
Is there a way to achieve the following? I have records that require multiple approvals, let's call them Approval 1, Approval 2, Approval 3. There are several users who are able to complete each approval type; they're assigned the user roles Approval 1 Approver, Approval 2 Approver, etc. Each approval type only needs to be approved by one of the approvers who has that role. The user approves via a dropdown menu in the applicable field for that approval type.I want to set up a report that filters to show each user only the records that are awaiting the approval type that that use is able to give. So, if the current user is someone with the Approval 1 Approver role, they would see records where the Approval 1 column is empty. I know this could be easily done by having the users filter the report themselves, but is there a way to automatically filter based on the user that is signed in and their role? Ideally I'd like to have one button that any user can click to instantly
I would like to be able to select multiple records within a report and then create a new report based on those selections but I can't find out how to make this happen, any suggestions?Thanks!------------------------------Kelly Lyons------------------------------
We are trying to add events but when we do, our recipients' calendars events, added by our outlook channels, aren't displaying the time zone relative to the user just the invite date/time. Anyone have a fix?TIA------------------------------Blake Taylor------------------------------
With the help of the Quickbase Junkie, I believe I know how to create a CSV file using a Pipeline. Is there a Pipeline Channel to place that file on an FTP file path?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
Good morning,If a Pipeline is set up based on selecting "Run" to begin your Pipeline activity, can others access to run as a backup? Or only the person who set it up?------------------------------Kathy Benjamin------------------------------
Can we add bootstrap CSS to a code page in QB ? Aric Walker Principal-Solution Architect TECHNOLOGY & OPERATIONS AT&T Services, Inc. 500 North Point PKWY ALPHARETTA , GA 30005-4136 US M 678.447.6241 | aw9578.att.com
Is there an image that matches the checkmark for the checkbox field?Currently I have some fields that are checkbox fields which leaves the checkmark symbol in the first two columns, but I have a formula in the third column and added the closest image I could find. It would be nice if I can get it to look uniform.The first two columns does a checkbox field that will have a check if another field has a date. The third column does a couple if/then statements. First it will look if a field has an answer of "yes" or "no." - If the answer is "yes," it look to see if a date has been filled out in another field. If there is a date, it will be return the checkmark image. If there isn't a date, it will stay blank.- If the answer is "no" it will show "N/A"Thank you!------------------------------V W------------------------------
Hello,I was wondering if there was a way to "Group By" [field 1] and then sum [field 2] within a QuickBase pipeline? I would be happy to provide additional information, I am just trying to keep it simple.Thank you------------------------------Shane Miller------------------------------
Sometimes you may not want the "bubble" appearance of the native Combined Text Summary field on a report. Here is a fun formula to change the appearance of a Combined Text Summary field into a vertical list. var text CombinedText = ToText([My Text Concatenation Field]);var text RemoveSpaceAfterSemiColon = SearchAndReplace($CombinedText, "; ",";");// substitute new line for semicolonSearchAndReplace($RemoveSpaceAfterSemiColon,";","\n")
Can I take a dashboard and give it a URL to display on my website?------------------------------Jason Beaver------------------------------
Is QB capable of sending SMS notification? If so, how would I go about setting this up?
Hi, this is my first time on the community, so I'm hoping I'm doing this right. I have a problem I'm trying to solve with a record that is created via a Pipeline looking for changes in another app. Here's the structure:Two apps: App A and App B. App A has a field (Text - Multi-line) called [Highlight]. When a record in App A is updated and the field [Highlight] is changed, the Pipeline create a new record in App B and populates the value in [Highlight] of App A in a field (Text - Multi-line) called [Reported Highlight] in App B. This seems to be OK and looks good when you view it in a form or report. However, here's where the problem starts to arise. I have a Formula - Text field called [Reported Highlight Formatted] that adds a leading "- " to the [Reported Highlight], and searches and replaces a "\n" with a "\n - ". This should create a bulleted list for multi-line values that have multiple carriage returns. Here is the formula for
When I am creating a summary text field on my parent table, is there a way that I can limit the child records to the most recent 3 records?Parent (Invoices) -> Child (comments)We only want to see the 3 most recent comments in the summary field.
I am looking for a URL button that can be used on multiple report. Forumla URL button to edit the record (Easy enough) URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] *The user will make changes or updates to the record* Now, I want the ability for the user to click a button to save the record & return them to the report in step 1... The last part is where I am struggling. I can do a save button that returns them to a specific report but I need the button to redirect them to *wherever* they were when they clicked the edit button in step 1. Any help with a possible solution would be greatly appreciated!------------------------------Amber Polston------------------------------
Good morning,I've created a pipeline to write a tracking number to a table, but I only want to create unique records. There may be many items with the same tracking number, but I only want to write it to the table once. Is there a criteria I can use in my pipeline to check for this?Thank you,Kim------------------------------Kim------------------------------
Question/Scenario: When creating/updating Client record How do I implement a solution that will allow me to: After Selecting, Medical Code = Code 11)How do I iget the code Description to default?2) How do I get the Doctor field to allow selection from Multiple Choice List defined in Medical Code Table associated with the specified medical code3) How do I get the State field to allow selection from Multiple Choice List defined in Medical Code Table associated with the specified medical codeTable Structure: Table: Client Fields = Client Name, Medical Code, Code Description, Doctor, State Table: Medical Code Medical Code (TX) Code Description (TX) Doctor (Multiple Choice) State (Multiple Choice) Code 1 Code Description for Code 1 Doctor 1 Doctor 2 Doctor 3 Doctor 4 GA VA SC TX Code 2 Code Description for Code 2 Doctor 1 Doctor 7 Doctor 3 Doctor 9 SC TX Code 3 Code Description for Code 3 Doctor 1 Doctor 3 Doctor 9 GA TX MA Code 4 Code De
I have a table with a relationship to itself. The table is Inspections. We inspect an asset, and mark satisfactory or deficient.If the asset is marked deficient multiple times, we link them together via a relationship to itself. The really easy way to do this would be to have a 'master deficiency' with the similar deficiencies as children. Unfortunately, I had trouble with this concept because it was hard to force people into choosing a master deficiency, sometimes the 3rd time it was marked deficient, people would erroneously make that that master, when there already was a master...etc.I got around this issue by forcing users to 'daisy chain' their deficiencies. ie: DF1 is parent to DF2, which is parent to DF3, which is parent to DF4...etc...This is working great, but now I want a formula that can show all linked deficiencies in a list. But how can I have a formula, or query that finds any Deficiency in the daisy chain??------------------------------Mike Tamoush-----------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.