Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
It is easy to look at a data set and become overwhelmed, as all the data may look important and relevant. Businesses now rely on their data to quickly gain insight and make data driven decisions. Consider this when deciding what kind of data to include on your Quickbase dashboards: Are your end users able to act on the data presented to them? 1. Less Is More Keep your dashboards clean! Before introducing a newly designed dashboard to end users, take the 'at-a-glance' test. Look at your dashboard for a few minutes. What are you able to understand and absorb during that initial time? Including charts and graphs on your dashboard can help a viewer understand things more quickly. But remember less is more. Don't fill it with too many reports- some are good, but too many can be overwhelming. Use buttons or a tab to display additional/more granular information. 2. Get Organized Organize your dashboard using tabs and buttons to drill down for additional and m
Hello,Wondering what drives the fields that are exported from a table when the user does so with the existing Import/Export button on the home page screen. Is there a way to change what fields are in this file?------------------------------Thanks in advance,Jennifer Paschal------------------------------
I am looking to find 15 weekdays prior to the training start date. However the Training Start Date field is a Date/Time field and the below formula is giving me an error. How can I fix the formula without having to change the Training Start Date field type.WeekdayAdd(, -15)------------------------------NOEL HODGES------------------------------
Hi! I'm creating a pipeline to replace an automation I have (working on making the switch). This is the automation - basically copy what's in one field to another if request status changes. Here's My Pipeline: Thanks in Advance!------------------------------Renee Hansen------------------------------
I'm using pipelines to link QB records to associated folders on Google Drive - each record has a field called [Google Drive ID] which holds the ID provided by Google Drive. I then embed that folder view in the record to display all the files on the record. So far it's working great.Here's where I'm having trouble. If a user uploads a file to Google Drive, I want pipelines to update the associated record. Below is what I'm doing but I'm happy to take an entirely different approach if someone has a suggestion. Every hour, search for new files within a specific Google Drive folder. Pipelines successfully finds matching files, providing the folder ID in a list called {{a.parents}} For each new file, search for the record where the folder ID matches [Google Drive ID]. I can't figure out how to perform this search - I think I need an advanced query but everything I try fails. Adding a condition on [Google Drive ID] doesn't provide an option to search within the {{a.parents}} list '{{a.pare
We have established realm-wide branding for all apps in our realm. Recently I noticed that an app manager changed the branding on an app. Can I disable the ability to customize branding?------------------------------Sherry Blackburn------------------------------
I'm looking to attach a document to a job that tracks various project completion steps. Is there any way to attach a document to a job either via pdf or excel? I cannot find anywhere to attach...thanks------------------------------Reba Ristich------------------------------
I've one column named "comment". When I select more than one rows from results to make comment, a single comment should get applied to all selected data change rows. Also, I'm looking for a free form text box to add commentIs there a way to do this?------------------------------Mrunali Kadam------------------------------
I have a Request form that I need to validate the date and time for the date the service is requested. I created formula fields to use in the dynamic form rules, but I do not want these fields to be displayed on the form. If I don't include them on the form, the dynamic forms rules don't work. I tried including them, but for edit only and that did not work either. I tried putting the formula fields in a separate section and used a dynamic form rule to hide the section and that also caused the date test dynamic rules to fail. I have a test form with the fields displayed and the rules work perfectly. How can you configure the form so that the fields are not displayed, but they are available to the dynamic form rules? (without using javascript because that is above my skill set.)Thanks in advance for any help!------------------------------Julie Meeker------------------------------
What is "Action link example"?thx------------------------------BuildPro------------------------------
Hi Folks,I created a Formula-URL button to change the value and redirect to the same page. The issue I'm facing here is,* When I click the button in Edit mode, a popup appears saying "Changes you made may not be saved"* Click the leave button in the pop-up (the changes are made and redirected to the same page)Code:If((not IsNull([Project record ID#])and [Sign Off Status]="1. Draft"),var text Endorsementbypass =URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &"&rid=" & [Project record ID#] & "&apptoken=abcdeff" &//SignOff Status"&_fid_182=" & URLEncode("15. TSP Endorsement Bypass")&//Project Disposition"&_fid_18=" & URLEncode("Portfolio Mgr Review") &//Business Proposal and Charter - Reporting"&_fid_377=" & URLEncode("Checked") &"&rdr=" & URLEncode (URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl()); $Endorsementbypass,"")Thanks,Hema------------------------------Hema Rajendran----
Hello everybody, I've searched the forums and can't seem to find an answer to what is probably a fairly common inventory problem. We track inventory by period. I have fields for Beginning Inventory, Inventory Received, Inventory Used and then Ending Inventory. What I'd like to do is have the Ending Inventory of one period automatically carryover to the next period's Beginning Inventory. In our company we use Bimonthly Invoice Periods, the 15th and the 31st. I may not have the terminology right here regarding carryover or running total. In a perfect world that same Beginning Inventory would default to the prior period's Ending Inventory OR would allow manual entry to a selected value, for the first period of the year, or a non standard entry. But I realize that would add complexity. We are coming from FileMaker and we had this formula there that worked both ways like this. Thank you in advance.------------------------------Brian Hunot------------------------------
Hi there,A client is pressuring us to sign up for an EDI service with SPS Commerce. I tried doing research and just feel dumber than I already do looking at database stuff. I want to keep working with this client so I am wondering if there is a way I can be "EDI compliant" using QB? I do not need end to end integration just enough to allow me to keep working with this client <20 orders per year but avoid the middle man (the BBB reviews are not kind). Is this something a developer could help with / does anyone have experience with SPS commerce or similar integration?According to SPS DevCenter they use "Retail Standard XML (RSX)"Thanks in advance for your help,-Ryan------------------------------Ryan HabermanMaking developers crazy since 2008------------------------------
I am trying to calculate length of employment for our employees. I've been "successful" in being able to generate two fields - one for # of years and once for # of months. But, what I really need is a single field that shows # of years with a decimal point.I've used the formula (Today() - [Hire Date])/365 - yielding an adequate result for my needs (# of years with a decimal point) but it is labeled as days not years. (2/25/2022 - 12/15/2017)/365 = 4.2 daysAny assistance would be greatly appreciated as this is driving me nuts and I couldn't find a clear resolution for this topic within the community posts.Thanks!------------------------------Eric Rovner------------------------------
I have an SFTP connection to folder with CVS files. QB accepts the server credentials. The import runs and records are created. But only for the first three files. Reading the fourth file always triggers a login error.What truly has me baffled is when I test the connection, the Password field is blank and Username field displays the password, in clear text! I correct it and it says "Your connection is working". BUT when I click OK, the changes are not saved.The only way I can get a working connection is to start over and make a new one. And it runs on only three files and then I'm back where I started. ------------------------------Samantha Sand------------------------------
Using Code Pages to Refresh with a DelayEnd User Workflow Often, builders want to click a button to trigger a Pipeline, and then wait a few seconds giving the workflow time to complete prior to refreshing the page. This is especially common when Pipelines are interacting with a 3rd-party webservice (for example, creating a record in another system and bringing back confirmation data). This can enhance the user experience vs the user having to refresh the page manually after clicking button initially. This can be accomplished with a code page. Example First, create a Formula URL field and construct an API URL, such as “?a=API_AddRecord” or “?a=API_EditRecord” (stringing multiple together if necessary) and declare it as a variable. Then pass this variable to the code page to handle the rest. // API URL to Add/Edit/etc.var text urlToExecute = URLR
Hi all -First time posting here. Thanks in advance! I am working with the QuickBase API using a tool called Data Fetcher (which is an integration in AirTable). I am struggling to find a way to filter my query results based on subset of users that are associated with a certain record (field ID 35 in my case). The query filter appears to be applying operator to Field 35 Name Value while a User ID and Email value exist and are returned along with the results, I can't figure out how to use them as my query filter. Here's my existing query which works but I would like to be able to specify user emails instead of first names.{"from": "TABLEIDHERE","where": "({36.IR.'today'}OR{36.IR.'yesterday'}) AND ({35.CT.'Rudolph'}OR{35.CT.'Jack'})","select": [3,3148,3143,3133,36,35,401,3149,3147,3130],"sortBy": [{"order": "DESC","fieldId": 36}],"options": {"top": 0,"skip": 0,"compareWithAppLocalTime": false}}------------------------------Beau Powell------------------------------
I have two tables, Projects and Samples. Samples is a child to Projects. One to Many Samples per Project. I want to populate a field in a Samples Record with a number from the Project (Project ID) and add to it the following (-01) going up incrementally by 1 whenever I add another sample. Example: Project:Project ID = 22220000 Samples: Sample Number: 22220000-01 If I come back later and add another sample it would be 22220000-02, and so on. The counter starts at 01 if we are in a new project adding related samples. I hope I'm explaining it properly. ------------------------------Andrew Konopacki------------------------------
In a table that has a self referencing relationship, is there a way to prevent the user from selecting the same record as the child?e.g. in the classic User table example, where you can select a manager from the same user table, I would like to be able to prevent selecting yourself as your own manager.It seems like 'dynamic form rules' would be perfect for this, as I could then display a message, and change the value to blank when this happens, but for some reason you can't select "record id#" as a field in the dynamic form rules. e.g. I'd like a dynamic rule that said "When Manager ID is equal to Record ID#, display a message"------------------------------Chase Sterling------------------------------
I am relatively new to using JSON APIs in Pipelines and am having problems getting a TinyURL for a really big URL from Quickbase (I plan to use it as a QR code, so smaller is better!).This is the Fetch JSON step I am using:This is the response I get back:The error message from the API looks like it is not finding the URL, but when I use the Dev page at https://tinyurl.com/app/dev and put in this as the body, I get the response I expect and a TinyURL that works:{ "url": "https://sutubra.quickbase.com/db/brw4aa7v5/(_DBID_TEMP_TABLE_FOR_CLOCKING_IN_AND_OUT)?a=API_AddRecord&_fid_7=504&_fid_8=Now&apptoken=XXXXXXXXXXX&rdr=https%3A%2F%2Fsutubra.quickbase.com%2Fdb%2Fbrw4aa7v5%2F(_DBID_TIMECARDS)%3Fa%3Dq%26qid%3D8" , "domain": "tinyurl.com", "alias": "", "tags": ""}Any suggestions on what I am doing wrong?------------------------------Edward Hefter www.Sutubra.com------------------------------
Most summary reports have more data than will fit on one page, I'd like to find a way to lock or freeze the first row and the first column so that we are not guessing in which field the data lies. I have read elsewhere that it is browser dependent, and this is true to an extent, MS edge seems to have better scrolling features than Chrome. But on the other hand table reports always lock or freeze the first row and column. If this is not currently a feature, can it be put on the feature request list?------------------------------Brian Hunot------------------------------
Does anyone know if there is a way to copy a table to another app that has roughly 400mb of attachments? The typical copy table won't work with over 75mb. Any creative work arounds? For now, all i can think to do is a table to table import for the data, then manually download and upload all the attachments which I'm hoping to avoid (about 200 attachments...)------------------------------Mike Tamoush------------------------------
Has anyone else notice the behavior recently change on Microsoft firefox? Not sure if it is due to a recent update in QB or Firefox (this does not happen in Chrome), but curious if anyone else has suddenly experienced all QB pages 'double loading.'That is to say you click on a table, or record, or any page in quickbase, it begins to load and then immediately begins to load again. I started noticing this maybe a week ago. Curious if anyone has the same behavior and knows the cause. Definitely browser specific, so I can simply change browsers if needed, but wondering if anyone else has insight.------------------------------Mike Tamoush------------------------------
Hi folks. I would like to insert a counter in a Pipeline that counts the number of loops that fire. I suspect I can use the Buckets channel to do. Has anyone done something like this?------------------------------Spence Lloyd------------------------------
I have a field that will contain a number that I need for other activities and know there will be too much push back if the users are asked to go back and modify the data. The problem is further compounded by a lack of a standard entry format. My current approach is: var textlist values = Split([Number test], " "); var text valOne = Part(ToText($values), 1, ";"); var text valTwo = Part(ToText($values), 2, ";"); var text valThree = Part(ToText($values), 3, ";"); If(ToNumber($valOne) != 0, ToNumber($valOne), ToNumber($valTwo) != 0, ToNumber($valTwo), ToNumber($valThree) != 0, ToNumber($valThree)) This will handle the majority of the cases, but I cannot be positive that a user will not have more than two words before the store number and in some cases the user did not leave a space between text and the store number. I'm not sure I can do much about the latter. I'm hoping someone has a more effective solution to this issue.---------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.