Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi all, sort of flummoxed by this because I consider myself an advanced builder so am surprised that I can't figure out how to do this and the forums seem to be filled with javascript based suggestions that no longer work in formula fieldsWhat im looking to do is simple. I want to have a button half way down a form that works exactly like the native "Save & Keep Working" functionality. The reason I want this is because I want people to refresh the page to see an additional tab controlled by a form rule that is based on some of the previously entered dataSo how can i add a "Save & Keep Working" style button? What formula would I need to do this?Thanks------------------------------Process Q------------------------------
Is there a way to print a Gantt report? Thanks, Diane------------------------------Diane YounkerAssoc Director, Study Start-UpVanguard ClinicalHouston TX------------------------------
Currently percentages are sums instead of averages on the "Total and Averages Row" for my table reports. Having an average of my percentages but a total of my other numeric data is what I am looking for in this line. Is there a way for %s to be averaged on that final row instead of totaled? Screenshot for reference. Thanks in advance! ------------------------------Jen Black------------------------------
Hello, I have a report where each record is a building. The information is broken down to show where region the building is in (there are four regions) and then show the risk of four different areas within a building and assigning a risk level.Users can rate those areas as high, medium, low or complete. I need to show within a summary report for each region how many of these are high, medium, low or completed. I have tried stacking an If() formula but it currently will override later statements and not produce the correctly totals. I have a formula that looks and summarizes for each record how many have matching values: Sum(If([Area1 Risk]="High",1,0),If([Area 2 Risk]="High",1,0),If([Area 3 Risk]="High",1,0),If([Area 4 Risk]="High",1,0)) Is there a way to use this information to help summarize and show the correct totals? Here is what each value should be totaling: Completed: 94 Low: 66 Medium: 75 High: 49 Total: 284------------------------------Sarah Driscoll-------------------------
Hello, I have a table that has a "Warehouse" field and a "Department" Field. I also have roles setup based on Warehouse i.e "California Shipping Manager". I was wondering what the best way is to limit the "California Shipping Manager" role to only be able to view records that have "California" as the location and a set of departments that manager manages? I.e. "Shipping", "receiving", etc. thanks Brian------------------------------Brian Dunk------------------------------
I have an EOTI to collect some data and while the web version works exactly like we want, the mobile version shows the native save and close buttons, as well as an ad for the QuickBase mobile app. How can I hide these? It's very important as the native save button breaks the workflow we are building and I need the user to use my custom save button as it redirects to a 'thank you' page. Anyone figured this out yet?------------------------------Jeff Peterson------------------------------
My gauge chart shows 0 # of Projects, but in the upper right it says there are 3 records. When I click on the gauge chart, it does open the drilldown report showing the 3 records. How do I get the gauge chart to show 3?------------------------------Amy Gosz------------------------------
Hi, Can I click a section of a pie chart, and then trigger to apply a filter and refresh a report show in the same page? Like this example below, instead of open a new page in a new browser tab by clicking the pie chart, I want to click on the red sector in the pie chart and then the lower table list will show only the record of this sector? Any idea how? thanks for sharing any opinion.------------------------------Kinson Lam------------------------------
Hi I have set up a single pipeline for one user which is working, however, I need to set up multiple users with their own email. How do I connect a pipeline to a user? There is also one user who had two email addresses, I am assuming two pipelines but need to know how to set up in QB. Thanks------------------------------Jessica Matenga------------------------------
I have a Quickbase table with 3 fields Customer Id, order Id, Book Id. I need to add a Formula field to flag records if the Book Id exists in the table with a multiple combination of Customer ID and Order Id. How Can i Achieve this? ------------------------------Anitha Jeevarathinam------------------------------
Hello, Is it possible to have multiple quote for a single project in Quick Base?------------------------------Sylvia Sabastin------------------------------
I'm having an issue. This is working in old forms but not new forms. I have a button that opens a popup window, where you enter data and save the record, then it calls a code page to run a timer while a pipeline runs, then closes the popup window and refreshed the page you executed from. On the new form it's not calling the code page and just navigating back to the page you pressed the button on within the popup window. I think it's a bug. The URL in the popup window window is different on the new form. It's adding another iteration of NextURL and adding a &page=1 to the end. Has anyone else experienced something similar and have a solution? I put in a support ticket in case this needs to be added to a bug report. URL in old form popup: https://myrealm.quickbase.com/db/xxxxxxxxx?a=API_GenAddRecordForm&_fid_7=546394&_fid_10=PGE&NextURL=https%3A%2F%myrealm.quickbase.com%2Fdb%xxxxxxxxx%3Fa%3Ddbpage%26pageid%3D95 URL in new form popup: https://myreal
Hello - For dropdowns that change values, it is helpful to use a separate table to store the values in and then use a field to mark values as active (allows you to drive which options show in the dropdown but allows you to also maintain historical data values). Is there a way to do this with a multi select field? The goal is to allow me a way to tell Quickbase which values to show, allowing the options to change over time and maintain historical records while not clogging up the dropdown choices with things like "retired do not use - Option A".------------------------------Thanks in advance,Jennifer Paschal------------------------------
I am trying to create a Pareto Chart. I've selected a "Line and Bar" for the Chart Type. I am trying to figure out how to add the line graph that showcases the cumulative percentage of events.I assume it will need to be added into the "Report Formulas"...I keep wracking my brain trying to figure it out.Any advise or help?------------------------------Kelsey Poole------------------------------
Is there a way to freeze the first column and the top row in summary reports? This automatically happens in table reports. I can't understand why it wouldn't happen for all reports.------------------------------Brian Hunot------------------------------
I have an existing list of line items in a table. Thru a pipeline these lines items are bulk added to a Parent table Order header record. Is there a way to assign a unique line item #'s to each order's line item, starting with line item # 1. (so can't just show record id for each line item). The catch here is that that the user may add a line item individually (not in batch with the pipeline) to the order and that added item must equal the last line item # plus 1.------------------------------Cloudbase Services------------------------------
I want to create a button when the Appover of the request is not available, then admin can click on that button to change the approver to new and submit the request. Suggestion will be helpful------------------------------Nilesh Khabade------------------------------
When we add a new customer Project to our Quickbase database, we currently have to manually duplicate a "Template" dashboard and the associated standard reports and charts across the various tables. This is very time consuming as you need to manually go in and copy each page/report/chart, rename the copy then link report/charts on the new dashboard pages. Is there a way of duplicating template pages/reports/charts and renaming to a new project name and link on the new dashboard pages? I was thinking of a new table where you could enter the new Project name and a button. I looked at pipelines but that appears to only handle tables. Would this require maybe Javascript or is there another way? Thanks.------------------------------Grant K------------------------------
Hello, I am wanting to add a Report with a formula for this. It takes Todays Date, adds 2 days and gives a report that has "Return Date" that matches the date from 2 days from today. Example: (08/22/2023, 2) = 08/24/2023 Report will give any "Return Date" that has the date 08/24/2023. I am having a hard time doing this and probably over thinking. Thank you!------------------------------Eric Arellano------------------------------
I have a user field in table that I would like to clear directly with a URL formula field. I know I could use a button and a pipeline to accomplish using the {{CLEAR}} in the pipeline, but then the user needs to refresh to see the result. Does anyone know how to write this formula? Here is a Link to a similar question in discussions------------------------------George Bramhall------------------------------
I have a formula URL button and I'm trying to clear a Multi select field.I always just use this type of syntax to clear either numeric, text, date, user et=c fields. But when I try to clear the field I get the API error message that I must supply a valid choice for field ID 357.Is there some trick to clearing a multi select field type with a formula URL button? Here is a portion of my button formula.var text ClearSelectedPendings = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]& "&_fid_357=";------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------
I've added a 'related record' field to a table, and by setting a relationship between the table and itself, have been able to use the record picker to select a related record when needed. The record where the update is made will link to the related record. This is working fine. Is there a way to have the 'related record' field in other record update automatically to link back to the one where the manual link was made? As in, if I select '150' in the 'related record' field of record 200, is there a way to have record 200 update so that the 'related record' field now contains '150', without making the change manually?------------------------------Michelle L------------------------------
Hello, I have a numeric-formula [Result fixed] field that returns a null value based on whether another numeric [Result] field is greater or less than defined numeric values. Moving forward I would like to not have the formula return a null value, but instead actually display the less than or greater than sign and a value. For example if the [Result] is <4.0 (i.e. 3.5) then the [Result fixed] would display "<4.0". Can I change the [Result fixed] from a numeric-formula field to a numeric-text field and if so will it change how past data is displayed (data entered prior to the change)? ------------------------------lrowe------------------------------
I am creating a project management platform, and am hoping the community might have some suggestions on how to record how long a certain field held a value. For instance, each project will have particular stages that it will go through, like: Initialization, Planning, Engineering, etc. I would like to be able to record how long the Stage field was in each of these drop down selections. So, how long it was in Initialization before it was changed, then how long it was in Planning before it changed, then how long it was in Engineering before it changed. Does anyone have a step-by-step on how to do this? I'm still fairly new and appreciate any help you can provide!------------------------------Cassandra Friend------------------------------
I have been doing things this way for a while. Is there a better solution? JOBS table related to JOB SCHEDULES table I enter the [Start-Hang Date] on the JOB SCHEDULES table record I want this field to show on the JOBS table record. I have created a relationship JOB SCHEDULES table to JOBS table to make this happen...creating a circular relationship...not ideal from what I understand. Is there another way to accomplish this? thank you ------------------------------BuildPro------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.