Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
When using the company directory and someone creates a record in quickbase. If the user chosen on that record leaves the company at a later date, would the prior employees name in the User field stick? Would updates still be able to be made with the person who is no longer in the list? ------------------------------Kari Lang------------------------------
I added a link to my logo for branding, but its quite small. Is there a way to control the size? I tried literally resizing the image and that does not work. Any other ways?------------------------------Mike Tamoush------------------------------
Hello,I'm trying to make a text field editable or read-only based on the value of a lookup field in the form. But it is not letting me create that formula. Is there a way around it? Thanks------------------------------Kirti Menghani------------------------------
I am getting errors on a few pipelines saying it can't add to the table due to duplicate key values; however, these values do not exist in the table. QB support is basically saying this is what sometimes happens in a DB with no solutions.Today I completely deleted the entire table and ran the pipelines again - the same errors.------------------------------Steve Laurel------------------------------
Is it possible to copy a FORM from app to another app that has identical table and field structure? ------------------------------Annetta Coleman------------------------------
I am wondering if anyone else has experienced this, before reporting it as a bug.On the new reports, when I change the sort order (click on a heading to ascend/descend the column), and then go into grid edit, it does not keep the sort order. The old reports would keep the sort order.Wondering if others have found this and if it is a bug or by design.------------------------------Mike Tamoush------------------------------
I'm using the API_AddRecord API on a formula URL button to submit a form as opposed to using the standard "Save & close" button. I'm doing this in order to redirect the user, to a "document saved" type code page. Within the API_AddRecord code, I'm simply pushing entered field values into existing fields. The Patient Date of Birth (fid_8), Sender Name (fid_10), Sender Phone Number (fid_11), Sender Email Address (fid_12), Patient Full Name (fid_20), and Uploaded Document (fid_16) are all required at the field level. There's a redirect that redirects to a code page within the app, a simple html page displaying "Your document has been successfully submitted.", then a setTimeout function that redirects back into the Quickbase app onto a blank form (same as the original form submit). That being said, once the user adds fields values and saves, they are redirected to the code page, then directed back into the app onto the form. For w
This work date formula field results in an error (can't refer to the field itself in a formula) How do I get around this? var date datetoo =ToDate([Start Date])+[Duration]+[Lag Time]; var date datetooadj =If([End date day of week.]=0,$datetoo+Days(1),If([End date day of week.]=1,$datetoo-Days(1))); var date dateholiday = If([Expected End Date (todate) - Name]<>"",$datetooadj+Days(1)); var workdate nextdate=ToWorkDate($dateholiday); If(not IsNull([End Date Override]),[End Date Override],$nextdate) ------------------------------Cloudbase Services------------------------------
I am building a formula field that needs to pull-in values from multiple records. It would pull-in the "# of Organic Users" field value from records that have a `created date` value that are during the last 6 months. The data will be displayed in the embedded bar graph (see attached screenshot below), which is a formula field built from basic HTML and inline CSS. Each field value mentioned previously would be represented as a bar in the bar chart. I'm not well-versed in querying other records/fields, so any help would be great, thanks!------------------------------Matt Makris------------------------------
Hello,My scenario has to do with baseball and creating rosters based on a persons preferred positions. Here is my scenario: Step A: Search Table 'Players' (Players table pulls in Text Field with the [Name] and a multi-select text with the persons [Preferred positions])Query- no filtersStep B: Search Table 'Game' (Game table pulls in Multi-Select [Attendance] with the Players that will be at that game, and multi-select fields for each position [catcher][pitcher][1st base], etc)Query- [B.Attendance] contains [A.name] (this only pulls people in that specific game) For Each B, if the Table A [A.Preferred_Positions] contains Catcher ThenUpdate Record B Games table:B.Catcher Field jinja: {% if b.catcher == none %} {{ a.name }}{% elif b.catcher != none %} {{ [a.name, b.catcher]|join(' ;') }}{% endif %}I recreated the for each loop with the condition for each position and then update each position. It works great during the first run, flawless. Pipelines will add each person's
Hi guys,I have a problem with formula in pipeline.I have to extract a substring at the end of a text field (e.serial_number) and in the JSON object (b.section_pos.fields.pos_wp_number)Format (example): CZXXX1000POSY or CZXXX1000POSYYNumber of characters between CZ and POS is not constant.I need to get Y or YY characters (numbers) after the substring POS.I tried to find response in previous community cases, but no one fit ...Thanks in advance!BRAlex------------------------------Aleksandar Lazic------------------------------
Hello,I've created a pipeline to Outlook that sends out our billing invoices. All of the emails are being sent from my account. I want to make it so that the emails actually come from the account of the person initiating the email. If that can't be done, I'd at least like to specify a different email account instead of mine. Is there a way to do this?------------------------------Lenny Brooks------------------------------
Hi QB Community, I'm wondering if its possible to check a checkbox via a button and then save a new record. The workflow is: Complete fields on Add form and click a 'Save & Continue' rich text formula button. The button uses the save before navigating class. Upon clicking the button it would also check a checkbox on the form, which would then trigger a pipeline.As of now, the record is saving but the checkbox not checking. I'm wondering if it's not possible because you can't edit a record that hasn't been added? This is the code I am using... var text rid = If([Record ID#]>0, ToText([Record ID#]), // Record ID already exists "%%rid%%" // New record, no Record ID exists yet ) ; var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $rid & "&_fid_18=1"; var text ButtonWords = "Save and Continue"; // Begin button style var text bgcolor = "#6BBD57"; // green var text txtcolor = "white"; var text style = "class='SaveBeforeNavigating' data-replac
Hello All,I use quickbase to keep track of industrial equipment as well as inspect and keep records of said equipment. Each piece of equipment has QR code linked to it directly in quickbase. I am trying to export both the data and the images so II can print them out with a Brady labeler. My issue right now is the only file format offered is CSV which does support images. I am curious if anyone else has run into this issue and has a solution. ------------------------------Phil Heron------------------------------
I have a table "Customers" and I have a table "Cruise Certificates". Currently I have a lookup in "Customers" to link the certificate that is issued to the customer. There are times when a customer is issued 2 or maybe 3 certificates. I do not know if I am overthinking it or if I just do not know how, but I need to be able to have 2 or 3 lookups but that will pull different certificates. Is this possible?------------------------------Kim Cameron------------------------------
We are using ViciDial as our dialer system and recently started to use quickbase as our crm, we would like to be able to click call on a record and it call through our dialer, is this doable? Also would we be able to transfer infomation into the record such as call time on the call, disposition, ect?------------------------------Mituin Varma------------------------------
I've reviewed many posts but haven't been able to find one that shows me how to correct my imported text from YYYYMMDD to date format MM-DD-YYYY. (I'm a beginner. Feel free to also tell me who your favorite YT trainer is.)------------------------------Emily Bejarano------------------------------
I have a start date and end date. I want to send reminder or notification every week between them. Any ideas would be helpful------------------------------Ramesh SinghRamesh------------------------------
In our standard app there is a Sales table. The default report has a field for Salesperson. This field is one of the dynamic filters on the report. Every few months, I get notified that "Quickbase is not working". What is happening is that someone has managed to change the default filters within the Sales table default report to look for Salesperson X rather than using the dynamic filter on the report page.Question #1: Is there a way to restrict someone from going into the default report and making changes? (Kind of like making a document "Read Only" in Word) I don't want to change permissions or restrict a field that is used in a lot of reports.Question #2: Is there a way to go in and see who has changed and saved the report? (So that I can talk to them, if the same person is responsible)Background: I don't use the Sales table in my day-to-day but have become the default Quickbase problem solver of the office. Which is why people are notifying
I need to change the table manager/owner of several tables in my app, is there a way to to do this? I cannot seems to find a solution, I am the realm admin. Any suggestions to make a permanent change like this? ------------------------------Kelly Lyons------------------------------
Conceivably this is a very simple thing, but all I'm intending on doing is passing a quickbase field into an HTML object embed on a code page. The use-case here is to filter and embedded Tableau report using the quickbase field. I've been able to successfully embed the HTML but am struggling to figure out how Quickbase "recognizes" and passes its fields into an HTML or Javascript object on a code page. ------------------------------Hanna Haddad------------------------------
Is there still no way to hide the New App button? It's the first button everyone tries to click, so I receive about 10 requests a week to try to create new apps. Has anyone come up with a way to remove this button??------------------------------Michael Tamoush------------------------------
Is there a way to set an entire table report as VIEW ONLY? thx------------------------------BuildPro------------------------------
Hello,I am trying to automate an email either by email notifications or a Pipeline based on updating a related field.I have 3 tables:1. All Flights - Enter any new flight in the schedule - I have a field called "flight verification" that is a multiple choice field allowing to show the flight as "pending" or "final.") - I have another multiple choice field for "Flight Status" with options "Active" or "Flown"2. Current Flights - Connected to "All Flights" and pulls only "Active" flights3. Request Log - Where passenger requesting a seat are entered - I have a related field from "Current Flights" so there is a drop down menu that only allows you to select "Active" flights- There is also a related field for the "Flight Verification"I would like to trigger an email that s
So I have information from two synced tables that I need to put in an embedded table, I believe it is possible but not sure how to go about it. I have the form (the request table) that I need to put an embedded table that has information from the projects table and the milestones table. hopeful you can help. thank you in advance!------------------------------Michelle Craig------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.