Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I ahve a table that breaks down "Fire Calls" in table 1. I have table 2 that needs to have a formula of "total of fire calls" divided by ESD 7 calls. I haven't had to pull numbers from another table up to this point. I am going to look in help and other resources, but I always think this group will be faster or add clarification.------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
What is the best way to capture approvals in Quick Base?------------------------------CINDY KRAUSCH------------------------------
I have included the link to a related thread for this topic. I just need additional info/help and have described my issue under the link https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=a3c3baa3-807d-4295-ac20-4f7dc5250cd0&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer Here is a summary of what I need to accomplish: I have an EXPENSE leader table. Each expense can have multiple Dates of Service listed. For example: Expense #1 has 3 dates of service (similar to a line item) and a total due of $5000.00 Each listed expense below can/does have multiple related LINKS to it. Date of expense = 2/26/24 Total $ 1500.00 - Date of expense = 1/23/24 Total $ 1500.00 Date of Expense = 1/1/24 Total $ 2000.00 I have a Links table that is the joining table between my INVOICES table and EXPENSES tables. Invoices and Expen
There has been a documented bug on mobile for about 9 years, that they never fixed. I thought years ago I created a feedback for this, but I guess I didn't. The bug is that any embedded report link on mobile has a green + mark that users can use to create new records. This is supposed to be hidden when using the 'hide add New Buttons' in your user role permissions, but it does not work. Thus, if you have a custom button, users can bypass it. Also, if your report link is not for a child table, users can create orphaned records. If you have run into this issue, please go here and upvote! Quickbase has stated they will not fix mobile bugs since they are working on the new mobile reports, however, they said this 5 years ago so I am hoping not to wait another 5 years for this fix! https://feedback.quickbase.com/app/#/case/380452?currentProductId=3c9d7e83-da43-482e-a58c-14265037ecd0------------------------------Mike Tamoush------------------------------
Hi Everyone, A reminder that we are planning site maintenance for community.quickbase.com from April 1st-April 9th. This week, you can still post to this site, all discussions should remain active and there shouldn't be any disruption to your experience here. Next week, starting April 1st, you will not be able to sign in and post discussions. You will not be able to sign in at all to download documents or engage with other members of The Qrew. The website will be read-only, searching should remain working. On April 9th, we'll be going live with a new experience on community.quickbase.com. The website will have a different appearance. I'll have some quick enablement videos on what's changed on April 9th. Please read FAQ here. Qrew members looking to engage with other Qrew members outside of this website can do so via the community-led Discord server, access here. ------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Qrew Discus
Can I make my charts start with the largest value and step down to smallest? ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Hi, I have a pipeline that searches for records based on a status. It then uses the Bucket "Add a Row" in order to put those records and respective data into the Bucket Table that is defined (see picture below). After the rows are added, I have the CSV downloading (see picture) if the list of records exist. But that is where it is not working. In essence, I only want the Download CSV to happen if there is data and rows. Is there a way to query the Bucket rows or somehow check if data exists first? ------------------------------Lija Harris------------------------------
Hi, I would like to add link to alternate text of a field in a quickbase form: example of alternate text: please select yes, if you belongs to this list of countries. if a person clicks on list it should redirect to link that I have attached. Please help. ------------------------------vikas pasula------------------------------
Hello, I am new to Quickbase .I am trying to explore the new Gantt plugin .I am using the trial version.I installed the Quickbase Gantt Template App from the exchange and the permission to install plugins for all admin is turned on. Still in the app settings under plugins the install option is not visible. What am i missing? ,is it that it is not available in trial version of Quickbase? Thank you ------------------------------Ritu goyal------------------------------
Hi, Im performing a API Call to Fastfield to update a Lookup List, "UpdateLookupList" a PUT call and i need help with attaching the .CSV file to a Fetch JSON pipeline step. there is no errors when i perform a GET request but for the PUT to do the update i need to attach the file to to the update but I dont know where exactly or how to attach it, in JSON URL with the endpoint? request body? or it needs another step to do that, here i attach some screenshots of my pipeline. Just for some more information, I managed to make to work the (GetLookupList) API call and this was a GET and did not required a file. ------------------------------Gonzalo Carrasco------------------------------
Hi, I'm having trouble to attach a file to perform an UpdateLookupList API call to Fastfield in my Pipeline. The requirements of this API call are: request session token, API key, file to be updated (.csv) and endpoint. I manage to get working "GetLookupList" API call since this one does not require a file with JSON Handler. How can i attach a file to use for the update? ------------------------------Gonzalo Carrasco------------------------------
Is there anyway to give access to all or certain pipelines to other quickbase developers without making them a full realm admin ? ------------------------------Trevor Kent------------------------------
I have a table of Projects. Each Project has the following fields (for this example, they can be checkbox fields) Requested by/Submitted to CustomerIn PreparationSubmitted to HNCApproved by HNCExecutedDisapproved/CancelledIn Progress *Multiple checkboxes may be true for any given record. Additionally there is a multiple Choice that labels each record as: RSO, ESO, Urgent, or Long Lead (only one selection possible), and a Total Cost field. The goal is to make a table or summary report that looks like below: Because a single record may fit into multiple categories, it is stumping me. My only current idea is to use a helper table that has 7 records (corresponding to each SO Category). Then use formula queries to get the all the numbers, so in total 5 formula queries (RSO, ESO, Urgent, Long Lead, and Total Cost). I dont anticiapte more than say, 1000 projects so I don't think the formula queries will be too memory intensive, but I also try to stay away from them as much as poss
I've been trying to for days to figure this out on my own and I can't. I'm newish to writing formulas, and I'm not even sure if what I'm trying to do is best or even right. I have Table A, Employees. I have Tables B, for tracking probationary meetings. I have the relationship set up that Table A is the parent and Table B is the child. I need to track whether the employee had a meeting and that it happened prior to the due date. However, I can't have a lookup field from the child go to the parent. I need to bring the date from Table B to Table A so I can set up a report that will color code the record if the meeting was not done on time. I know how to do the color coding part, I just need help with getting the field from Table B to Table A. I've tried the GetFieldValues but I don't know how to point to a different table's field id. Table A emp id field is id 9. Table B related emp id is field id 15 and date is field id 28. Help! And thank you in advance!---------------------------
I need to build a way to select multiple existing items from a catalog table to add to a new parent record. Is there a way to do that?------------------------------Julie Meeker------------------------------
Hello community An error is happening to me in my applications, in my reports my "Pick a report" is changed to "Default Setting". How can I solve this problem or what is the cause?------------------------------Herberth Solano------------------------------
Does anyone else have trouble with pipelines either telling them: Looks like you are offline (in the middle of building the pipeline) Not saving your changes (if I try to refresh the page or leave, it keeps saying, if you leave you will lose your changes - yet I have no way to force save the changes) Generally running and loading VERY slowly (more slowly in the last few months) If it is just me, I'll contact customer support. However, wondering if it is others as well? These annoyances are especially critical now that they are ending life of webhooks.------------------------------Mike Tamoush------------------------------
Hello, Team. It's been a minute. Thank you for all the help the last two months. Need help with a stacked bar chart. It currently shows like this... I need it to reflect the % of the year, not the series. Like this... ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I have a couple of use cases where I want to start experimenting with Code Pages. We think they will be a great option for us to create an elegant interface for external participants like clients and vendors. I am having no issues creating pages and buttons to launch those pages. The front end development side of it makes sense to me. The part I am struggling with is I am not sure the best practice for passing record information to the code page to display on there. For example, we have records for jobs for our vendors. I would love to have a job summary page that displays the date, time and address info from that job record. Thanks in advance!------------------------------Nick Sheetz------------------------------
Background: Currently I have an app home page set up. I wanted to add button sized count reports from another app so I created a dashboard with report info and the app home page added below. Currently the dashboard is accessible via a link on the app home page. When I add records to any table using the home page, the app saves properly. When I do the exact same thing from the dashboard, then the app home page, the save never completes. Question: Is this something that anyone else has experienced and if so, is there a solution to have it operate as normal when saving records?------------------------------Sam Nolette------------------------------
Hello - I'm in the process of updating our current form to the new beta form version. When you add a report, the layout in the UI of the form seems a bit strange and spread out. Is there a way to customize how the report looks to match how it looked in the old form? ------------------------------DIPA PANCHALL------------------------------
@Ben Simon @Evan Martinez Just wondering if there is a way for you to start deleting all the recent spam posts? Or perhaps, maybe we need a way to be able to report them? I am presuming these are all spam...I have seen an increased amount over the last week. ------------------------------Mike Tamoush------------------------------
Hello QuickBase Community, I am developing an inventory management application in QuickBase and facing challenges in showing inventory levels across various warehouse locations and vehicles. Despite having set up a Transactions join table and establishing relationships to track movements, I feel there might be more efficient ways to structure this application. Current App Structure: Tables: Items, Boxes, Bins, Pallets, Locations, and Transactions. Transactions Table: Acts as a join table, connected twice to Locations (once as "To Location" and once as "From Location"). I use this to manage and track inventory movement. Summary Fields: Created to add and deduct quantities from locations based on transactions, but I'm struggling to get a comprehensive view of inventory levels, especially in the Bins table. Key Challenges: Bin Count Visibility: Despite setting up summary fields to reflect the total inventory within bins (including items directly in bins or within boxes), the
I need to calculate a couple of things for the cost of a resourceThe first year costs, but each "start date" is different. and the year end needs to be 12-31-[whatever year the start date year is].I have requested start date, # of months they're needed.So for instance if a resource is requested to start on April 1, 2024, and they're needed for 60 months, and they're monthly costs are $1,000What is the end date, if they start on April 1st and are needed for 60 days?What is the cost for that first year if they start on April 1st and go to the end of the year (of whatever their start year was)Thanks!I also need a formula for ------------------------------Renee Hansen------------------------------
Hi all, I wanted to know if it is possible to share permissions of the feature "Impersonate User - Test as another user". I need my operations manager to see our app as other users see it in order to understand how the different people interact to it. ------------------------------Francisco Ojeda------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.