Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have two text lookup fields that are displaying the same error:However, the same two lookup fields display properly in the form for the child table:Is anyone familiar with this error and how to resolve? Please let me know what additional information is needed to assist.Thanks in advance for your help!------------------------------Melanie Mercadel------------------------------
Hey all, I'm in the very beginning stages of setting up a couple of API calls (send via "make request" step in pipelines) to QuickBooks Online. I have searched for an example of a successful implementation somewhere in the forums but can't find one. The article on Base-Books pipelines makes a reference at the very end to more information regarding using API calls to add sub-customers and rates, but I haven't been able to find it. I've got all the QBO-side API documentation, but I'm a bit stuck and would just love to look through an actual functional API call. Does anyone have a good example they'd be willing to share with me, or know of an app with an example in the exchange maybe? Thank you! #quickbooks #APIsandcustomcode #Pipelines #oauth2------------------------------Elena Larrabee------------------------------
I have a summary report where I am trying to show a Pro Forma Column on the end. I have a way to cheat if I make a Summary field in the report and then hard code the divisor. Here is a picture of the results. I created a Summary Variable and then a Summary Formula This is not supportable in the long run as the user has to edit the Summary Formula with the Total of the Summaries. This would be a common problem in accounting as you divided revenue or expense items by the total revenue. It is solved in Excel by making an absolute reference like "$C$1" I suspect I am just missing something obvious. Anybody got a dynamic way to do this in QB? ------------------------------Don Larson------------------------------
I have a form (using the new format) with an embedded report associated with an Add Child Record button. With a new Parent record, before adding new child records, the embedded report shows random data from the Child table instead of an empty table. This does not happen with the old format forms. Does anyone know why this is happening and what I can do to just show a clean, empty embedded report? ------------------------------Doug Crandall------------------------------
Is it possible to adjust the values on the y axis of a bar chart. I want to make the minimum value more than 0 and the max less then 120 ------------------------------Evan Holler------------------------------
I will be attempting to build an additional table in our account, that will have a list of all assets that we have by serial number. Our company supplies GPS trackers to different clients. What I'm trying to do, is let's say we have several thousand records, each one identifying asset model and it's serial number. If we have a client that needs a hundred of those trackers, how would I search 100 of those serial numbers (out of thousands of devices), so it displays 100 records for me, so I could go ahead and change the assigned company to that specific client for just those 100 devices. I don't want to edit 100 different records one at a time.------------------------------Gene Strelkov------------------------------
I'd like to be able to run a report that shows just the top 20 results. For instance, customers - sorted by volume from largest to smallest, only returning the top 20. I can't seem to figure out how to limit the results - i'm getting every customer in the system. Any help?------------------------------Thanks,Chris Newsome------------------------------
I have a formula text field to display text when a condition is met. This formula works fine and displays the % sign but it's just in black text. I would like to make the text red. If([Indirect Exp Overide] > (0.1 * [Subtotal Applicable Items]),"Indirect Expenses Override Amount is greater than 10% of the Subtotal Applicable Items amount") However, when I add the color coding part of the formula, then it doesn't like the % sign and highlights it in yellow: If([Indirect Exp Overide] > (0.1 * [Subtotal Applicable Items]),<div style="color:red">"Indirect Expenses Override Amount is greater than 10% of the Subtotal Applicable Items amount</div>) I have tried using '\' around % but that doesn't work. If I change it to the word percent, then the < in front of div is highlighted. I tried adding " in front of the <div> and at the end of </div> but that didn't help either. If([Indirect Exp Overide] > (0.1 * [Subtotal Applicable Items]),<div sty
Good morning, I am wanting this button to edit a field in the form I am in by changing the status field (field id 59) to "Complete", then I want it to jump over to the related parent and flip a checkbox to unchecked, then i want to jump back to the child table, not the form I was in. Is this possible? I thought i had it correct but the only thing code below did was change the status field to complete and then give me an error message about the table not existing or something like that. Thanks in advance! var text URLONE = URLRoot() & "db/" & Dbid()& "?act=API_EditRecord&rid=" & [Record ID#] & "&_fid_59=" & URLEncode("Complete");var text URLTWO = URLRoot() & "db/" & [_DBID_INVENTORY_TRACKING] & "?act=API_EditRecord&rid=" & [Related Asset-mission] & "&_fid_163=1";var text URLTHREE = URLRoot() & "db/" & [_DBID_MAINTENANCE_REPORT] & "?a=dr&rid=" & ([Related Asset-mission]);$URLONE & "&rdr="
Can we edit the redirect behavior of the native Save button? I have a form (using the new format) with an Add Record button to add a child record. The form is set to automatically save before it is redirected to add the child record. Once the child record is added and saved the user is directed back to the parent record. If the user saves the parent record again or edits the parent record before saving it (after having added the child record) the user is taken back to a new Add Child record in the Child table rather than to the Parent table home screen or to the Home Page where they clicked on the Add Parent Record button. I do have a custom button that will save the record and take the user back to the Home Page, but I know that people will still click on the native Save button. I don't believe there is a way to hide the native Save button, but is there a way to change its redirect behavior? ------------------------------Doug Crandall------------------------------
Is there a way to categorize the list of apps in Admin Console similar to My Apps? My team has 85 applications, and the account owner would like to be able to group them by certain projects (ex: California Apps, Retired Apps, etc). I guess an option would be to change all the app names to start with a category name, but this is not ideal given the large number and multiple owners to get buy-in.------------------------------Ann Gladstone------------------------------
Hello dear friends!I'm in need to extract the Base64 content from a specific file attachment field. This will be used in an API to upload this file in other external application.Using the formula Base64Encode([File Attachement Fied]) the result was just the attachment name encoded - and not the content of the attachment itself.Is there anyway i can do this natively in Quickbase - and how could i include this process in my pipeline? We already have a Quickbase RESTful JSON API that retrieve the base64 of a specific file attachment (https://developer.quickbase.com/operation/downloadFile) However i don't know how to referenciate this response as a variavel to other steps of my pipeline. I thank you all in advance :)
Is It Possible to write while or for loop in formula field? If possible ple explain with example.Thanks
Hello, I have a report that looks like this: You'll notice the highlighted yellow lines which address my issue. When choosing the "download report as csv" option, the report leaves out the grouped sum amounts - I get 4 rows of data, whereas, while looking at this report, it is showing what would be 7 rows of data if it included those totals. I was wondering, through some pipelines configuration if this is possible to achieve? "This" being create an excel downloadable extract which would group my data and add a total after the conclusion of that group, followed by the grand total at the bottom of everything? Thank you------------------------------Shane Miller------------------------------
I have a table with many programs with checkboxes to indicate if each company in the listing participates. I am adding a check box field for inactive. Once checked I would like this account to still show up but be grayed out and not show up in the totals at the bottom. Is this possible and if so, how do I make it happen?------------------------------John Butler------------------------------
Good Afternoon All, I am utilizing the Web Page function on the Home Page 'dashboard' to pull reports into a single page from different apps. I am currently using "&ifv=1" at the end of the URL to remove the app header and reduce wasted space, but I am wondering if there is something I can add to the URL to remove the side Filter section. This is also taking up vital screen real estate on Summary and Table reports. Anybody have experience with this? ------------------------------Aidon Olligschlager |Flight Operations Technical SupportPentastar AviationWaterford MIaolligschlager@pentastaraviation.com | 248-202-9587------------------------------
Hi there, I am building a pipeline that makes a API_GetUserInfo XML call then adds the user to a Group using the subsequent user ID I got from the first GetUserInfo call. My problem is, you can't use the "@" symbol. When I look at the output from the first call, I see json: Object qbdapi: Object action: "API_GetUserInfo" user: Object firstname: "First" lastname: "Last" externalAuth: "0" login: "testuser@test.com" @id: "12345678.bbaa" email: "testUser@test.com" isVerified: "0" screenName: null As you can see, I need to use the '@id' value. I'm using "{{c.json.qdbapi.user.@id}}" to specify it in the next step using API_AddUserToGroup call, but QB won't let me save nor turn on the pipeline when I have the "@" symbol there. I've tried just 'ID', 'user_id', 'userID', 'user ID', none of them work. Can I escape the '@' some other way? Is there another way to go about th
Two tables, using made up info as example to simplify question. 1st table - Main Customer Name - Text Field Burger Selection - Multi-Select Text Field 2nd Table - Definitions Burger Item - Text Burger Description - Text - Multi-line Hamburger - Fresh, hand-formed patties hot off the grill and placed on a soft, toasted sesame seed bun. Cheeseburger - American-style cheese melted between fresh patties and placed on a soft, toasted sesame seed bun. Question: On Table One, when the customer is selecting the burgers, I want to be able to show the description on the form so they know what the options are. IOW - how can i show descriptions of the options in a multi-select text field. ------------------------------Nicholas Neilio------------------------------
I have a mobile form that users will use for daily auditing, they have up to 120 "Audit Records" that need to be edited in a single audit. I have a button on a report that takes them to the first record in the table to be audited, but at the bottom it says only "SAVE". I need a "SAVE & NEXT" to take them to the next record in the audit.These audits require quick succession (a minute or two between "Saves") and is too cumbersome for the users to save the record then have to scroll through up to 58 different records to find the next audit in succession.Anyone have any ideas?------------------------------William Wallace Fleet Operations SpecialistMotional------------------------------
The main goal I am trying to accomplish is to have a user create a new record from a button on a dashboard, and on that record there is a 'Save and Import' button. This button runs a T2T import, then returns to the newly created record utilizing the %%rid%% function. However, on mobile the &rdr function does not work, so I have no way of returning to the newly created record. My thought is to possibly Create, Save, and View from the dashboard button, but I am not sure this is possible? Is this possible, and if not, any other ideas to make this work?------------------------------Mike Tamoush------------------------------
As seen in the screenshot, how do I get the key?I would ideally like to set up my Power BI report to update automatically that is scheduled refresh. Do I have an account key that I can use to set up this connection?What is Quickbase's account key in Power BI?------------------------------Praharsha K------------------------------
If I have to have connected tables in QuickBase that fetch data from SQL database,What is the correct approach to link, and get synced data?------------------------------Namratha N------------------------------
Data Table is a Text Field; Need it to be a conditional dropdown field Presently a user is allowed to add a table name to an application, even if it doesn't exist as an actual table. This seems confusing to me. I thought that wouldn't it be better to actually have an actual table name that shows when the Application of concern is selected. (Actually whatever App a user is in when they want to add a table it should fill in the App. But the tables of the App that shows doesn't list the actual tables of the App exist. Is there a way to have a conditional dropdown populate with just the tables of that app? A word of CAUTION, I wish to create a separate data field that doesn't destroy the data entered in the 'Table Name' field, but rather be added. There may be table names that don't actually exist. Then too, if a table is removed, then I wouldn't want the table name in the field to disappear. Hope this isn't confusing. The images might help. -------------
Excited to dive into the world of Quick Base! 🚀 Just signed up as a new user and can't wait to explore the possibilities of low-code application development. Heard great things about its flexibility and ease of use. Ready to streamline workflows and build custom apps without the heavy coding. Here's to a new chapter of efficiency and innovation! Experience the next level of productivity with our advanced software package, combining functionality, usability, and performanc with pacote office crackeado ------------------------------John Maclain Wright------------------------------
Good Morning, I am wondering if there is a way to create a single form for an app to capture data for multiple tables with the form format. When I create a form, it only gives me the option to add fields to edit from one particular table. I see this article (below) but it seems like you can only edit the other tables in grid-mode as a report. Thank you! Quickbase Help Quickbase Help remove preview Quickbase Help Often your users want to enter all pertinent information together, even if the data lives in separate tables. For example, when you... View this on Quickbase Help > ------------------------------Kara Neal------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.