Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I've added a new Parent table "Cases" table to my already-established Child "Call Records" table as suggested to me earlier this week, and created a bunch of roll-up fields so that our end users can enter their fields on their call, and it will roll up to the master Cases into summary fields. Previously, we delineated calls that were subsequent calls of a same case utilizing a field on the call record ("Continuation of Earlier Case"), but it created issues of duplicate data.That said, two questions:Is there any way to create such summary but filter out answers = to "Unknown" or "Not reported", unless they are the only answer? I suppose the alternative is simply to have no answer. We've used Unknown/Not Reported on multi-select text fields for the ability to require the field nonetheless, but if on a subsequent call, the data is known, I'd like to disregard "Unknowns".Can I use the roll-ups to tie to another Parent table? I'd like to tie all these to the hospitals that call us
Who's excited for Empower tomorrow? Nico and I will be hosting a Empower Happy Hour tomorrow at 4:00pm MT if anyone wants to hop on and chat about empower and share any reactions or what you may be most excited about. Hope to see you there!Follow this ---> link <--- to register and we'll send you an invite to the post-Empower Happy Hour.
I've been working on a multi-step form and noticed that the return and cancel buttons on the new forms always return the user back to the home page no matter where they are on the form. Also, is there a way to hide either the return or cancel buttons? Has anyone else experienced the first issue I mentioned where both buttons do the same thing and take you back to the user home page, completely away from the form and table you were on?
I have a pipeline that uploads a file attachment to another record. There may not always be an attachment. This causes and error on the upload step. I have tried using a condition with is the file attachment set and also tried not equal to "blank" and neither by passes the upload step. Is there another way to test to see if there is an attachment to upload?
Hi All, I would like to use a simple Quickbase API (API_ProvisionUser) in a Pipeline and use the user id included in the response in my subsequent Pipeline steps. Response promised in the API docs:<?xml version="1.0" ?><qdbapi> <action>api_provisionuser</action> <errcode>0</errcode> <errtext>No error</errtext> <userid>112248.5nzg</userid></qdbapi> Is there a way I can parametrize a Quickbase channel API request to get the XML response? Suppose getting my stuff out of the XML text would be somehow possible, but how can I capture the API response? Seems Pipelines does not offer any available new field after establishing this API request step. Or I am doing something wrong... Thank You!------------------------------Laszlo M------------------------------
I am updating an app with a [Fines] table that has 10 pairs of Pmt-Dt-* and Pmt-Amt-* fields. The date fields are Date (not Datetime).1) I created a new [Payments] with Fine-ID, Pmt-Dt, and Pmt-Amt fields. The new table will support online payments, so we want the new Pmt-Dt field to be Datetime to differentiate between multiple payment attempts on the same day.2) I created a pipeline to read each Pmt-Amt-* of each record. If Pmt-Amt-* > 0, then the pipeline inserts the payment into the [Payments] table.ISSUE: Although both tables are in the same application, the new [Payments] table dates are created with a timezone adjustment. The application is UTC-05:00 (Eastern US & Canada).• 2012-02-02 (in original Fines table) is inserted as 2012-02-01 19:00 in the new table (5 hours earlier).• 2018-08-08 (in original Fines table) is inserted as 2018-08-07 20:00 in the new table (4 hours earlier, during DST).I can probably use time.delta(hours=5) and time.delta(h
Managing an app with over 975 clients and nearly as many users, we've found it simpler to streamline permissions by assigning everyone to a single role labeled "Client User" for external clients.Regarding the visibility of report names across different client profiles, I want to ensure that users associated with one client can't see the names of reports meant for another client.For example, let's say we have reports named "ABC Client Report" and "XYZ Client Report." How can we prevent users from the XYZ client from seeing the "ABC Client Report" name in the list of Reports & Charts while still keeping them in the same role?Current permissions are already in place to ensure they are only seeing their company's data, so I'm only concerned about the names appearing in the list.Any ideas or suggestions on how to tackle this would be really helpful. Our goal is to maintain client confidentiality while keeping things user-friendly for everyone involved. Thanks in advance!
Hello,We have a use case where we are storing Certificate of Insurance (PDF's) in quick base records. When that file is updated I want to send an email with the attachment to an email stored in the record.However, in the Pipeline designer I cannot grab the file attachment field even though Outlook channel supports send with attachments. How do I grab that file attachment field in Pipelines?
Hello!Just doing some maintenance and preparing for some overhauls. In one area, I'd like to streamline pulling in info and linking to a grand-parent table (is that what you'd refer to it as?), by pulling info just from the Child table. In this specific instance, it is:Parent: OrganizationChild: Contact PersonGrandchild: Activity RecordOn the Activity Record, I'd like to look up the Child Contact, and auto-populate AND link to the Organization.I can't remember how to do that! Right now - I have both Organization and Contact Person set up with a direct relationship to the Activity Record, just so when I pull up the Organization, it properly links.
Is there a way to create an action to modify fields in the same table where the action is taking place?For example, when I change the status to XXX, I want the follow up date field to be changed to 45days from the schedule date field.
Hi there. I'm new to Quickbase and trying to learn as I go. I'm building some tables for our company and need help with the relationship between customers and their orders. I apologise if this has been asked countless times - if someone can point me to the right answer I'd be very grateful.Our company has many customers - and I've created a 'customer info' table to store their information (company name, contact info, website, phone, email, address etc). These customers can place lots of orders with us. So my second table is an 'order sheet' which has details of what they've ordered, when it's needed by, what size it is, its weight - that sort of thing.On this 'order sheet' table, I would like to have some of the customer info (company, contact name and phone number). I'd ideally like it if, when the customer name is selected from a drop-down (or similar) then their phone number, contact name and email is automatically populated.Is that possible? As a follow-up, if it is possible,
I need my Report Columns to show only one instance of a team and not 5,6,7 etc... rows where that team has executed a job.For example SPP-35 will be executing two jobs, but each job is on it's own row. The managers want to see both jobs, on a single row... is this possible in a Summary Table? Or can I do this thru a query? If so, how?
The Qrew, we believe the issue of Google showing bad links to community posts has been resolved. If you find any community.quickbase.com links on google that are bringing you to a "page not found" page, please add them to this thread.
I have a task management app and would like to add time management.Currently, we enter tasks into our Quickbase app and separately, we complete timesheets on an excel document.I would like to add the ability to track hours spent on a task and then generate our timesheet from the Quickbase data.This is the first of many projects that we're considering.------------------------------Justin Sligh------------------------------
Hello again - one more for today!I'm self-taught in Quickbase and data management altogether. I'm trying to suss out the best way to pull some data. We capture a dataset on consults in our Quickbase. Every call our program receives, gets one record entered into Quickbase. Sometimes callers call us back for more than one consult on the same case. To this end, we have a field capturing "New consult" or "Continuation of consult". Then we capture services performed and patient demographics of the consult.... many situations can transpire in which we got that data on the first call, or on a subsequent call, and it's quite varied (for instance, first call may be very brief, they give us limited info and say they'llc all back/we don't get that info right then, but do on the longer subsequent call; the inverse of that, they call, we spend meaningful time, capture the data the first time, and they call back for some follow-up questions).Now, to extrapolate services (how many times did X happen
I am trying to generate a QR code that will open a record in Quickbase. I have a Formula URL field that generates the URL:URLRoot() & "db/" & [_DBID_ASSETS] & "?a=dr&key=" & URLEncode([Cart ID#])I have a Formula Rich Text field that generates the QR Code:"<img src=\"http://chart.apis.google.com/chart?cht=qr&chs=100x100&chl="&[Record URL]& "\"\"/>"When I scan the QR Code it is dropping off the &key= part of the URL. Is there something wrong with my Rich Text Formula?The URL field works perfectly!------------------------------Julie Meeker------------------------------
I have a table with a Maximum Date field. I'd like to create a chart that I can filter by Month, Quarter, and Year. I have managed to create 3 different charts (one for each), using formulas on that Maximum Date field to pull out the Month, Quarter, and Year, but I'd like to have 1 chart where I can simply select the appropriate Month, Quarter, or Year filter. This chart will ultimately go to a dashboard (yet to be created). I'm just stuck on the filter part! ------------------------------Anne McCarthy------------------------------
Hello!I need help across 3 things today :). And some quick Quickbase Qrew help and/or feedback too.Forms:Is there any way to create a read/view-only form? Or can this only be achieved through toggling the individual fields on a Form to read-only?I'm struggling to delete a legacy form - but I cannot find it tied to any report nor role. What gives?Qrew Help/Feedback:I posted this once - but it didn't take. The new site is a bit glitchy - but I know it'll get there!Is there a way to get notifications when there are replies? I have to manually check.The redirect function kicks you back out to home. So if I either go to "reply" or "start new" discussion, it auto-routes to authenticating, then back out to the home page instead of the thread/area I was in. Thanks!
Anyone else run into the native tool bar on the bottom of mobile (where it shows My Apps, App Home, Back, etc), will sometimes disappear on mobile? I'm pretty sure I have solved the mystery and will post back with the solution when I am sure, but wondering if others have run into this.
Hi all. I think I found a bug with Pipelines where using a Time of Day field isn't in 24-hour format even when you set the field settings to 24-hour. Can anyone think of a possible workaround?Most APIs use 24-hour format so having Pipelines only output in North American format makes it impossible to pass along the correct time format.Steps to reproduce:Create a Time of Day field.In field settings > Value display, enable 24-hour clock.Create a pipeline that sends a value in this field.Pipelines outputs the field in North American time format (for example, 5:00 PM), instead of 24-hour format (ex: 17:00).I tried using Jinja to reformat to 24-hour, but Pipelines doesn't support the jinja filters needed to re-format to 24-hour time. Here's the Jinja expression I tried:{{ time-field|replace(" AM", "").|replace(" PM", "")|stringptime("%I:%M")|strftime("%H:%M") }}
I am trying to make a Quickbase action... When a certain action takes place, I would like for a field to be edited, rather than having a new record created. However, the option for a field to be edited is blurred out. I need the field in another table to be edited? What am I missing?
I have an app with 3 connected tables: When adding a "Permission" to an "Access Group" I can choose/write in a new Department: I want the Department to be tied to the Employee. When I add that employee's name to another Access Group, I want it to auto-populate the "department" field. Also, when I go to the "Employee" table, I would be able to sort by department. Does anyone know how I could do this?Thanks!
What does the 'in set' condition mean in pipelines? Does it simply mean, if that field is entered? If so, how is that different than having a trigger on that field?------------------------------Mike Tamoush------------------------------
Hey Quickbase community! Empower is coming up next week and we're organizing a sort of debrief on the events of the day over in the Rocky Mountain Qrew Group. This will be very informal, but I wanted to get some like minds together and talk about any reactions you have and anything that has you excited about the future of Quickbase.Follow this link to register and we'll send you an invite to the post-Empower Happy Hour. Hope to see you there!
Hello!Is there a way to make a view-only form, regardless of role? Or is the only way to go in and make every field read-only?I'm struggling to delete a legacy form. I've looked high and low, it's not connected to any reports or roles. What gives?Is there a way to turn on notifications to Qrew when I get a response? Thanks!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.