Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, I'm working on creating a new ERP system for our Supply Chain Inventory/Procurement purposes. I've set up the App to have a parent table: "Projects" with a child table "Products". So, one project has many products.I'm just seeking thoughts on if this is the right setup option for our uses. We may have instances where we receive in parts that are for inventory and will eventually be assigned to a Project. For example I could receive thousands of screws (Products) that will eventually need to be allocated to a certain Project. I'm wondering if I could make a Project called just "Parts for Inventory" and then as the parts are allocated, copy the Project, and reassign the screws to their applicable Project and out of "Parts for Inventory". What's the easiest way of doing this? I could manually subtract the quantity from Parts for Inventory and make a new Product record for the project, but is there an easier way? Let me know if this makes no sense :) Any insight would be much
Hi All,I'm creating a dashboard and I've brought in some gauge reports that look great.I created a couple more gauge reports in the same table, but when I try to bring them on to the dashboard, I can't see them in the list for the table. I've searched with no luck. Confirmed that I had created them in my stores table, but they just aren't there in the selection list.Any thoughts on why this might be happening?Thanks in advance,Kim------------------------------Kim------------------------------
I am curious if there is a way to color code a single field instead of an entire row in a report with the color-coding formula, or if there is a way to do it via the field itself. The field is a multiple choice type currently, so each choice would be a different color. Thank you------------------------------Ashley Gwozdz------------------------------
Hi,I have an app with 7 tables that are rosters for each vendor I keep track of. I need a way to search all 7 tables at once by the employee ID.------------------------------Fatima Khan------------------------------
I have an Employees table and a Safety Topics table. I have them joined with a Safety Assignments table to achieve a many to many relationship. My overall goal is to have someone post a new safety topic with attachments in the Safety Topics table and have that create an assignment in the Safety Assignments table for every employee to review the safety topic with an automated email for the employee to "check off" whether they have completed it or not. The employees don't have access to this app - only their supervisors, which is why I want an automated email that the employee can click a link that will update their record without them actually going into the app. I think I know how to do the email for the most part, but I can't figure out how to auto-create an assignment for each employee record whenever a new safety topic is created. I want to be able to look at the safety topics table and know who hasn't reviewed the safety topic.Any suggestions on how to do this or even if ther
It seems that the ask the user report filter on mobile will not show a dropdown list and is wanting the user to hard type. Can anyone confirm that is the functionality? Or is there something I am missing?------------------------------Mike Tamoush------------------------------
I've migrated most of the simple automations to pipelines and have started on the more complex automations. The first ones I started with are replacing the table to table import automations. I started with the documentation provided by Quickbase in the help section, but wasn't sure what to enter in the Headers section for the Name and Values fields for the Make a Request step. Then I looked at this post, Building Table-to-Table (T2T) Imports using Pipelines and saw it did not include the step for Make a Request. I deleted the step and the pipeline worked as needed. I have two questions, first, do I need the Make a Request step since it worked as needed without that step. Second, What values should go in the Name and Values fields of the Make a Request step?Thank you in advance.------------------------------Paul Peterson------------------------------
Looking to add a table report to an HTML page. I cannot seem to find any examples and have played with the options that are available with no success. If anyone is willing, looking to add a table report to an HTML page.------------------------------Chad------------------------------
Hi - I have created a time sheet entry tool using HTML and java script and am wondering, would it be possible to embed this on the main quick base site either on a form or a report. At the minute it is set up as another HTML page.Ideally all the functionality of the main site would remain with the HTML page showing within.Has anyone done anything like this or know if it is possible?Thanks in advance!Sean
Does anyone use firefox? When I use the new report, and apply a column filter, I can never see the original results again. My report goes blank. The only solve is to clear cache or switch to the old style. Is anyone else having this issue?------------------------------Mike Tamoush------------------------------
This is where I've landed after many attempts. I have the following dynamic form rules that aren't working to produce the desired result, i.e. if 30 days have lapsed since an application was approved AND no counseling date, mediation date, and outcome have been set THEN change the outcome to what's specified.andWe're trying to avoid manually triggering notifications for these folks.------------------------------Portia Egan------------------------------
I thought I would share a method I found to use Formula Queries to create an easily editable list of regional assignments for my users, without have to create any table-to-table relationships. I have two tables involved in this: Sites and FSC Assignments. Sites are a list of work sites and I needed a way to be able to give them regional assignments, but also to be able to edit these assignment easily. What I did was to create the table called 'FSC Assignments' and it holds only 1 record which is a list of all of the states and territories we work in and a list of my users regional assignments. It looks like this (I made a simple form to hold the fields neatly): Then, back in my Sites table, I have 2 fields using Formula Queries to grab the Region from the STATE/TERRITORY section and the user from the FSC REGION ASSIGNMENT in the single record of the FSC Assignments table. [Assigned Region] is just a Formula Text field and the code looks like t
I am adding a Formula URL button to my form. When someone clicks on the button I would like it to take them a particular website based on the state.For Example: If someone is in the form for the state of Alabama, when they click the button, I want it to take them to the state of Alabama's website.If someone is in the form for the state of Arkansas, when they click the button, I want it to take them to the state of Arkansas's website.etc......What would that formula look like?Thank you for your time.------------------------------Adam Ely------------------------------
I am trying to export text from a related field (the reference field) in one form to a related field (also reference) in a new record using the same form, essentially creating a copy of the form and pre-filling a few fields based on lookups.Is this simply not possible with a pipeline or is there a workaround I might be able to use?------------------------------Dante Tognoli------------------------------
It doesn't appear there is a means to clear errors in Pipelines.An Administrator needs to know an error occurred only in Production.If the error is corrected and the Pipeline restarted, the error should clear.This way the Builder can iteratively make corrections to the Pipeline and run again.Currently the errors clear after 7 days. What value does persisting errors for 7 days provide to Builders?------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Is it possible to use the same join/integrated table across apps and set the import field correctly.App A has a join table field for projects and organizations to allow multiple organizations to be added in an embedded form within App A. Would like App B to use populate the field correctly when its information is imported to App A in a daily automation. Do I use a cross-app relationship or connected table to set-up the fields in App B - to give App B the same connection to the same join/integrated table as A - so I can just set the import values one time in the daily automation import.------------------------------Lashell Thomas------------------------------
Is there a way to have the entry of a record on one table create/modify another table automatically?I need an user on table B to be able to add additional data, however not edit table A entry data. Ideally, user of table B would not see the record until user on table A creates it.Additionally, how do I remove the +Add record button from table B?------------------------------Alycn Bjergo-Justen------------------------------
Hi! Our company has two week time periods. Thanks to this community, I was able to figure out how to create a simple Time Period Formula as follows: FirstDayOfPeriod([Date], Weeks(2), Date(2021,5,19)), but then when I use it to try and filter in the report, I am struggling.Right now, I just put in the start date of the period and the end date of the period (see below), but this would, of course, require us to go into the report every new pay period and adjust the dates. How do I automate the report so that it always pulls up the current time period?Thank you in advance!Robin------------------------------Robin Wosje------------------------------
Hello:Just starting to use Pipelines. On my initial effort, I would like to trigger a text - multi-line entry based on a [Status Field] change.Example: If [Status] changes from "Hold" to "In Progress" make entry in [Installation Notes] = User "Updated Status to In Progress."I know this is simple, but I am just getting going.Dirk------------------------------Dirk Ruana------------------------------
I already have a support case open, but am wondering if anyone else has problems with From Rules not working for users out of the country. I have an app that is HEAVILY dependent on Form Rules and they are not working for my users outside of the US. As a possible alternative, is it possible to create a code page that could replace the Form?------------------------------Paul Peterson------------------------------
I'm trying to get a button that updates a record, opens the email client to send an email, and then reloads the report it's on, but I keep getting sent to a blank page. I can get the email client to open and for the API call to work successfully, but I can't get the report page to reload. Here's the button formula: var text URLONE = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&apptoken=abcdefg123456&rid=" & URLEncode([Record ID#]) & "&_fid_6=Ready for Compliance Review" & "&_fid_7=compliance@domain.com"; var text URLTWO = "MailTo:compliance@domain.com" &"?subject=" & URLEncode([PROJECT + Project source]) & " for Compliance" & "&body=" & URLEncode([PROJECT + Project source]) & " for Compliance attached."; var text URLTHREE = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); $URLONE & "&rdr=" & URLEncode($URLTW
Hello Database Experts!I recently started learning about Placekey and was wondering if anyone had any thoughts about it. On the surface it sounds like a great resource to use as a unique ID inside QuickBase tables to either easily relate tables to each other or to outside resources.Thanks!------------------------------David Semitekol------------------------------
One of my users recently got married and her work email address was updated. Will it have any adverse impact on her account if she changes the email address in "My Preferences"?------------------------------Paul Peterson------------------------------
Hello, I am wondering if the following process is possible. I am creating a database to manage department personnel. Every month a subscription email will be sent to dept managers with a report of their current department personnel list. One employee per record. Included in this email I would like the URL to add personnel or edit existing personnel. For instance, if manager clicks URL to add/edit personnel the form displays with the following fields. Name, department, title, Disposition, etc. The Name field would be a dropdown displaying the current values in the table showing employee name, department, and title. This dropdown should list this information in the event a title becomes "Vacant". You could have multiple "Vacant" positions with different departments so it should show this information.The manager would select the Name, department, title from the dropdown list and add the new employee's name in a "name" field or sel
I haven't heard back from customer service, but from my testing I am confident that there is the following bug with new dashboards.When using a chart that includes a summary formula as one of the values you display (Gross Margin % for example), the new dashboards will NOT display this chart. I can't think of any workaround, besides going old school and making summary tables (which I want to avoid of course at this point). Not sure if anyone else has run into this, but if you have, please create a ticket so that perhaps it gets on their radar. Also, another interesting bug is if you make a chart using summary formulas, you cannot change the color of the bar/line/pie slice. For example, if I make a line chart with Gross Margin % as the line, and that value is derived from summary formulas, that line will only be available in the default blue color. If you change the color it always reverts back to the default color.If someone has a work around or can confirm these bugs, please let me kno
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.