Recent Discussions
Restrict Order Line Items to Supplier Part #s
I have an Orders table with a related Order Line Items table. The Orders table is also related to a Supplier Table. How would I restrict the Supplier Part# dropdown field on the Order Line Items to only show Part#s for the related Supplier?0likes0CommentsRecords that contain several sub items
I have a Purchase Order (PO) table connected to Cost Items (CI) table. In the PO form, there is an embedded report for users to easily add items (see photo 1). There is also a section in the form for Billing that shows the same embedded report where they can input Bill % and all of these bills should be in the Bills table. Every Bill record can contain any of the cost items assigned with Bill % until it reaches 100%. For example: Bill #1 - contains CI#1 with 60% Bill #2 - contains CI#1 with 40 %, CI#2 with 50%, CI#3 with 70% Bill #3 - contains CI#2 with 50%, CI#3 with 30%0likes2CommentsNeed help resizing pop-up window
I am trying to my Change Status field to a Formula Rich Text field from Formula URL field because the popup that opens when clicked is never the correct size for me. This is what I was able to cobble together with my limited qb knowledge but it gives me and error saying it doesn’t allow javascript. I can’t suss out why. Any ideas? var text RID = If([LEAVE REQUEST - LEAVE STATUS]="FINAL APPROVAL", "", "%%rid%%"); // only displays button if decision is ‘pending’ or ‘rejected’ var text URL = URLRoot() & "db/" & [_DBID_DECISION_STATUS_CHANGES] & "?a=API_GenAddRecordForm&_fid_26=" & URLEncode ([Record ID#])& "&dfid=11" & "z=" & Rurl(); // when clicked opens popup window with DECISION STATUS CHANGES form #11 – Add Form Temp "<a class='Vibrant Success' onclick=\"window.open('" & $URL & "','Edit','width=800,height=700')\">MAKE DECISION</a>" // link code for popup with dimensions for width and height0likes3CommentsPass international phone format while updating phone number with Quickbase Restful API
I need to pass phone numbers from a 3rd party app to Quickbase via the Restful API. We receive phone numbers from outside the United States, so I need to pass in the country format as well as the phone number. After all my research, it seems like you can only change the country format through the Quickbase user interface. However, if there is a way to not have users do double the work, that would be ideal.0likes0CommentsFormula Assistance
Can't get this to work: [Job - Project - GARAGE.NO SAND]=true and [Task]="SAND",([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], [Job - Project - GARAGE.NO PRIME PT/UP]=true and [Task]="PRIME P/U",([Job - Maximum FIELD BOARD COUNT.TO PAY]-24), [Job - Maximum FIELD BOARD COUNT.TO PAY], thank you0likes1CommentIs it true you cannot add a duplicate personal report name per App?
Asking for a friend, A coworker just pointed out he is getting a duplicate report name error from Quickbase when he tries to name a personal report the same name as a report in a different table. For example there are 'temp' reports in every table in the App and never a problem. He has a 'temp' personal report in one table. When he tries to add a 'temp' personal report in a different table, he gets a duplicate report name error. Is this known or does he need to clear his cache again?0likes2CommentsFormula Help
Hello, I need help combining text fields into a formula(s). Here are my formulas: [Finance Disposition]=""&[(Text) PipeLine Value Requested]="<$500,000"),"YELLOW") I'm getting the operator "=" can't be applied on types bool, texterror message [Current Status]="Submitted",[Finance Disposition]="",[(Text) PipeLine Value Requested]="<$500,000","Red") I'm gettingexpecting text, but found boolerror message1like3CommentsA way to look up a previous Record ID's [Date Created] Field
Hi, thank you in advance for any help, I am currently trying to figure out a way to look up a previous Record ID's date created and calculate the time between the old record ID's [Date Created] and the new Record ID's [Date Created] to calculate the time between for an SLA report function. For a description: I have 1 record that has an imbedded record called "Change History", Inside this change history, It logs any status changes that happen throughout the order. For Example: 123 John Street (Order Number #27) had a job status of "On Hold", When this changed from on hold to "In Progress" a new change history is logged which would look something like the following: Embedded report showing all records relating to order number #27 Record ID: #71, Date Created: 28/10/2024 14:22PM Order Created - 123 John Street Record ID: #84, Date Created: 29/10/2024 08:32AM On Hold - 123 John Street Record ID: #106, Date Created: 29/10/2024 08:52AM In Progress - 123 John Street What I want to do is work out the duration between the new Record ID(106)'s Date Created and the old Record ID(84)'s date created (I want to use this formula to do the same for Record ID 71 to Record ID 84 but its off the same basis) So the end result would return a value of 30 Minutes. The reason being is I am trying create a countdown timer which is straight forward but once this record is no longer the newest record I need to find the time taken between the 2 fields.Solved0likes4CommentsBest practice for using @mention in a log rich text field.
Anybody have a best practice on using the 'Mention' feature in a log rich text field? My use case is: A rich text field w/ log edits turned on is used as a collaboration tool for team members to provide updates and ask each other questions. They mention each other in the comments and receive an email when they have been mentioned, via the handy 'send to users @mentioned' feature in the new notifications (see image below). However, when the 'Log edits' setting is turned on, Quickbase will email ALL the users who have ever been mentioned, when really we want just the person/people who were mentioned in the most recent comment. My workaround for this is to create a formula field to parse out the most recent comment and then a webhook or form rule to enter this value intoanother rich text field, with the @mention feature turned on. This last rich text field is used in the 'To' setting of the notification. This is a lot of work to simply use the mention feature! Is there a better way to do it that I'm missing?1like0CommentsLine Graph (y-axis numbers)
Does anyone know if there is a way to make the Y-axis numbers the same on line graphs? I have a screenshot of my graph, and the right side starts at zero and goes up by five. The left side is more bizarre and goes up by two then by three. The only number that is the same is fifteen. For us, this graph would make more sense if both sides had the same numbers. Thank you, Bart0likes0Comments