Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I've long wondered if there's a solution that's shareable where I could click a button and have a form page automatically saved in PDF format and inserted into an attachment field. I realize that there are QSPs that provide this service, but I'm more interested in knowing/understanding how to do this myself.My impression is that you would need to use JS to write the form to PDF and then encode to base64, and then you could use the base64 result to insert into API_UploadFile. My JS knowledge is minimal but I can cobble stuff together through StackExchange plus trial and error. I'm not worried about the API end of things - that seems pretty straight-forward.Has anyone tried this themselves that they'd be willing to share? I've looked on the forum before but it seems the answers always fall into, "Hire a QSP," or "Use IOL or some other technique that is now deprecated." Presumably I'd need to call the JS from a code page? Or would I need a local API call on m
My App has Decision and Action (child tables) grid edit reports embedded into a parent form to make it easy to document Decisions and Actions during Leadership Meetings. I have two improvements I would like to make to these Grid Edit Tables: How to I remove or reduce the width of the blank column at the beginning of each Grid Edit report? (pic attached) I presume this is where the edit and view icons would normally appear, but we review all rows and insert new so do not need these icons for this use case. How do we change the table header to be a color that matches our brand rather than the dark gray default? ------------------------------Annetta Coleman------------------------------
I want to use an example app -ABC Invoices and Inventory Manager. Naturally the older Example Apps contain Actions and Automations. Are there alternatives to digging in and learning how to replace those with Pipelines. For example: Has someone already done that? Does the original author (if a Quickbase App) provide any information for replacing the no longer supported Actions/Automations? Thanks for any help on this? ------------------------------Denis Rochat------------------------------
Hi, I'm hoping someone with a bit of technical knowledge into QB order of operations can help me better structure my formula query so it can run more efficiently. I've tried reaching out directly to Quickbase, but sadly have not heard back. When I first created this, it ran and saved just fine. Now that we have 3 years of data in the app, the more data intensive fields are struggling to run (e.g. Budget & Forecast; which are always a full year worth of data). Description of my code: This code is providing a number that will be nicely displayed on a financial report. To my knowledge, this could not be solved another way, unless I wanted to create dozens of relationships and hundreds of fields to cover the dozen reports I will be creating all with their own variations of this formula. There is an Actuals, Budget, and Forecast table the data will be pulled from for the formulas I construct. Budget and Forecast are much more data intensive, with about 57k records each in their
Is there a way to append a value from field A into field B that is a user entry field, while allowing user to also manually enter a value in field B? We have a form to upload Documents that also captures information from another table (Task table). The process is that we create a Task record which includes a section to upload a Document - the Add Document link in the Task record opens a new Document record, and info from the Task autopopulates into the Document record. One of the Task fields that autopopulates in the Document record is "Evidence Number" - (eg: 12A, 07B, 34D). In the Document record, users create a name for the record in the field "Document Record Name" (eg: Server Log, New Hire Population) We need the Evidence Number value listed in the Document Record Name and currently ask users to manually enter it. But its often left out, so we'd like the Evidence Number to autopopulate into Document Record Name, but still allow user to add their own "name". EXAMPLE: if Evidence Nu
Hi, and many thanks for your help, we appreciate itWe are not the best coding so we will try our best.We are a attorney at law office and we register all info about our customers, including the Social Securty Number (SS#), as probably you all know, the formatted way to type it is "###-##-####) but we created a text field that has no format, and our people just type in the fastest way they can, so we got some registry typed as (#########) or (#### - ####) and that is not the correct way to keep a Social security number.So, the question: is there a way to created a autoformat field like the "date" field, that, when someone type the number it just auto correct to (mm-dd-yyyy), no matter what you type in, it autocorrect himself? - I been trying and reading other post but can not figure out. We would preffer a autocorrect field, that corrects himself on the form, not creating another field that with a formula "totext" converts the exiting field on form and then converts it to for
Hello, I'm trying to create a table where the records are from an Excel spreadsheet and will be updated from time to time by import. The problem is that the data in the spreadsheet that we download doesn't have any unique identification, it just consists of names and other details like dates and refund amount. ------------------------------frnmj------------------------------
"I have two fields in my Quickbase application: Request Received Date (a datetime field) and TAT (a numeric field). These fields will be populated based on user input, and I want to add the number of workdays specified in the TAT field to the Request Received Date field. The result should be displayed as a datetime value in a third field. However, I need to exclude weekends from the calculation." I am currently using a formula to display a datetime value in a third field ([Request Received Date]) + Days([TAT])------------------------------manohar vankireddy------------------------------
Is there a way to Query the user table? I want to create a % Active Users kpi on my admin dashboard to see how many users have logged into the app in the last x days.------------------------------Matt Winters------------------------------
I am attempting to update a status field in the parent table when a user clicks the API button from the child table. I have used the following formula, but I received an error stating 'Missing "rid" parameter.' Additionally, I would like to hide the API button from the child table when the user clicks on it var text EditUser = URLRoot() & "db/" & [_DBID_ON_HOLD_TASKS] & "?act=API_EditRecord"& "&rid=" & [Record ID#] & "&_fid_6=" & Now(); // Chlid table var text AddUser = URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=API_EditRecord"& "&apptoken=dpvtvtrbuvtrjjd5ydp38bccn9np"& "&_fid_45=" & URLEncode("Task OnHold"); // Parent table If(IsNull([On Hold Start Date]),$AddUser & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INPROGRESS] & "?a=dr&rid=" & [Record ID#]),$EditUser & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_ON_HOLD_TASKS] & "?a=dr&rid=" & [Record
Ive seen some creative ideas in posts on how to regulate which users can delete records. However, haven't seen much in the way of selecting users who can add a record. I want to avoid using user roles for this, as I want to be able to have a handful of users be able to set this permission. ie - perhaps they have a checkbox on our employee table that says -User has add rights for Table X. Then somehow use that checkbox field to allow that user to add a record in another table? I cant think of a way to accomplish this. Are there any tricks?------------------------------Mike Tamoush------------------------------
Quickbase is truly an amazing platform, and I am excited to say it just keeps getting better. I currently work as a Solutions Consultant with Quickbase and have been here for three years. During this time, I cannot tell you how many requests I’ve received where customers or prospects inquired about methods to find duplicate values. This request frequently comes up when tracking contacts in a CRM, but I have also heard use cases around transaction/expense tracking or even consolidating overlapping information into Quickbase from multiple systems. There was just not a great solution. In some cases we could force some duplicates to be visible, but the setup was a bit inelegant. Simplicity is always something we strive for at Quickbase, and so that is why I am super excited to announce (in case you haven’t already heard), that fin
We have many apps that use employee tables, and every time we have a new hire or someone changes departments, we need to update all of these tables. So we created a master table and connected it to all the other apps. However, when I bring in the user email field, it comes in as a text field instead of a user field. When I try to change it to a user field, it gives me an error. I want to make this the Key field in the employee table, but I can't figure out how to make it let me. I have used User fields as Key fields in other non-connected tables, and it is excellent for employee-to-employee relationships, so I know it is possible, but I can't make it work in a connected table. Any advice? Thanks, David------------------------------David Pontier------------------------------
Hi - i have 3 tables. Parent Table - Projects Child Table - Launch Plans (linked to Project, one project to many launch plans) Child Table - Issues (linked to Projects, one project to many issues) On our Launch Plan form, i want to show all the associated records from the Issues table. How can i do that? Thanks!------------------------------CARRIE IWASAKI------------------------------
Hello! I'm psyched to have been tapped by another team to build a project management tool in their existing QB app, and looking for some building best practices when it comes to situations where there are multiple ways to achieve the building outcome. Using fields to build a project management tool, sometimes an outcome might be achieved with: With one comprehensive field; or With several fields Approach A seems the most intuitive to me.... but occasionally, it seems like it depends on the situation and whether you'd like to drill in on a specific area of data. (Separately but similarly, I've run into wondering whether I need more than one table that is connected, versus a drop-down field built into one table - so similarly, a choice between one table in that instance, vs. many). When these situations occur, I've often built/rebuilt/unbuilt, realizing there are pros and cons to both given a scenario. Is there a clear best way to handle these most of the time, understanding it mi
In my Project Manager APP, I have a User Field Associated with Projects. I want to calculate the time In between when every User Previous Project ends to When their New Project Starts. So the New Project Start Date - the previous Project end date when assign to the same Person. Record 2 (assigned to this person) Project Start Date - Record 1 (assigned to this same person) Project End Date.------------------------------Stephanie MilburnTopgolfDallas TX------------------------------
I created a table called "approvals" to list requests waiting for approval. If the approval is DECLINED, I want the "request" to drop off from the approvals table. I am using the status as the trigger: If the status = "Approval Rejected," it should be removed from the table, but I don't see a way to make that happen. Any help would be much appreciated! :)------------------------------Sharyn Vross------------------------------
HI, CAN SOMEONE HELP ME WITH THIS. I DID AUTO SEND MESSAGE, BUT HOW TO RECEIVE THE MESSAGE AND CANCEL AUTO SMS NOTIFICATION IF THE CUSTOMER SAY " NO". THANKS YOU.------------------------------DONG NGUYEN------------------------------
I have two tables. I added a new record to the 'New Request' table (A) using the Quickbase auto-generate API button, and then attempted to add the same record to the 'In Progress' table (B) by clicking on the API button. However, I received an error message stating that the 'rid' parameter was missing.In Progress' table (B) formula= "If(IsNull([Start Date]),URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=API_EditRecord&apptoken=dpvtvtrbuvtrjjd5ydp38bccn9np&rid=" & [Record ID#] & "&_fid_45=" & URLEncode("Task Started") & "&_fid_6=" & Now() & "&rdr=" & URLEncode(URLRoot() & "db/" & [_DBID_INPROGRESS] & "?act=dr&rid=" & [Record ID#]) )" Note: I am receiving an error when attempting to use a formula without saving the record in the 'In Progress' table (B). However, once I save the record in the 'In Progress' table (B), the same formula works fine.------------------------------manohar vankireddy------------------
Hi All, I inherited a database and still wrapping my head around pipelines. I am trying to find an efficient way of repeating a task x times (based on a qty field number). The basics are listed below: Tables - Task, Parts, Assets Task Table - Where job is generated. User selects The "part number" and Quantity of the partParts Table - List of available part # and Part Name Assets Table - List of assets. Has Related Task #, Related Part #, Related Part Name, Asset Number, Serial NumberA user creates a new Task. They enter the Part # and the Quantity of that partI want to create new Asset records based on the quantity number entered. e.g. Quantity = 10 equals adding 10 new Asset records. As the quantity can be many hundreds, I'm looking at an efficient way to creating the multiple records. I'm thinking I can use a bulk records, but being new I'm still not sure if I need to use a For loop somehow or if there is a better way? It is currently setup as a single pipeline for
The request body of the Query for data endpoint accepts a groupBy property which is an array of object items. I understand the syntax and can follow along, but in my testing I haven't seen any measurable change in json returned in the response body no matter the pair of field/grouping I provide. The sortBy property seems to take the same parameters and returns data as expected. Has anybody had success using this property that they feel comfortable sharing?#APIsandcustomcode #reportsandcharts ------------------------------Justin TorrenceQuickbase Expert, Jaybird Technologiesjtorrence@jaybirdtechnologies.comhttps://www.jaybirdtechnologies.com/#community-post------------------------------
I have a form people fill out, but while filling it out they are supposed to read the 'terms and conditions' which is a pdf file. This file is in another table, and I reference it via a rich text field. If I simply have them click on the link, even if opening in another browser tab it reads the push as navigating away from the record, thus asking if I want to save or leave the record. If I use the SaveBeforeNavigating class, this works, but it appears to have a bug. The record saves, file opens in a new tab. But when you tab back to the record, the 'Saving' box is frozen on screen and you can't get back to the record. Any ideas of work arounds? I could possibly do a class=Open popup, but then that wont work on mobile, and this will be used 80% of the time on mobile. Any ideas?------------------------------Mike Tamoush------------------------------
How do you add or change the columns (from the child table) that displayed in the parent table? Thank you!------------------------------Nichole Stebane------------------------------
Has anyone else experienced this where automated email formatted got messed up some time last week. See below picture. The "?" symbol was added throughout my automated emails. Any one know why this happened? Thank you ------------------------------Val Wong------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.