Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi, I have a report and one column shows negative values. Is there a way to convert that column to so that it shows positive values?Thank you!------------------------------Bibhav Rimal------------------------------
This bulletin informs Quickbase customers of a plan to transition parts of the US Instance of the Quickbase platform between our existing hosting locations during 2023 and introduce a new hosting location in Q4 of 2023 and early Q1 of 2024. This hosting transition will be accomplished using planned down time similar to the data center switches we typically do 2-3 times per year.No action will be needed by customers aside from being aware of the planned down time as it is announced during 2023 or 2024.Linked here you can find a full explanation of the hosting transition, and a visual depiction of the milestones.The primary objectives of the hosting transition are: Upgrade the Quickbase infrastructure that serves 3+ billion requests per month, while simplifying the process of future upgrades. Simplify the processes Quickbase uses to host and operate the Quickbase platform, while maintaining the same level of functionality, security/compliance, reliability, performance, and scalabi
When a pipeline failed (or just in general), I used to be able to see which fields were trying to be updated, the record ID acted on, etc. A good chunk of helpful data. I don't see that anymore. Is it gone, or am I looking in the wrong spot? It used to show in your activities, you could expand for more details.------------------------------Michael Tamoush------------------------------
When looking at an embedded report, you can click and 'add column' as typical. Of course this column doesn't stay when you refresh, but it can be helpful temporarily.Some times this works just fine for me, and other times it says 'Retrieving' and nothing ever happens. If I click on 'full report', then add the column it works.I cannot find a consistency as to when it will say retreiving and time out, and when it works. Have others come across this? And does anyone know when it happens?I believe it happens on old style reports only, which is how all embedded reports look/act. I have had a similar problem on old style reports in the 'default' report setting.------------------------------Mike Tamoush------------------------------
Hi everyone,I am struggling with how to create a bonus calculator for some members of my team. Here is my schema and what I am trying to accomplish: App1: Team Elite - This is our ERP/Project Management / Project Billing App App2: eHR = Our HR app containing compensation etc. For security reasons I keep these as two separate apps. Team Elite Table Structure used in this scenario Projects < Opportunities < Orders < Invoices Total Invoice is summarized all the way up to Project Level Team Members is a table for all off our employees eHR Table Structure Team Members (from Team Elite) < PM Bonus (eHR app) Now what I am trying to do is when I create a record in eHR on the bonus table for one of my Project Managers have it populate all of the projects assigned to them (there is a Project Manager field on the Projects Table related to Team Members). For each of those projects I want the ability to add some fields or reference fields. Here is
I currently have 3 formula text fields to track status of 3 separate events. I want to create 1 formula fields that will give me an overall status of the 3.Text Field 1Text Field 2Text Field 3If Text Field 3 is populated I want to capture that entry, if it is blank then I want to read Text Field 2 and populate that entry. If Text Field 2 is blank then I want to read Text Field 1 and populate the entry.Everything I've tried so far only gives me the info if Text Field 3 has data.Does anyone have insight?ThanksSheila------------------------------Sheila Allas------------------------------
I have a Pipeline that when a record is created or updated in a table, I need to search a second table to find the Project Code that matches from the created record, then update a field in the second table with some values. The key is matching the Project Code field between the two tables before updating a field value. PIPELINE:On New Event Table 1: Record is created or updated (captures Project Code)Search Table 2: Search for Project Code that matches Project Code in Table 1 Update the Portfolio field in table 2 with specified value.I have been unable to figure out the Jinja code in the Search step to compare the Project Codes between the tables. Any help is appreciated!------------------------------Amy Gosz------------------------------
Hello,I have a formula rich text field which is acting as the body of an automated email that's intended to be sent out to clients.However the link that is being pulled through isn't working, only part of the address is acting as an actual link. it's appear as this:https://quickbase.formengine.com/#!/render-dynamic?templateId=cc15f538-2b42-412c-9e90-5c1a7010075e&action=update&rids={"3972ef33-9766-46f8-9b17-fd26ceadf75a": "5"}&connection={"userToken": "b74e79_p8qn_0_d8f7n9dbq83rqcddux2hkb2mchwr","realm": "paystream"}The entirety of that is supposed to be a link to a Form Engine document clients should have to complete. You can copy and paste the entire thing into a browser, and it works, but clicking it doesn't load the page as it's only loading part of the link.I cannot manually edit the link itself as that's pulling directly from another field, but is there anything I can put either side of the link to force Quickbase to read the entire string of text as one link and secon
Does anyone know if you can change the email address associated with your community account? Or would you need to start a new account?I'd rather not create a new account and lose my history.Thanks------------------------------Michael Tamoush------------------------------
Hello Quickbase Community!I need to know how to send a notification every day at a specific time? modifying a field.I need to send a single record (%recData%) made up of reports, using thereport link field type.thank you, stay tuned.Regards,Herberth Solano.------------------------------Herberth Solano------------------------------
Hello! I am working on a code page that will allow our users to quickly design and print all of their employee ID badges.The formatting is done, I am now in the process of learning how to: 1. Repeat the HTML structure over and over until every employee ID badge is listed. 2. Connect the data in the HTML structure to the employee's table to draw upon the QB data to generate the content on the badges.Here is a link to the code page I have been working on with dummy data/content to help visualize what I am working on: http://old2.lztek.io/tests/codepage.html Linked in the attachment is the codepage itself with comments on what divs and tables need to be repeated.Here is an example of a single badge ID: <table style="width:100%;"> <tr> <td class="left"> <img class="logo" src="company-logo.png" alt="Company Logo"> <br> <div class="name">John Doe</div> <div class="job">IT Director of Constant caring and health.</div> <div class
I am hoping I can get suggestions on how to take a value from a multiple choice field and insert it on a multi-line text field, without it changing when the value changes in the multiple choice field.I want to use a running call log. Each call has a type (multiple choice text). The type is selected and then call notes are entered in the multi line text field. Rather than adding a new call log record, I want to enter new call notes to the existing record, where the new call notes will be timestamped. I can put the Type in the field with the call notes, but what I run into is each time the type is changed the type on the previous call note changes. It needs to remain static so we can always see the category of previous calls. Short of automating this the best I can come up with is just to type in the call type at the beginning of each new call note. That can get inconsistent results.------------------------------Barry Dolan------------------------------
Suddenly, several scripts we have that use the Quickbase rest api are getting 400 errors when trying to update data. No changes on our side, it just started failing around noon PST. Anyone else seeing problems, specifically with UPDATES via the REST (not XML) api?------------------------------Kerry Schwab------------------------------
Good Morning Everyone,Wondering if there is a list of the common phone numbers QuickBase will use to send out SMS notifications? Rather than have 50 different versions of the "1410100006" number sending individual text messages, I was hoping I could just create a contact in my phone with all of these different phone numbers, which would keep most or all of the SMS messages in one contact.Or, is there any other work around for this? Seems it may be a limitation of the service, perhaps on the cell carrier's end.Thanks,------------------------------Aidon Olligschlager------------------------------
Hello,I have a problem downloading file attachments with the API. My current language of choice is Python.I have researched several articles on this topic however no joy yet.If I query an attachment using the following syntax I can see the file in the browser. So I know my user token and parameters are correct.https://domain.quickbase.com/up/dbid/a/r_recordid/e_fileid/vversion?usertoken=user_tokenHowever when I use the API to try to download the file I only get "Resource not found" as a response.I have attached an image with my python script.Any help / guidance would be greatly appreciated. Thanks!------------------------------Scott Paxton------------------------------
Leaving this here. Use the Admin Console Connector to display Last Access Date and App Access for all your Quickbase Users in an App.Problem:We have the Human Resources App with all the Employees and an email address field ~not everyone has an email address and not everyone is a Quickbase User. We know who is a Quickbase User because we made a crude "Quickbase User?" checkbox field and each month manually aligned the data (sigh).Blather:We asked Quickbase Support about it, they had no ideas.Eventually we made a Workato recipe that uses a nested while loop because Quickbase API uses two calls for each User (sigh). One Day Workato called and said "you guys are using a lot of tasks, could you please stop?". We tried to make it less and even met with Workato devs who said, "that is as optimized as it's gonna get". We met with Quickbase and discussed the problem and they said "use pipelines".Then one day while I was hemming and hawing about getting ready to use Pipelines, I happened ac
I have HTML code page, which displays bus route statuses, for multiple locations.The users can update any of locations, route status, based on the service. I want to capture the timestamp, when the status changes and display as-This page was last updated on : 2/2/2022 1.56 PM.This time should be based on the last status update. How can i accomplish this? Please suggest.Thank you in advance.------------------------------Divya (OSSE-Contractor) Pogaku------------------------------
I was working with a client who was working with Ryan Murray of Quickbase and their need was to colour the cells in a summary report. To my surprise, this is indeed possible.I checked in with @Sharon Faust to see if this was known to the community at large and she agreed that it was news to us. Sharon might do a video on this, we hope ... but meanwhile here we go...... Sharon took Ryan's example code that I was able to obtain and simplified it to this.This would be the formula for a "Summary Formula" called say Highlighted Issue Countvar text STYLE = "style='display:block; padding:5px; width:40px; color:white; text-align:center; background:";var text red = "<span " & $STYLE & "red;'>" & [number of issues] & "</span>";var text green = "<span " & $STYLE & "green;'>" & [number of issues] & "</span>";var text yellow = "<span " & $STYLE & "gold;'>" & [number of issues] & "</span>";var text g
How can I create a field in a report that shows the % change from 2020 to 2021 and then 2021 to 2022 and so on?------------------------------Colton Runnels------------------------------
Good Morning,Does anyone know how QB evaluates a logged in users role? I want to see if the process can be broken down so that I can recreate portions of it in a formula for what I am trying to do. I know QB has a UserRoles() function but that looks for the role of the logged in user. What I am trying to do is pull a role out of a user field for evaluation on an IF statement. Based on the result the field(s) will prefill the expected information without user interaction. There was a question I found on here that is 2 years old and it did not seem possible then but I am wondering if this is possible now. (3/17/20 reply)https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=303cffc8-acce-46f7-bbb0-88f5be095313&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewerThanks,John A.------------------------------John Arniotis------------------------------
Hi,I have a report that includes blank cells and zero values. How do I remove all the blanks and zeros from the report using formula? The hour and pieces column both should have values (no Zeros and blanks on both or either columns)Example: Hours # of Pieces 0.1 3 52 191 0.1 3 42 179 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 67 0 ------------------------------Bibhav Rimal------------------------------
Hello -There is a pipeline in app1 that creates a record in app2. The pipeline owner's name is populated as the Record Owner in app2 but due to notifications on record updates etc. it would be preferred for the 'true' record owner from app1 to be the Record Owner in app2. Is this possible? Record Owner does not appear to be a selectable field in the "Fields for Subsequent Steps" line of a pipeline so I am not sure how one would pass that value through.------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hi! I have a notes table setup where a user can add a note from different tables and relate it to that record, but since it's pulling from multiple different relationships (EX: QRA# is coming from the Units table, the Wells table, or the Calculations table, I want a field that will pull that QRA# into one field, instead of it being in one of the others. Does that make sense?------------------------------Renee Hansen------------------------------
Hello,I have a inspection list that has 4-5 drop downs for the roles involved in the inspection. I want to pull from one user list to populate these roles. The user list is in another table. I can set this up for one of the roles in the inspection but am struggling to duplicate this.What I want1.Tom Role A: 1,2 or 32.George Role B: 1,2 or 3 3.Sam Role C:1,2 or 3Thanks for your helpPhilip------------------------------Phil Heron------------------------------
Just wondering if we can actually embed the child form onto the parent rather than looking up values?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.