Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have two tables that represent a parent-child relationship. Each row in the child table contains a "parent_id" column that relates it to the parent table. I'd like to create a report that (for a specific child) shows other rows that have the same "parent_id". I thought that I would create a self-join relationship on the child table but I can only do that using the child table's key field. I'd like to do it on "parent_id" instead. Is there a different pattern I can use to show these "sibling" rows (rows with the same "parent_id")?------------------------------Sean Carpenter------------------------------
QB technical support has indicated that I am experiencing problems creating pipelines that involve one of my tables because I have too many formula lookup and summary fields in the table. I cannot save a pipeline when this table is involved anymore. I experience an internal error when building any step in a new pipeline or when updating an existing pipeline that includes this table. A pipeline for any other table is created or updated without a problem. Does anyone know if there is a tool that identifies fields that are causing this problem beyond just the built in "Usage" functionality. I have 854 fields in the table of which 295 are formula fields and 254 are Relationship fields. The app with this table has been in production since 2018. Is my only recourse to go thru each of the 549 fields to determine if they are needed. My guess is that most of the 549 fields are being used in some capacity. A tool to speed up this analysis would be great.------------------------------George Bramh
Good afternoon all... We have created a new a new app that populates data from another app via quickbase actions. What I am having difficulty with is showing a thumbnail from an attachment in the 'parent app'. In the original app the thumb is show by use of "<img width=\"150\" src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e12/v0\" />" I understand that I can send the record ID from the parent app to the new app, but can't seem to get the formula correct in the new app.... Any assistance appreciated. ------------------------------damien page------------------------------
I was tasked with creating a chart with the following information. How would you recommend displaying this in one chart? Is it possible? Show profit/revenue assigned to any Account Manager over time (how does their profit and revenue compare to 6 months ago?) Show total number of Client records they are assigned to (how does this compare over same period of time) Show total number of products they are assigned to that are paused/cancelled (how well do they retain clients) Topology Parent: Clients table (contains Assigned AM field, status=active) - Child: Products table (contains current profit, current revenue, current # of products, status=paused or cancelled) - Child: Products History table (contains historical info (same fields as Products table) ------------------------------Matt Makris------------------------------
I have a set of tasks where I have a start date, end date, calculated duration in months, and total labor cost for each task. A task can be years long. Labor costs are linearly prorated across the task duration. My goal is to be able to chart total labor costs for each month. I could create a dedicated field for each month, but that scales up quickly to a lot of fields if tasks run across a long time duration like 15 years.I'm thinking instead that each month's labor cost has to be written to a record in a table. I know how to do that. My challenge is how to iterate through a task's duration to calculate a given month's labor costs, since in theory the application would start in the month and year of the task start, calculate the labor cost, write a record to the table, then go to the next month, repeat the cycle, and so on until the task end month is reached. In standard code a loop like this would be easy, but I'm not clear how to do this in the Quick Base environment. I've seen that
Hi, Is anyone aware of a Jinja equivalent "Workday" function? I am working on scheduling start dates based on a start date and # of work days needed to complete. Thank you! {{ a.Start_field + time.delta(days=a.workdays)}} Or a day of the week function? i.e. if Saturday I can add 2 days if Sunday add 1 day? ------------------------------Christine White------------------------------
I am trying to have a URL Button to check a checkbox if that checkbox is empty and do nothing if it is already checked. I would also like this button to be pressed from an embedded report.Essentially, I have an Items table that is embedded into an estimate table. The items have the name, description, price and whether it is approved or not. The approved checkbox is unchecked until the customer decides they want to move forward with that line item so I need a button that can be pushed from the embedded report that will check the approved box and update the item
I want to: Hit original button (formula URL field), update field ID #7 to now(), open splash page (as a popup), close splash page (via splash page button), return/refresh original page. Everything works except auto-refreshing the original page once the splash page/popup closes. I've tried conducting these activities in several different orders without success. Any help in getting me past that last hurdle will be appreciated......Aaron ------------------------------------------------- Formula URL for the initiating button: var text SplashPage = URLRoot() & "db/" & Dbid() & "?a=dbpage&pageID=12";var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl(); URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=<token>&rid=" &[Record ID#] & "&_fid_7=" & Now() & "&rdr=" & URLEncode($SplashPage)& "&rdr="&URLEncode($RefreshPage) --
I was wondering everyone else's experience with the new forms. There is so much I love about them, but I am encountering a lot of issues. Lots of navigation/return 'weirdness', some unconventional auto saving, report link bugs, etc. Are others having the same experience? I can't decide if I can even implement the form as it is quite quirky.... Maybe I just need more time with it, but I am curious others thoughts.------------------------------Mike Tamoush------------------------------
Hi! I want to be able to track status' for orders, arrivals, updates of orders as they change. This is how I have things set up right now: I didn't only want to have the input on the right because if I need to export and start things over again I figured that'd be more difficult. Is there anyway to basically be able to select one dropdown but have the historical data shown automatically like I have on the right? Any insight would be much appreciated! ------------------------------Annie Ryden------------------------------
I have a pipeline that is triggered when a record is added in a table. In the pipeline I am then using the outlook channel to send an email to the email address listed in the record (non quickbase user). In the email is it possible to include voting buttons of yes or no and then track that response in a table within quickbase ?------------------------------Lavina Pinto------------------------------
I want to trigger a pipeline 3 months after a record is created. I have a formula checkbox that looks to see if today() is 3 months after record is created & if it is, it gets checked; but I'm not sure if the pipeline will actually trigger off of that changing. I've seen discussion posts saying it won't, only when the record is actually edited. Does anyone have an idea for how to trigger this? ------------------------------Harrison Smith------------------------------
I am building an app for our Insurance team and they have A LOT of special requirements and "one-off" calculations. I am trying to help streamline some of these to potentially make things more consistent and easy to process. We own/manage a large real estate portfolio which may be covered on one or more insurance policies. For each of these policies our various properties, and their individual units, are described and valuated on an excel workbook. If a property/unit is on more than 1 policy it will appear in multiple workbooks. In an attempt to help streamline and de-duplicate data, I am building an app that has the following tables: Properties - Parent to Units and describes the entire property. Units - Child to Properties and describes individual units or buildings on the Property. Property Values - Parent to Unit Values and stores value fields that apply to all Units. Unit Values - Child to Property Values and stores value fields specific to that unit/buildi
Can anyone council me if it is possible to create a report formula to count and display the row number in a report? (I know Quickbase counts the number of records in a report, but can this counter be accessed?) ------------------------------Jeff Rogerson------------------------------
I'm trying to create a formula that will read 6 different numeric fields and then decide which field to populate as a results. If Numeric field 6 is empty, populate Number field 5 If Numeric field 5 is empty, populate Numeric field 4 If Numeric field 4 is empty, populate Numeric field 3, If Numeric field 3 is empty, populate Numeric field 2, If Numeric field 2 is empty, populate Numeric field 1 At minimum, Numeric field 1 will always have a value. Any help you can provide is greatly appreciated. I've tried many things and nothing is working. Thanks Sheila Allas------------------------------Sheila Allas------------------------------
I have a list of names in a Multi-Select Text field that I would like to convert to a User-List. Is there a formula that will do this for me? If not any other ideas?------------------------------George Bramhall------------------------------
I have a summary field that when printed I would like a different label. I think I have to do this in the formula but i don't know how to do it.------------------------------Lori Pelzel------------------------------
I found some posts similar to this regarding reports but none for Pipelines so here is my situation. I've also run the Performance Analyzer, Performance Insights, and Performance Optimizer but not have provided any advice other than "optimize your query". When running pipelines, I get 3 outcomes: Success without issue, Success with Heavy Traffic notifications, Failure due to the Formula Query Execution taking too long. This happens on the exact same table, using the exact same pipeline (no differences between runs). Success without issue happens on the weekends or middle of the night. Heavy Traffic notifications seems to be hit or miss during the day on weekdays. Failure due to Formula Query Execution happens during the weekdays during typical office hours. Based on these scenerios, I am guessing it is a Quickbase "resource availability" issue???? The table is ~ 4000 records with 57 fields. Below is the Pipeline activity output for one of the failures. So
Hi all, I am utilizing Python to pull data from QuickBase. However, every time I try to pull a summary field or summary report I get errors that they are not in the index. If anyone can point me in the right direction I would appreciate it. Thank you!------------------------------Stephanie Balarezo------------------------------
Hello Quickbase gurus, We have a scenario where we are integrating with Salesforce. We need to do some data transformation eg. if value of field is coming as 'ABC' then I would like to store 'XYZ' in quickbase. Is there a way to achieve the same ? Any pointers will be greatly appreciated. Regards, Avinash------------------------------Avinash Kumar------------------------------
It appears that you have added a new option to be able to hide the "My Apps" and "New Apps" tabs (by going to the Settings-->Branding-->Hide Quickbase Standard Menu Options. However, it also hides the Personal Settings button (where you changed your personal profile settings, and were able to switch to another role). Is there a way to get those personal settings/switch to another role option back, while also hiding the Standard Menu Options?
I am building a recipe database and need some help, I'm trying to get the related material components to show on the formula components. The table structure is below. The CAS Numbers are a list of items.Materials are added before the formula is raised and have multiple material components. When the formula is populated with formula components I want the related material components to show in a report on the same form. The formula shows the formula components as below I would like to do this with relationships if possible due to them being more reliable. ------------------------------Allan McPhail------------------------------
I have a link to an add form that is sent to users (everyone on internet) to add records only, however, the homepage is still visible which if selected takes the user to another unrelated page that is also public. Am I able to hide the home button somehow?------------------------------Phelan Sanders------------------------------
I want to limit the size of files my users can upload to an app? is there a native way to do this? and is there a way to retrieve the file size for existing files?
Hello, I have position field that is based on a selection in my department field. I'm running into an issue with the display of my position field. When I click on Department, the list of positions for that department show, however, when I select the position name, the value displays blank. This is only happening for certain positions. I've tested and around 80% of the position names show when selected and the others do not. I've attached a few screenshots. ------------------------------Erika Brown------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.