Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
New form experience beta All customers will soon benefit from a more intuitive, modern form experience. We’ve started enabling our new form designer for select customers. Read more about the feature and how to get involved below. Over the last few years, we’ve released updated dashboards, table reports, charts, and new ways to build reports. Our journey to improve the Quickbase user interface continues with a reimagined form experience aimed to increase productivity for both app builders and their users. With the new version of forms, you can accelerate the app development process with a drag and drop, WYSIWYG form builder to help your team, see, connect, and control their most complex work. We’ll be enabling this feature in waves as we learn about your experience and gather feedback that will inform our roadmap on the way to General Availability later this year. Customers can join the wait-list by registering in this app. What’s new We want to empower you with the tools you need to
Are there any options other than Pipelines (using Dropbox or something similar is not an option) that can simply import a CSV file? All I want to do is automate what we can already do manually in QB by selecting a file on the network drive and import. I was doing this 20 years ago in Microsoft Access so surely there is a low code/no code solution to this.------------------------------Brett Hinman------------------------------
Hello everyone,This is probably a super simple solution but for the life of me I have not been able to get it to work. I am trying to create a custom button that simply saves the record on a form that has both the parent and the child records in edit mode.Example:A parent record form has an embedded grid of related child records. When the parent record is in edit mode, the grid of child records is editable, so that the user can add or modify the related child records. At this point, the parent record has already been saved, so the record ID of the parent already exists.All I want my button to do is to save any changes made to both/either the parent or the child records. I want this button to work exactly like Quickbase's native "save & close" button.Thanks in advance for your help!------------------------------Juan Solorio------------------------------
I have a column titled Yes/No. The only results in that field will be Yes or no. I added another column titled # of Points. I want to be able to convert the Yes or No in the other field to a 1 or 0 in the # of Points field. I have searched and am not coming up with anything. I know how to get a number from 1 field to a number in another field, but not text to number. ------------------------------Jon Hurtado------------------------------
For the love of all things holy and before I throw my PC out the window.... I FINALLY got a button to add a new record to a child table with the prepopulated fields I need. Code is "<a href='" &URLRoot() & "db/btcpg7sph?a=API_GenAddRecordForm&dfid=2" &"&_fid_18=" & URLEncode([Related Request]) &"&_fid_20=" & URLEncode([Request - Order Number]) &"&_fid_19=" & URLEncode([Request - Name]) &"'>" &"<img src='https://expertclaimmanagement.quickbase.com/up/btegrvwjr/g/rb/eh/va/ADD%20NEXT%20ITEM.png' alt='Save & New'>" &"</a>" The problem is, of course, that it doesn't save the current form. So, I just set the application settings to auto-save if a page is navigated away from. The problem is that it still throws the Leave site warning message which confuses the 75-year-olds using this form. So I created this button var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" &a
Hello, I am trying to create a button that will redirect users to users to the same record in another app where they can edit information. I've used several different formulas with partial success. Below is all relevant information: Table ID I am trying to redirect to: btan5p92a?a?a Matching Field ID in other app: 261 Examples formulas I have written utilizing the Formula-URL field type: 1) URLRoot() & "/db/btan5p92a?a?a" & "?act=API_EditRecordForm&_fid_261=" & [Project ID] & "&z=" & Rurl() 2)URLRoot() & "/db/btan5p92a?a?a" & Dbid() & "?a=API_EditRecord&rid=" & [Project ID] & "&rdr="&URLEncode(URLRoot() & "/db/btan5p92a?a?a" & Dbid() & "?a=doredirect&z=" & Rurl()) Both formulas redirect to the apps homepage, but not to the specific table or form. Is this possible to create? ------------------------------Sarah Driscoll------------------------------
I am trying to implement the new form into one of my workflows. The user will add a new record on the parent record and select the "add child record" button. The parent record auto-saves and directs the user to the child record table as expected. The problem comes in when the user selects save on the child record. An error pops up and says there was a problem saving the record. Is anyone else experiencing this issue or am I missing something?------------------------------Amber Polston------------------------------
I feel I may have seen this on here before, but I can not recall where. Is it possible to dynamically filter a list? For example if I only want to see foreman in a list, is this possible. If so how? ------------------------------William Hunter------------------------------
I have two related tables Site Visits<Travel Partners. I have a notification in the Site Visits table that goes to the travel agency with all the travel information for the candidate (Site Visits table) and their travel partner(s) (Travel Partners table). I want the travel partners reports to display in the notification as a report, not the report link. Maybe my brain is just tired, but I cannot for the life of me figure it out. Forms give the option to display the report instead of the link. How can I code this behavior into the notification? ------------------------------Sherry BlackburnSr. Applications Systems Analyst (Quickbase) PeaceHealth------------------------------
I want to: Hit a button Update a Field in that record Open a popup Close the popup (when a button is pushed) Return to the original page I have steps 1, 2, 5 working with the below code on my URL-formula field. I haven't been able to figure out steps 3,4 (the popup). var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=<mytoken>&rid=" &[Record ID#] & "&_fid_10=" & Now() & "&rdr=" & URLEncode($RefreshPage)------------------------------Aaron Bab1692@att.com------------------------------
I have a simple URL page. I created a 'Page' button on my home page from the 'Button Bar Widget'. I want that page to open in a popup window and close when I hit the 'Close' button. When I preview the page, the 'Close' button works fine. When I execute the button from the Home Page, it does not work. Regarding opening it as a popup, I've tried multiple javascript and html options, but none have worked. Any help will be appreciated. Code for the URL page is as follows: ------------------------------------- <script>window.resizeTo(950,500);</script> <h3><p><u>Information Text Goes Here</u></h3> <button onclick="self.close()">Close</button> ------------------------------------- ------------------------------Aaron Bab1692@att.com------------------------------
Hello, I have a csv being generated and sent to my personal email every few hours from an external source. I would like to create a pipeline that connects to my outlook email, take the csv file, and upload them into the fields mentioned. So essentially, a new email is received to my outlook into a specific folder, the pipeline gets triggered and takes the csv from the email received. I tried the image attached, however it keeps telling me 'no email found'. Any idea if these are the necessary steps, or if I should remove one and add another?------------------------------Ziyad Elabady------------------------------
I am trying to figure out how to set up a "system-generated" account log (system generated account activity such as when a user clicks a button that generates a document) for recording certain actions. For example when anyone adds any type of child records, edits a record, emails a specific invoice, changes the status of child records (ie changes the status of a record, authorizes and schedules a patient for something), I want to have this type of activity documented separately from any data entry/notes that they enter directly. And even when they add a note directly, some type of table to keep track of all activity related to the parent record. I would like this documented as "system admin" and not by the actual user since this is already in another place. What is the best way to tackle something like this? Would I want to create a new user - System Admin - and then create some type of pipeline to capture these changes as the admin? Wou
Hello all. Long time no talk!Anyway, I started using QB for my company in 2006 to records problems/solutions found in the field by our field service engineers related to our products. We know have 65K+ cases! Of course now the issue is to search for similar issue in this immense database! For instance, it will be useful four junior engineers confront with similar problems in the field. At least to give them a list of similar issues cases to help them fix the tool. But as you can imagine a QB keyword Seach type is almost useless with the database is that large. One because if the keyword is not present (or miss-spelled) then QB will not find the similar cases. Or sometimes it returns 100's cases! For instance say the "beam is unstable" and "the beam is What we need is a semantic search option with QB. Or even better a tool like chatGPT applied to the 1000's of cases already in the databases. I have been experimenting with chatGPT, chatPDF and also with CLAUDE (dif
Hi everyone, I'm trying to figure out how to create a table of workshop sessions, where if you register for the "first" session, you're automatically registered for all of them. I can get a Pipeline to create a new record when you tick the box to register for all sessions in a series, but how do I tell Quickbase to create records associated with that series' of workshop sessions? I've spent a few hours now in Pipelines reading through the logic sequence, and honestly, my head is starting to hurt trying to make sense of the logic tree. At no point can I specify 'if box is checked, search for matching session ID, create additional records for all sessions with matching session ID'. Any suggestions? I realize it's late Sunday evening, and so it's possible I'm overlooking the obvious answer. Thank you!------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------
My pipeline is sending out emails with a Due date. I would like the field only to display the date only right now it is displaying. 2023-07-03 00:00:00+00:00. How do I format only to show just the date part: 2023-07-03------------------------------NOEL HODGES------------------------------
Hello I wanted to see if there was a way to calculate someone's age based on the day that they enrolled with us. I have the DOB as a date field and the Start date as well. It would be easy to just do [DOB]- [Start Date] and get the days but I would like the answer to be displayed in years if the person is older than 1 year old and displayed in months if they are less than a year old on a Formula-Text field. Majority of Clients are Children but we also have mothers join programs. Would this be possible or is manually the only way? Thank you in advance, I appreciate your help. ------------------------------Maritza Acosta Gonzalez------------------------------
Hello, I am looking to create a formula that shows how many days an item is overdue for calibration using a completed checkbox and a due date field. So, basically...If the "Calibration Complete" box is checked, and the "Calibration Due Date" is prior to or on Today then it displays the number of days overdue. I am fairly new to QuickBase and struggling to figure out how to formulate that. Thank you for your help/time! ------------------------------Brittany Bedore------------------------------
A recent email from QB said we can control how often our KPI widgets refresh. They show this: This looks like it is in the report settings? But I cannot find it. Has anyone been able to find this?------------------------------Mike Tamoush------------------------------
I'm trying to create a Pipeline which will Trigger on the upload of a CSV file to a Quickbase table, Then Fetch the file, Then Iterate over CSV recordsThen For Each, Create a record in a Quickbase table.The issue that I'm having is the try as I might, the process will not "see" the first column of the CSV file. I had to introduce a dummy column in column A of the CSV file to get the Pipeline to "see" both subsequent columns. In my small test I only have two columns to import - (ie two fields) and before I introduced the extra dummy column, it would always leave the field blank for the data in column A of the CSV file.Has anyone else run into this issue?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
Hi everyone, This is my first post in this forum, so if I'm posting this in an inappropriate place, please let me know. I have a table that is connected to Google Drive, and because of irreconcilable issue on the machine where the files are being generated, occasionally those files will not sync properly and will show up in Google Drive as a 0kb (empty) csv. QuickBase get's stuck and will not ingest any subsequent files until that one has been cleared from the folder. I thought I might be able to have Pipelines look for 0kb files in Google Drive every day and delete them, to clear the logjam, but I can't figure out how to query for a file size property in that channel. Is this possible, and if so how is it achieved. Thanks in advance for any suggestions!------------------------------John Pugh------------------------------
Hello, I am trying to make a report link live update as the form is being created. When I set the matching value before creating the form, it works fine. When I attempt to change the value while the adding to the form, it refuses to recognize it. Any tips/way to get the report link to update as I am building it? Thanks, Sean------------------------------Sean W------------------------------
I don't see a channel for this, but I thought I would ask. Is there anyway to have a pipeline step place a file onto an FTP path?------------------------------Mark Shnier (Your Quickbase Coach)mark.shnier@gmail.com------------------------------
Is it possible, maybe with a code page, to target the radio buttons of a multiple choice field on a form and custom css style them only? I'm trying to avoid building a fully custom html/css form because I ASSUME I will not be able to show/hide the fields with form rules..... but I may be completely wrong in that assumption. Can you still be able to use form rules as usual in a fully custom form?------------------------------Dan Beauchamp------------------------------
Has anyone figured this out? How to get either a field, or hard typed data to be copied to clipboard with a button push? There are old posts that can do it with javascript. Im wondering if anyone has figured it out without that.------------------------------Mike Tamoush------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.