Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Has anyone been able to successfully use MS Power Automate w/Quickbase?I have been dabbling with it, but the web recorder does not appear to work--gives me immediate errors.------------------------------Spence Lloyd------------------------------
We are seeing unexpected behaviour with form rules on a legacy form. The form contains a form rule that makes several date fields required - I'll call them A, B and C.The rule was set up so that the fields would be made required in the order A, B, C. However, the form generates 'the field X is required' messages in the order B, C, A. The behaviour doesn't change when we create 3 separate rules and change the order. It appears that the messages are generated in field ID order. Has anyone seen this behaviour?Secondly, when we click OK after the 'the field X is required' messages, the date fields are being populated with the last date field entered into the form - e.g. if I populate field B and get a message to populate field A, field A is being populated with the value in field B when the form redisplays. It's very strange. Again, has anyone seen this behaviour?
*Edited*I am looking to create a button on the main form that when clicked will Save the current record form and then show the info in that current record in a different form? I have tried the auto save when navigating away function. It doesn't establish the Record ID# so the formula showing the current form also shows in the newly opened form.------------------------------Chris Swirtz------------------------------
I used the magic buttons app Approval Button, and it seems to work great! But I noticed that it redirects back to whichever version of the form you were on when you clicked the button - if you click it from the View Form, it takes you back to the View Form version, whereas if you click it from the Edit view, it keeps you in Edit view. I'd like it to redirect to the View view in either case so that the User understands that it has been saved. Anyone know how to do this? Here's the formula:URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=APPTOKEN&rid=" &[Record ID#] & "&_fid_139=Approved&_fid_141=" & Now() & "&_fid_140=" & UserToEmail(User()) & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() &"?a=doredirect&z=" & Rurl())
Please how can i optimize my Quick base app performance? What are some of the common mistakes to avoid when i am using quick base?------------------------------David Mensah------------------------------
The new "sidebar" navigation sucks.Everyone in my organization hates it. It is needlessly cumbersome to do anything now.It is also really stupid that you guys aren't going to let us, the paying customer, simply have the choice in how we prefer to use it and instead force it down our throats after the new year.
I am wondering how to format a date or potentially two dates in a Text field. I have a text field that is populated with up to two dates from a pipeline automation. The dates I believe are coming in as UTC. See example below. How can I get them displaying at MM-DD-YY or something similar?
I created a simple email notification that includes a link to my record as well as a copy of the record, but there is a huge amount of space between in the body of the email before the text appears. I have tried removing the link to the record and adjusting spacing. Any ideas on how to correct?
Hey Everyone, We're excited to bring everyone back in person for Empower 2025 (exact dates and location will be announced soon)! To help us make this event a great one, please take this brief survey! This survey will be open until November 20th, and I'll be pinning this to the top of the page so it doesn't fall off of feeds. We'll also be posting it in the Champions program and in the community-led Discord server, but I also wanted to make sure those who use Qrew Discussions had a chance to share feedback ahead of Empower 2025. Thanks!Ben
Last week I scheduled office hours with Sam for Friday; I waited for almost the entire 1 hour, but the meeting didn't happen.I signed up for office hours again for today; I waited about 20 minutes, no one signed into the meeting.What's going on?
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%
Newbie here! I need to get the word 'County' inserted into this List formula after the [County] field so that it shows up as, Chicago, Cook County, IL instead of Chicago, Cook, IL. Can anyone help? Thanks!List(", ",[Address: City], [County], [Address: State/Region])
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?
Hey everyone,For quite some time now, I have been in charge of developing and maintaining an app which among other things facilitates scheduling of appointments for estimators.Outline of what was actually needed:A form where call agents record customer relevant data;Based on the data, call agent selects an estimator;Depending on the data, the system determines the duration of the appointment (in the background);Based on the duration and estimator, through dropdowns we show the available dates and start times in 15 minute increments.After spending quite some time on it I figured out a way to build in such a way that has all the functionalities needed however app is quite heavy and does not have great performance.Here is a brief outline of how everything is structured:We have an employees table where each estimator has a defined work hours by day Mon-Fri;Each week a Pipeline runs and creates 15 minute slots for each estimator within the duration of their workday. At all times we have thi
Hello,I have a process where users view a case file and work the file. We have grown so now we have several different types of case file and need to use a different form for each file type. I can imagine several ways to do this, but none are clean. Below is a list of what we tried. We tried using an iframe that linked to a formula url field, this worked except is displays the QB header twice and limits the screen size (iframes are apparently not responsive in QB). We tried using one "mega-form" with conditionals, but we hit the embedded report limit and certain fields need to be on multiple forms which QB disallows. We tried creating a different table for each file type but that breaks QB search widget (search widget can only search 1 table at a time). The best solution we found was to create a rich text field that displayed a link to the various case type forms, but then we lose the functionality of the edit and view buttons that display on every report and the search widget. Are th
New Email setup is not allowing for adding a Formula URL button the same way as the old setup. It does still have the "Record Link" and allows it to be a button from an email. The bold underlined is the working record link with custom text. I need to take the blue text and turn it into a custom text link. Im stumped. Field 49 is a formula url that adds a record <h3 style="margin-left:40px;"> <qb-record-link data-link-text="Click here to go directly to Request in Quickbase"></qb-record-link></h3><p style="margin-left:40px;"> Click this link below to add Response</p><p style="margin-left:40px;"> &nbsp;<qb-field field-id="49"></qb-field>
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?
Hello and Happy November to the Mobile Qrew! The Mobile Qrew meets bi-monthly so this November will be our very last Mobile Qrew Meet Up of 2024. On our Agenda for November 20th at 12pm EST: The Chris Snow, FastField CSM, will do an Offline Mobile demonstration of how to collect photos, videos, and activate text-to-speech for easy data collection without internet or cell reception. He’ll also show and provide tips on how to successfully sync collected data from the mobile app into Quickbase. This is going to be a great session to end a year of Mobile Qrew Meet Ups. Be sure to mark your calendars, and register to join here: https://quickbase.zoom.us/meeting/register/tJMkcOChqTosGNGpH6nSnoIitqh956ZxgBjb Thanks and we'll see you there!
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 height
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.
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 you
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, text error message[Current Status]="Submitted",[Finance Disposition]="",[(Text) PipeLine Value Requested]="<$500,000","Red")I'm getting expecting text, but found bool error message
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 #27Record ID: #71, Date Created: 28/10/2024 14:22PM Order Created - 123 John StreetRecord ID: #84, Date Created: 29/10/2024 08:32AM On Hold - 123 John StreetRecord ID: #106, Date Created: 29/10/2024 08:52AM In Progress - 123 John StreetWhat I want to do is work out the du
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,Bart
Missing NetSuite Custom Fields and details from purchase order line items when connecting from a QuickBase Connected TableI have a QuickBase app connecting to NetSuite through a QuickBase connected table. I managed to get the PurchaseOrder data from NetSuite, but I also want the line item details from those purchase orders and I can’t find a way to get the data from the line items. Anyone knows if I am supposed to be able to pull line items details directly from the purchase order? Or do I need to create a second connected table to some line items table in NetSuite? If yes, which table is it in NetSuite?I also created custom fields in NetSuite, but NetSuite custom fields don’t show up in the QuickBase “fields available from connected table” when configuring it in QuickBase. Is it normal that NetSuite custom fields don’t show up in QuickBase connected table configuration? How can I get NetSuite custom fields in a QuickBase connected table?Thanks in advance,
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.