Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Good morning. I have an Employees Table, and a projects table. I set up a relationship where where 1 employee has many projects. But I need the project to have 2 drop downs - one where I choose a Sales Rep, and one where I choose a Project Manager, but both are based on the Employees Table. On the form for Projects, I want to be able to choose a sales rep from a drop down list, and have it display the Name & Phone number for the Sales Rep, and then choose the Project Manger and have it display the same info. How can I make this work? TIA------------------------------Allison Watson------------------------------
Hi, I have a doubt regarding notification. How can I send a custom message based on role ? Is there a way to hide a certain section of the form when the notification is sent to non-admin role ? or do I need to create another form based on user role ? Thanks.------------------------------Kirti Menghani------------------------------
Need a formula text field based on two other text fields Would like my field to display "Done" when Application Status is NOT equal to approved Closure Status is NOT equal to approved ------------------------------OIS-APPS1 DEV------------------------------
I have a Projects Table and a Work Order Table. One project has many Work Orders. I want my work order numbers to be based on the Project ID field from the projects table. For example, if my project number is 12345, then I want my work orders to be 12345-A or 12345-B. I know there has to be a way to do this, but I can't figure out the formula. TIA------------------------------Allison Watson------------------------------
Hello Everyone, I am trying to make a Kanban board for actions that needs to be passed down to another team. The expected outcome would be that when a user ticks the checkbox then that record should be added to the kanban board. How should I approach this?------------------------------Timothy Dumancas------------------------------
I have always struggled with the following, and wonder what creative solutions people have come up with. When building a form, say an equipment request form, the user would fill out some typical info, and then need to create a list of equipment to request. The best practice way for this is to create a child table. Here are the issues I run into when trying to use a child table in a form: Editable Report Links would be the perfect solution, except for the terrible interface where when you double click on cells, particular the very right cell, you don't really 'see' the entire selection. You always end up scrolling the report link to the right etc. It's particularly wonky when the far right column is a drop down selection. Any way to combat this awkwardness? Alternatively, could just use the 'Add Child Record' button. Works, but not super user friendly as they have to hit 'save and next' until they are done. Additionally, they need to figure out how to delete the child record if they de
I have searched the API, formulas and community and don't see anything. Wondering if there is an API function for adding the current user to a User List through a URL Formula?The idea is to expose a button on a report that says Subscribe on it. When the User clicks the button their username is added to the User List field. The report is displayed on the App Home page, where each record is a separate topic of interest. We won't have a lot of Subscribers so a User List is ok. We want to experience to exclude opening the record and adding the User name to the list. This doesn't work:URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid61=User()&apptoken=URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&_fid61=[??WHAT DO IT PUT HERE??]&apptoken=Thoughts?------------------------------Jim Harrison------------------------------
Hi All, Just needed some help refining my advanced query to only search for records where a table's date field is from the last week. I have a table which has a "Completed Date" Date field (FID=117). I have a Pipeline where I want to create a report for all matching records completed during the last 7 days. I have the below query where the syntax doesn't appear to be quite right. If I just use {'117'.GTE.('today'} if will pull records successfully matching today's date. {'117'.GTE.('today' -time.delta(days=6))} Can someone help correct my syntax to search records from the previous 7 days? Thanks.------------------------------Grant K------------------------------
Use case: I want the data from Table A,B,C,D,E,F to flow into Table G. I want this table G have data whenever a new record gets created in the tables. Initally I created a relationship but that isn't useful as the user has to pick a case every time. So my thought is to make couple pipelines to execute this. Please guide if I am doing it right?------------------------------XYZXYZ------------------------------
I have never ran into this issue before. I copied my app in QuickBase and then I started copying all the pipelines to connect to the new App. In total there are 58 pipelines that have to be copied over. When I get to pipeline # 43, it gives the "Only 90 pipelines may be created for this table". Not all the pipelines trigger on the same table, so there's no way I have hit the 90 pipeline limit. (this is a common process before and have never had this issue). I am the only one that makes pipelines so I know someone else isn't adding them, plus I am the only one with access to the app as I don't provide access until the pipelines are all added. Anyone have any ideas on why I may be experiencing this? Error:Connection Central for number of connected Pipelines to App:------------------------------Kaitlyn Stanley------------------------------
I was working with a development team who created a button I can click on which displays a word document and the document changes based on certain slections from the main form. Below is a screenshot. I am looking to use this same method to add a new form. i.e. take a word document attach it to quickbase and allow certain items to fill in or be checked off based off what is selected on the main form ------------------------------Rebecca Knecht, MS, ACSM-CEP------------------------------
Has anyone else run into this? I am trying to set a custom rule for viewing records in a table. It is simple: Go to a role, and select custom rule: A record can only be viewed when [Field A]=True. This works perfect if the field is a scalar field in the record. If it is a lookup field, it works on the very first test, then immediately stops working. If you test it twice, it just never works again. Very strange?? Has anyone else experienced this and have a work around? I have tested with text fields and checkbox fields. Once they are lookup fields, it appears to work on your first test, then stops working immediately. ------------------------------Mike Tamoush------------------------------
Hi, I'm trying to add color coding to my report for records that have a last revised date of on or before 2 years from the current day's date. Is there a formula for this?------------------------------Amy Migliore------------------------------
Need help creating this please: I suggest keeping it simple, at least initially, and create a Summary field on parent table (Employees) that sums the child (PTO Requests) time. Then, subtract that value from the where you are storing the 20 day value on the Employees table. Watch out for your formula data types (duration vs. number), QB will bark at you and guide you to what it is expecting.------------------------------BuildPro------------------------------
Has anyone ever tried using Service Workers and what was the outcome on the actual user interface? I know there is a Register Service Worker phase, if it is registered once does each specific user have to register it? Or does the one time registration activate it. ------------------------------Adis Kljajic------------------------------
I want to export all of the fields from my database to a sheet, how can I do it?------------------------------Ngan Dinh------------------------------
Hello All, Happy St. Patrick's Day! I have a group of people that I need to remind to sign in to a website every 30 days after their last sign-in. I thought I had this all vetted out, but now after I've rolled out the new process, I've noticed one hiccup: I have a formula checkbox that will automatically check itself when today's date is 30 days after their last sign-in date. This is supposed to trigger a modification notification that then sends them an email with instructions to sign back in. However, the formula checkbox doesn't actually count as "modifying" the record. So, I have to do this manually until I can figure out a fix. Any ideas? I was thinking I could possibly create a pipeline that modifies a new field -- let's call it "today" date field -- on a daily basis, which I'm hoping would trigger the email to be sent. Anyone have any insight or a similar experience they can relate to? ------------------------------Aidon Olli
Hello - Looking for some advice on how to consolidate pipelines. Pipeline 1 objective: when a record is created with Field A(trigger table) = X or Y or Z and Field B(trigger table) = 1; search a table for Field A and create a child record for each returned with Field C(child table) = 100%. Pipeline 2 objective: when a record is created with Field A(trigger table) = X or Y or Z and Field B(trigger table) != 1; search a table for Field A and create a child record for each returned with Field C(child table) = 0%. Is there a way to accomplish this in one pipeline? I have several use cases for this pipeline so they are quickly adding up to a lot to manage. ------------------------------Thanks in advance,Jennifer Paschal------------------------------
I am receiving the following error popup when I try to save a formula field with a query function in it: "Uh-Oh! The way this formula is built will take too long to process. Please try refining your formula." var date prevDay = [Date Yesterday]-Days(1);GetFieldValues(GetRecords("{63.EX.'"& $prevday &"'}AND{69.EX.'" & [Related Product] & "'}"),143) It's a large table, but this is unavoidable. Is there a way to skirt around this? This is very disappointing Quickbase hasn't figured this out yet. Thanks! ------------------------------Matt Makris------------------------------
If I have tables Table A and B how do I create a pipeline that changes Table B's owner to match Related Table B's Owner? Example Start: Table A Record Owner: Jim Table B Record owner Jerry Table B Record is updated by a user End: Table A and B Record Owner: Jim ------------------------------Nicholas Geer------------------------------
I have a table (Product History) that contains a daily history of another table (Products) in my app. I am trying to create a line chart in the Product History table that shows how many Clients in our database subscribe to each product we offer, but I can't seem to figure how how to make this work. The closest I can get to this idea is listing the number of product subscriptions, rather than the number of clients for each product type because a `Client` can have multiple products (ie- Acme, Inc. has a record for SEO and Advertising in the `Product History` table). Here is my ideal report setup: X Axis (horizontal): Date Y Axis (vertical): # of Clients (this is what I can't figure out - this field does not exist yet) Series: Product Type The table `Product History` is written to every day by a Pipeline that copies field values from `Products`, so that we have a daily historical record of the `Products` records. What am I missing here? Thank you in advance 🙏 .----------------
Hello! I have a report with 66,698 records and is 400MB of spcae. I really need to be able to access all records in some manner (they are basically patient appointments I may need to refer back to) Is there anyway to keep these in one report and optimize them or maybe build a second report for anything after a certain date??? The way it works is each patient has many appointments and I want to keep adding appointments to each patient and still be ale to review back as many years as needed. o far we have about 2 years of data on here so I expect to make it through bout 6 more months before reching the full limit. Any suggestions would be super helpful. ------------------------------Rebecca Knecht, MS, ACSM-CEP------------------------------
Has anyone ever seen a relation ship existing in the child table settings, but not existing in the parent table settings? I have heard of orphan records, but I imagined that if a relationship was deleted that it would not exist in either the child or parent settings. I found this when I noticed the related record fields was blank in the child table. I looked at the table-to-table relationships settings and the relationship is shown. I open the parent table-to-table relationships settings and the relationship is not shown.------------------------------Adam Keever------------------------------
Anyone else experiencing lookup values not changing in grid edit? There is a relationship where the related record has a lookup field for supervisor name. When the lookup is used in grid edit it is a dropdown menu. When it is used to change to another supervisor, the name doesn't change until the grid edit is saved. It is deceptive because you can't tell what has been changed until you save the grid edit.------------------------------Adam Keever------------------------------
Is it safe to store credit card information (number & exp date only) in Quickbase? Has anyone had any experience with this? ------------------------------Khalid Daoud------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.