Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm finding that collapsing the side bar on new navigation is difficult on Small mobile devices like iPhones and iPads. I'm looking for some upvotes on User Voice / Feedback to make sure the Product Managers consider those devices before they remove access to Top Navigation sometime in early 2025. https://feedback.quickbase.com/app/#/case/427172?currentProductId=3c9d7e83-da43-482e-a58c-14265037ecd0
I've used this same concept in multiple places and they work correctly. I have a couple of apps, and the current app is giving me a strange error message. I'm hoping someone can give me advice on handling this.Code from Button:var text url = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=d7s84zwcx5qf79csb72q6wrdjkd" & "&_fid_20=1" & "&rdr=" & //redirect parameter //URLEncode("https://exteriorsutah.quickbase.com/db/bug9w4puk"); URL meaning URLEncode(URLRoot()&"db/"&"bug9w4puk"&"?a=er&rid=" & [Related Invoice Header]); // Takes them to the invoice header in view mode, dr is view mode er is edit mode "<a class='Vibrant Primary' style=\"width:160px; text-align: center;\" href='" & $url & "'>Select for Pay</a>"Error code being received:<qdbapi><errtex
Another formula question for another report:There are several tables in the app that we are using and the 2 that I need data from Repayments (_DBID_PAYMENTS) is the parent in their relationship and Draws (_DBID_CASH_AND_NON_CASH_DRAWS) is the child.I need to sum all payments from the repayments table and have that information pull for a formula on the draws table. The draws dates and payment dates are not the same dates. Need the repayments table (_DBID_PAYMENTS) which has payment date and payment amount fields based on the following:Dates that are used to sum these payments to be are on or before the effective date on a separate table called cash/noncash draws (_DBID_CASH_AND_NON_CASH_DRAWS)ThanksJesse
Hi all, I am working on an app that calculates loans including deferred loans. Right now, if someone has not paid for a long time and the payment is less than the interest owed, the principle comes back as a negative number rather than a zero. (Current formula is payment amount-interest=principle). I need to make the formula show that there should never be a negative number for principle - just a zero if the amount paid is less than total interest owed. How can I limit the results to not get a negative number?------------------------------Jesse Edsell-Vetter------------------------------
I get a daily email in Outlook with a file attachment, is there a way I can get that file attachment automatically imported into Quickbase? I am able to connect/link my Outlook and Quickbase account and I see the email when I refresh in Quickbase, I just don't see a way of getting the file attachment imported automatically or at all.Derek------------------------------Derek Pipal------------------------------
I have a summary report that will total the duration of events by year. When the number of hours are greater than 24, it gives the total in days. I want the total to always be in hours. Is there a way to force showing the value in hours?Further context. This is an app to track continued-education/training requirements. The requirements for the various certifications and licenses are always given in hours. When you enter a training course or event, you enter the time in hours. I want to see the total in hours as that makes it easier to determine progress towards the required hours.
I have a QB rich text field which I am placing in the gmail pipeline channel body field. All of the rich text is appearing in gmail sends except for the images. The gmail is not recognizing the image even if the image URL is on a public domain. Any ideas how to get an image to appear in gmail via this channel?
So I've been testing writing QB to a Google Sheet whenever a record gets created. Tried testing when a spreadsheet is imported as that is how our users create records, but the pipeline triggers everytime each record is created which can sometimes create a bottleneck and some of the data not being transfered. In summary: ~100 excel lines imported - > ~100 records created all at once > Pipeline to transfer to Google gets triggered that many times within seconds -> bottleneck ->error -> Google Sheets missing some linesIs there a way to trigger the pipeline only once when a spreadsheet is created and loop through the records imported one by one? Or could I keep the first model and incorporate the Clock channel to ensure each one finished writing before the pipeline is called again somehow? Thanks
Hello Quickbase Community! Does anyone use Quickbase as a way to track completed and upcoming training? Would love to see how you all are using it for this function. I know LMS systems do this, but different groups in our company use different LMS systems for regulatory reasons. We are looking to keep all of the safety training in one spot for this reason. Thanks!Amber
After save, I want to stay on Record # 2 , not return to Record #1 which is what's happening now with code below.Here is my code (I am pre-populating some values in Record #2 from Record #1). The button resides and is clicked in Record # 1.URLRoot() & "db/" & [_Table Name] & "?a=API_GenAddRecordForm&_fid_265=" & URLEncode ([Costing Assigned To])& "&_fid_268="&URLEncode([Pricing Assigned To])Note: there is no redirect in my code.
I've been upgrading our existing dashboards using the new dashboard pages. For some of the report widgets, it seems that the report displayed is not remembering the users' settings for report column widths. My understanding is that I cannot set default report widths for other users. But if a user opens a report from a table, and adjusts the column widths, this is remembered by QB and the next time the user opens the report, the widths will be displayed based on widths set the last time the user opened the report. In the report widget on the new dashboard, the display appears to be independent of the user-specific report preferences. If they go to the actual report on the report table from the widget, they will see the report with their column width preferences. Also, while a user can adjust column widths in a dashboard report widget, they don't "stick". If you refresh the page or navigate away and return, the QB default widths are re-applied. I would think
Hi, Is it possible to sort the results from a formula query. I have a formula query to get list of dates from a table. I would like to get the latest of the returned dates. Is it possible to use options=sortorder-D in the formula query? var text Query = "{65.EX.'" & [PBG Number] & "'}";var number NUM = Size(GetRecords($Query, [_DBID_ACTION_ITEMS]));If([Active_Ind] = true and $NUM > 0,ToText(GetFieldValues(GetRecords($QUERY,[_DBID_ACTION_ITEMS]),2)))
parent table - TAKE/OFFs child table - TAKE/OFF CALCULATIONSTake/Offs create record in Take/Off Calculations using a pipelineTake/Offs FIELD [PLAN OR OPTION NAME] contains MASTER is the only field "pipelined" into the TAKE/OFF CALCULATIONS tableNow, I need a PIPELINE to add 5 additional records duplicating same [PLAN OR OPTION NAME]......New records will then contain selections from multiple choice field [CALCULATION TYPE]In summary, starts with this record:TEST.PLAN.MASTER - no data in CALCULATION TYPE fieldNeed:TEST.PLAN.MASTER with selection from Calculation Type field - WALLS.INTERIOR andTEST.PLAN.MASTER with selection from Calculation Type field - CEILING.INTERIOR andTEST.PLAN.MASTER with selection from Calculation Type field - WALLS EXTERIOR andETCthank you
In a Pipeline, you can use the Jinja urlencode filter to encode a value that needs to be safely encoded for use somewhere else.However, how can you use the URL Decode function? I am used to Python, JavaScript, and other languages where you can easily use a URL Decode function. In fact, it seems in the full subset of Jinja filters or function, there actually IS a urldecode but that Quickbase hasn't implemented it in their build of Jinja for Pipelines.Any ideas?Desired: {{a.json.url | urldecode}}
I am entering a default value, but the sample data is not reporting and when viewing outside of Field Properties, shows blank. I have this function working on two other similar fields, but this one refuses to update. If I can provide any more information, please let me know.
Hello. I have a report/table that has about 32 items that it can have concerns for. I want to see if its possible to have a field where it can let you know which items are pending from all 32 options without manually having to do Multiselect field or scroll all the way down the reports just to see which ones have been selected. Not sure if a formula field can work or would it be a pipeline?
Does anyone have a way that they save/archive their app structure/build before deleting an app? I'm doing some clean-up in our realm, and we have a bunch of old, unused apps. I want to archive/delete them, but I'm thinking of the off chance someone comes back and says "remember that app we had? can we get something like that again?". I'm thinking I could use the new solutions APIs to get the QBL exported, but that doesn't support reports, forms, pipelines, etc. yet. Just curious what others' app archive strategies are!
Hi all, is there a way to do this formula queries? I have a table of people who have child residence & employment records, with start & end dates for each, as well as a numeric field that summarizes each timeframe in months. I need to query for all child residence & employment records related to each person, find any potential overlapping timeframes between the 2 tables based on start & end dates, and sum the total # of months from the Duration (months) field from applicable records. Essentially I need a final number in months of time each person provided to us across 2 tables, so any overlapping time would basically get deduped out. I also need it to be smart enough to recognize some of these timeframes are not contiguous and contain gaps, so we might not have any date for particular person from 2010-2015, but we do from 2005-10 and 15-18, so any gaps would need to be excluded from the final count.
I am trying to accomplish this:I want a report that will show me clients in a week how many times a record was made with the filter No ShowSo a client is booked - he does not show on Monday, on the form he gets a Q of no show. then he shows up on Wed and we proceed with what we do. I want to run a report of only those customers. Now I can run a report that shows me all Q that = No Show and sort by Client but it only shows the no shows it does not show any of the other time they might of come. If I don't use the filter no show then I sort and group by customer and it shows me everything and then i can see it but there are hundreds and eventually more. I have a summary field that counts the qualified tours as a 1 and the no show as 0 but other things are 0 as well (other unqualified) QB tech support is sort of helping but it's not working and I am pressed for time. They originally said this - So I created a summary field on (child record) and filtered by created
Hi,I have a report that asks the user to input a value and returns the result.I am searching for Asset records assigned to a user, or client. Because these clients are formatted with "HFT" and leading zeros for a number less than 3, the clients look something like these examples: "HFT055", "HFT006", and "HFT545". I made a formula field that removes the "HFT" and appends leading zeros, and have the report set to "Store Search" (my formula field) contains "Ask the User". My goal here is to allow the user to only input the number, not HFT or leading zeros.Formula: "HFT" & PadLeft(ToText([Related Client]), 3, "0")This current setup works in a sense but also pulls up other records due to the contains criteria. When I change the filter to "Is Equal To" nothing shows up.Can this work so the user inputs just a number, such as 55, and it would pull up an exact match of all assets assigned to user HFT055?
I would like to create a URL formula button -- that when clicked it will run a table to table import --- this is what I have created (did not work) var text URLONE = URLRoot() & "db/" & [Table ID] & "?act=API_RunImport&ID="&[TableImportID]&""; $URLONE
Hey there!I am almost certain this has been asked before, but I have been searching for hours and can't find anything.I am building an app that tracks flight delays and auto assigns a manager for follow up based on the departure airport. For example, I need the formula to populate Manager A if Departure Station is JFK, LGA, EWR, BWI, DCA, or IAD or to populate Manager B if Departure Station is DTW, ORD, MDW, MKE, or MSN. And down the line for all of our airports and managers.I have something that is working during testing, in a formula-user field so it can be the basis of email notifications when they have been assigned a new delay. But we have hundreds of airports, so there has to be an easier way than a line item for each individual airport.If([Departure Station]="JFK", ToUser("ManagerA@Company.com"), [Departure Station]="LGA", ToUser("ManagerA@Company.com"), [Departure Station]="DTW", ToUser("ManagerB@Company.com"),[Departure Station]="ORD", ToUser("ManagerB@Company.com"))
Hi,I have 2 tables PROJECTS related to JOBSWhen I add a JOB to the PROJECT (using the Add Job URL) I would like for a specific form to open In the JOBS Table. Currently "Main Form" opens. I would like for the "Job Start Form" to open. I prefer not to create a role to use this form.Thoughts? Thank you
Hey All,On QB forms, there is a next button/link, that when clicked it would advance you to the next record on the report.Even if there aren't any changes made to the record, we are getting this pop-up message. It only occurs when in edit mode, not just viewing records. We have not had this issue until sometime last week. Also, it is only occurring on a select few forms? Does anyone know what drive that 'next' button and how to change the behavior so that it does not throw that dialog box?I know there is the native Save and Next button, but users are accustomed to the ease of just using the next button.Thanks,-Scott
Hi,I'm trying to create a text formula field that would compare 2 text lookup fields for an employee name. So if there isn't a value in field A, it will pull a value from field B or vice versa. For reference, these 2 fields have a relationship between tables, and in some instance the name is populated in one table and not the other. Field A: Field B: If anyone has suggestions, please advise as I've tried several different formula functions and can't get this to work as I expect.Thanks,-Scott
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.