Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Do others have performance issues with the new dashboards?For me, they are very slow in all aspects, whether viewing or especially trying to build and drag things around.------------------------------Mike Tamoush------------------------------
Hi everyone,I am looking for a javascript in a code page that could both print an exact form and change a field at the same time. Can anyone help? Many thanks------------------------------Chris Chappell------------------------------
Hi, I'm trying to create a button that gets sent to the end user in an email message. My Use Case:Our internal support team would fill a form on behalf of the user with the necessary information, and the URL would get populated while the agent is filling the form. Once done, the agent would send that URL via some notification workflow (which I haven't quite thought through fully yet), containing an "Approve" or "Deny" button to the end user. If the user Approves, then they will be redirected to Sign-In (if not already signed in), and the record would get created, with them being the owner, thereby creating a proper audit record of their approval. All is working except populating some multi-select fields. Below is a truncated snippet of how I'm breaking down the values of the multi-select fields and inserting them into the URL formula.Some things I have tried: - I tried using the API_GenRecordAddForm , which actually works well with the multi-select fields, however, that API call
I am confused on sort and group. I have this set to group and sort high to low. That looks arbitrary to me. How is the SDTL not on top? How is DTL randomly in the middle? Is there something I dont understand about how the alphabet works?------------------------------Mike Tamoush------------------------------
Hi everyone!I am asking for someone to help me with a formula - rich text code if possible to color code notifications. To clarify, there will be a start date and 7 days out from that date if the record/task is not completed it will be in yellow. If 10 days have passed and the task is still not completed it will be in orange and in 14 days it will be in red. If the task is completed (checkbox is checked) then the notifications will be turned off for that record. Something as shown below: Any and all help is greatly appreciated. Thank you & have a great day!------------------------------Amy Tran------------------------------
I know this isn't a native capability, but sometimes we can trick QuickBase into certain things. I was trying to come up with a slick way to use formula fields so that I can add an 'other' option to my conditional dropdown.For example, if I had US States as my first selection, then cities as my second, could 'Other' be listed with the cities?------------------------------Mike Tamoush------------------------------
I have some custom code pages for adding records. The forms generated by the code pages include signature capture. The code takes the canvas and converts the data to Base64. The image is displayed on the form using the Base64 and also is added to a URL field when the record is saved. I use a formula URL field to add the "data:image/png;base64," to the beginning of the DataURL string and then use a formula rich text field to display the image in the native Quickbase form.This works without any issues.I am working on a button that opens the signature to allow editing it. When I save the edited signature I get an HTTP Error 400: The size of the request headers is too long. When I look at the URL it has the entire DataURL along with the encoding for special characters like '+', so the payload is constructed correctly.So the DataURL POSTs with no issue when I add, but it is too long when I edit. Is there a different limitation for edit versus add? Otherwise I see no reason why I get this er
So I'm building this rich text dashboard and am having trouble with linking an html button with the proper report. A piece of text with the Quickbase link that is in the interface works fine, but with my own button, it just routes to the report default page rather than the specific report I want.------------------------------Davis Ward------------------------------
Hi, Is there a way to create an "add to calendar" link that will allow us to add to our Outlook calendar?For instance - we have some items that will have a hearing date, and If someone wants to add that to their calendar I want themto be able to click a button that says "add to calendar".------------------------------Renee Hansen------------------------------
Does anyone know if there's anything in the works to allow us to pull in attachments using an Outlook connection or pipeline? My company imports emails from an inbox to automatically create service requests, but our team still has to access that email if there are any attachments (and add the attachments to the service request manually). We don't want to use mailParser, and I don't really see any free commercial options, so if anyone has any other recommendations, I'm listening.------------------------------Katlyn Allen------------------------------
Hey All,I've got a pipeline sending an email and one of the fields in the subject and body displays in the app as a whole number, but in the outputted email it shows with 1 decimal space. Is there any way to use Jinja to convert the number to a whole number? One of the fields is just a summary field counting child records, so it will always be a whole number and "#2.0" looks ridiculous.Why am I using a pipeline to send a notification email? Because there's an API call going through a code page that's triggered when the record is created, and in that moment the value in the field that matters is 0. After the API call finishes, that field is the length of audio files from child records. That field is a summary field, which can't be used as a notification trigger. So instead, I've got pipeline 1 that either sends out the email if that API call isn't necessary, or calls pipeline 2 that loops on itself with a pause until that field is greater than 0.So, I'm looking for a Jinja expression th
Hello,I hope someone can help. I have 3 tables - Locations, Exams and Contacts. Employees will need to view all three at once as they are assisting customers. I finished building the 3 tables and entering the data. I've tried a few different ways to form the relationships but I am not getting the output that I need. I think I may need to set this up as a many to many relationship for all tables but I can't seem to get it set up correctly. Any help will be greatly appreciated.------------------------------Stacey------------------------------
Upcoming Changes to Quickbase feedback This October, Quickbase will be changing the system we use to collect feedback for the Quickbase platform from our customers. Our new feedback platform will be hosted on the Quickbase domain and integrated within the My Apps page. We will migrate active and recent requests from UserVoice. You can read below to learn more about what inspired us to make this change and how it impacts you. Why are we doing it Over the last 12 months, Quickbase undergone a lot of changes. We've released improvements to our table report, a new dashboard with updated charts, UTF-8 Support, too many new Pipelines channels to name, more data summarization techniques, and on and on... All of these improvements have one thing in common, they existed in some form on our feedback platform. With more changes on the way, it's more important than ever to ensure we have the best mechanisms in place to collect product feedback from our customers. The new feedback platform will all
I am trying to create a summary report around a bunch of dates and am stuck... Here's the scenario.We are a marketing organization and collect a bunch of dates for people we market towards. For each prospect we capture the date we send a communication, the date they read/review it, the date they respond to it (positive and negative responses are captured in separate date fields) and the date we book a sales call with them. In short, our table looks like:Prospect NameComm Sent DateComm Read DatePositive Response DateNegative Response DateBooked Call DateI need to create a summary report across our entire prospect list that looks something like: Jan 2021 Feb2021 Mar2021 Apr 2021 ................. Dec 2021Comms Sent &n
Has anyone heard if there is a roadmap to simply run table to table imports in Pipelines, or if you will need to essentially build it in the Pipeline using the following instructions.Building Table-to-Table (T2T) Imports using Pipelines------------------------------Mike Tamoush------------------------------
I am trying to add a related record and update the URL code to include updates to the child record with data from one more than one field on the parent record. I have been unable to find any code examples and after several attempts, and not knowing for sure if this is even possible, I find that I need to ask for help! I thought this would be simple (old school SQL guy) but I keep failing. Really appreciate a hand!Original Code:URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([WAN-Xchange Loc ID])& "&z=" & Rurl()From the parent record, I want to include:[Client (Related)] into to child record field ID 9[Project (Related)] into to child record field ID 11[Bid (Related)] into the child record field ID 15URLRoot() & "db/" & [_DBID_ACCESS] & "?a=API_GenAddRecordForm&_fid_21=" & URLEncode ([WAN-Xchange Loc ID])&_fid_11 =& URLEncode [Client (Related)]& "&z=" & Rurl()--------------
Hi Folks,I'm using reclink in my Notification message. Is there a way to show the reclink as a button or a prettier version instead of a link?Thanks,Hema------------------------------HR------------------------------
I have a pipeline that is setup for our Accountant to run when they select a date range and client and then it will assign all the entries in the child table to the parent invoice record. To make sure the Accountant doesn't create the invoice until all records have been linked are there any 'fool-proof' mechanisms to show the pipeline is finished on the Parent Record? I have been testing and there will be instances where I have to refresh a few times before the the Total Invoice amount is correct.------------------------------Ryan Locke------------------------------
I have an app with multiple tables and relationships. For one of the table, I have a key field, called "ID" that was maintained by imports from another system and of course the built-in Record ID# which QB manages. Now, the 3rd party system is changing and all the data from old system is being migrated to the new system. The new database has a completely new numbering syntax and field, called RLID. So I need to update the existing ID field to match the new RLID. I thought I could use the Record ID# of existing records and update the ID field to RLID. However, it seems QB doesn't allow that via mass upload even though I am able to update the ID field manually for each record. Given that I have thousands of records, I don't want to do this manually for each. Is there something I am missing? I have thought about making Record ID# the key field and then do the upload (if it allows me) and then change it back to ID field but not sure if that'll preserve all the relationships or make them me
Would you recommend using google charts or something else to implement SPC charts in my QB app? Can you please point me to information on how?
Is anyone else having issues accessing their open support cases? ------------------------------Daniel Johnson------------------------------
Hello,I am trying to create a report that has alternating colors for the rows. I can't us the record Id because the Record ID is not in sequential order when filtered (as seen below). I have been searching on how to create a new record number or something for the report itself to help do an alternating number or even/odd to use with a formula for colorizing rows, but not luck yet. Hoping someone has encountered this problem and has a fix. Here is a sample of my report where I am trying to alternate colors. My report can change weekly so I need something that will change with the report. Name Record ID# Date Quarter Vixen 776 1/21/2022 Q1 Chicken 711 2/1/2022 Q1 Clothing 709 3/1/2022 Q1 Dip 721 3/1/2022 Q1 Mystery 750 3/1/2022 Q1 Mop 747 3/7/2022 Q1 Launch 736 3/17/2022 Q1 Launch Chicken 737 3/17/2022 Q1 Class 710 3/22/2022 Q1 Thanks------------------------------Jennifer Silberstein------------------------------
Hello,I am needing to send out an email containing a report at a specific time each day. Because the normal in-app email option sends at midnight every day I cannot use that and must instead use the pipeline. I have read up on how to make it work but I am not familiar with JSON so I am a little lost. I have followed this link to a T, How to use Pipelines to email a report at a specific time of day (quickbase.com), but the email I get only says the title with no report. Here is the code I used:Any help or guidance would be greatly appreciated, thanks in advance!-Hank------------------------------Hank Halverson------------------------------
I ran into something today and am thinking it is so basic that someone else must have solved it by now....I have a table report that uses a red/yellow/white color scheme to highlight certain records. The problem that I have run into is that when I attempt to print the report, the built-in dialog box below appears on top of the report:When I click the "Print" button, whatever record is underneath the button is getting selected, which changes the color of the record to a blueish color for the printout. The dialog box cannot be moved outside the report window, so there is no way to position it someplace where it will not change the color of a record. I am minimizing the impact for now by positioning the button over the last record in the report and hoping nobody questions the color.Anyone else run into this? What did you end up doing?Thanks!!Brian------------------------------Brian Petzold------------------------------
We are in soft launch of a large portfolio project management app with ~400 projects that span across numerous requestors, Project Managers, Value Chains, Impacted Markets, Impacted Systems, etc. We have developed dashboards for each role that contain numerous filters that enable the user to get at the 'slice' of project data that they wish to view. Heavy users are asking for even faster access to 'their' data... Project Managers would like a MY Project page that automatically presents to them the projects assigned to them without having to select their name from the Project Manager filter. Value Chain Owners would similarly like their dashboards to remember the last set of filtered preferences they used. We do not want to get into the custom dashboard for each Project Manager mode. They are NOT asking for new widgets, but mostly asking for the current dashboards to remember their filter preferences. Is this possible? &nb
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.