Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Table 1 has a field called [Notify To] this is a user list (with the user's email address) multiple users can be selected in one record. This table allows to send email notifications to whoever is chosen in [Notify To] Table 2 is for when [Notify To] from Table 1 is out of office. Table 2 has a record for every user list from [Notify To] with a corresponding back up person to send emails when he/she is out of office, also this is the primary key used in Table 2. I have set up the logic when the user is out of office, the back up person will receive the notifications. How do I created a relationship between the two tables using the field [Notify To] if I have multiple users from a record in Table 1? The relationship only works when Table 1 only has 1 user selected. My problem is I cannot connect table 1 and table 2 when the records has 2 or more users selected. ------------------------------ammba------------------------------
I am trying to create a status column, based on a numeric field "Total number of sales'. We have 5 different catogires, within last 30 day. Try to based on total number of sales field (last 30 day totals are already pulled), assign a status from below. <!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}--> Champion 8+ Avid 6-7 Average 3-5 At Risk 1-2 Lapsed 0 ------------------------------Michael Stromberg------------------------------
hello, I have a form named installations that tracks equipment installed on utility poles by site name. e.g. serial number 123456 installed at site name B234 the serial number is a lookup to an equipment table. I have a sub-form / table called service that tracks the number of visits to a utility pole associated to the site name. service has only a few options. audit, troubleshooting, repair request and remove and replace. when choosing remove and replace, i would like the sub form to show the currently installed serial number and provide a lookup to the equipment table for a new serial number. when a new serial number is entered, I'd like to have the old serial number remain in the sub-from / table and have the newly entered serial number populate the installation form/ table with the new serial number... can this be done? thx -N ------------------------------Nic M------------------------------
I'm getting an error on a pipeline. Any idea how to resolve this and what the specific issue is? Validation error: Incorrect template "The AP Program has changed from <b style='color:#f00;'>{{a.$prev.seo_program_name}}</b> ({{"${:,.2f}".format(a.$prev.quickbooks_invoice_grand_total)}}) to <b style='color:#00691c;'>{{a.seo_program_name}}</b> ({{"${:,.2f}".format(a.quickbooks_invoice_grand_total)}}). This is a cost difference of {{"${:,.2f}".format(a.quickbooks_invoice_grand_total-a.$prev.quickbooks_invoice_grand_total)}} ({{'%0.1f'| format(((a.quickbooks_invoice_grand_total-a.$prev.quickbooks_invoice_grand_total)/a.$prev.quickbooks_invoice_grand_total)*100|float)}}%)". ValueError: Unknown format code 'f' for object of type 'str'------------------------------Matt Makris------------------------------
Is there a way to set the sorting of the grouped columns in a Summary report? I'd like to display the left-most week column to the most recent date in the dataset. Am I missing something here? ------------------------------Matt Makris------------------------------
I guess I need Gauge Chart / Dashboard KPI 101 course.... I mostly use gauge charts to COUNT occurrences of something so that I can then display the occurrences as a KPI on a dashboard. By nature gauge charts are intended to sum or average data. I have been successful thus far in 'summing' some not numeric field so have been clubbing along well enough after I learned early on that summing a numeric Record ID can result in a very large number. LOLIn any case, I thought I would ask about the proper way to count records for the purpose of displaying as a KPI on a dashboard.------------------------------Annetta Coleman------------------------------
Hi all, I'm looking for a way to extract text from the middle of a text field where there's a match to data in another field. As an example say I have a record with a field for Tax Year Ending which will be 4 digits i.e. 2021 or 2022 etc. I need to use that field to find matches in another field which will have an ID number followed by a / and then a tax year, but it can have more than one of these. For example if this other field (let's call it Summary) contains the following: "16/2023 ; 9/2022" And the Tax Year Ending in the record is 2022, I need another field to extract "9" from the Summary. If the Tax Year Ending was 2023 then it would need to extract "16" from the Summary. If it's easier to do then it could extract "9/2022" or "16/2023" respectively but it would be cleaner to skip that step if possible. Many Thanks, Joe ------------------------------Joe Alderson------------------------------
let ( start = ToDate([Start Date]), end = ToDate([End Date]), onHoldStart = ToDate([On Hold Start Date]), onHoldEnd = ToDate([On Hold Stop Date]), duration = If( Not(IsNull(start)) and Not(IsNull(end)) and Not(IsNull(onHoldStart)) and Not(IsNull(onHoldEnd)), WeekdaySub(end, start) - WeekdaySub(onHoldEnd, onHoldStart), 0 ), durationInDays = ToDays(duration), durationInHours = ToInt(Duration(0, 0, durationInDays).ToHours()), durationInMinutes = ToInt(Duration(0, 0, durationInDays).ToMinutes())); durationInHours & " hours " & durationInMinutes & " minutes" I'm getting error please see attached screenshot Note: output field type is duration ------------------------------manohar vankireddy------------------------------
I am trying to create a query that searches a table for matching [Order] (fid 8) and then sums the field [Total Amount Claimed] (fid 250) from the found results. I haven't been able to get anything to work and wonder if it is because neither are manual entry fields. Order is rich text formula field and Total Amount Claimed is a formula currency field. Any help would be appreciated. ------------------------------Rhonda Jones------------------------------
For executive reporting we would like to show KPI # values on Dashboards using a Gauge Chart to represent # of review items completed and another KPI to show review items left to complete. In this use case there are many times when the Gauge Report should report a zero. Example: # of review items left to complete should be zero if all reviews are completeExample: Both Review Items Completed and Review Items left to complete would be zero if there are No Review Items on the Agenda to Review. We are using filters to identify the data set. How do we get the Gauge Chart to represent zero? In the examples above we get a message "There aren't any matches for this report filter". Perhaps we should be using a report formula in addition to a filter?------------------------------Annetta Coleman------------------------------
Does anyone know if we can use the Key field to download files via URL or does it have to be the RID? I've tried below but no go, not sure if it has a special notation./a/r[Record ID#]/e24/v0 vs. /a/r10/k[key field]/v0------------------------------Greg------------------------------
Code Page Form to record on quickbase app
Good morning, In one of our pipelines we need to make a POST request to business central in order to get the access token needed to created a GET request. I'm having difficulties using jinja to filter my contents response to the just the access token itself to use for my second step. Could anyone help me regarding this? ------------------------------Christopher Angulo------------------------------
Hi - I have 13 roles and 16 tables. Since we have a couple of people making updates to our app, I want to download the details for each role (ie, Fields - details on modify, view, none for each field). Then I can do a "stare and compare" to make sure all of the fields are setup appropriately by role. This would be faster than me going through one-by-one each field or each role then field by table. Is there a way to do that? - thanks!------------------------------CARRIE IWASAKI------------------------------
Hoping this will be a quick question for someone who knows. I'm looking to create a single pipeline to trigger 10 others to limit manual effort. But I'm struggling to find information on this and want to vet it out before I spend the time constructing the solution. If I end my initiating pipeline with a callable action and match its variable to the callable first action of the 10 pipelines, will they all trigger? Thank you!------------------------------Curtis Middleton------------------------------
I am trying to create a button that will take me from a child table to view a parent table. This is what I have. URLRoot()&"db/" &[_DBID_GUARDIANS] &"?a=dr&rid=" & [Related Student] Im not sure if my flow has anything to do with it. Guardian to Student (related) Student to Services (related) from services I am trying to use to the button to get to the guardian. This button takes me to "guardian" just the wrong one. Have I missed a step? ------------------------------Cassie Hubble------------------------------
I have a formula checkbox that doesn't seem to work when adding more than one condition. I want it to be true when a duration field is less than 30 days and another multi-select text contains "In-Person". My formula is: If([Duration-Delivered - Created]<Days(30)& Contains([All Session Modalities Next Session Date NOT CANCELLED or DOWNSIZED],"In-Person"), true) The first one by itself works fine, If([Duration-Delivered - Created]<Days(30), true). However, when I add the second part the < highlights yellow and says the less than sign cannot be applied on types duration, text. Any assistance would be appreciated.------------------------------Dawn Rene------------------------------
I'm trying to query the embedded report in the extract form, but for some reason no data. Looking at the network when the print page loads shows these requests, which the last one might have some URL encoding issues: ~=qdb.GetURL("bgwh72y8f","API_GenResultsTable^query={'6'.EX.'"+field["Order #"]+"'}^clist=7.8.10.11.13.14.15.16.17.18.19.21&options=nvw.ned.phd.nfg");~ How to fix this ?------------------------------Ayoub Salhi------------------------------
Hi All, I am very new to QB and a user as posed a question. She says when she tries to edit her portfolio when working on it at home it only lets her "view only". How can I correct this for her or is it possibly a security measure set up by the employer? Thank you!------------------------------Jenn Beam------------------------------
Hello, Is anybody familiar with some strategies on how to sort data on a .csv created in pipelines?That is my current flow. If I need to provide further information, I am happy to do so. Thank you------------------------------Shane Miller------------------------------
I developed an "audit" application that works well for the most part, but there is a specific scenario I could use some help with. Each question is worth "x" points but when the question does not apply the user can enter "N/A" as a result. Quickbase is correctly ignoring these in my total point calculations but is also counting them as "0" and throwing things off when performing my weighted average adjustments in each category (in the screenshot Compliance questions are worth 40% of the total). I've been using summary formulas and it's easy when all questions are N/A (which is possible) to add all those points back in to my adjusted total. However, when there's a gap like what is shown in the screencap I can't find way to "skip" a question that has a legit answer (e.g. Fail) and needs points deducted. I don't know if this is solvable short of writing out every combination possible and adding those points back in, e.g. 1-2-3, 1-2-4, 1-3, etc.).------------------------------Nelson Arce--
I have a line chart that uses formula queries to show me total sales this year compared to last year and year prior. Basically 3 year growth chart. It is on a sales KPI dashboard page. I want to add a filter to this dashboard page to let us select major clients. All of this information is in quick base and I can get the filter to display the clients properly and majority of the reports filter perfectly. The line chart does not because the formula query is not connected to this dashboard filter. How would I do that?------------------------------Ivan Weiss------------------------------
I have a Formula that has multiple IF statement, but after the formula processes the first IF statement, it will not continue to the other IF statements. I have tried a "," after every IF statement and "&" after every IF statement, but that has not working. The Formula is looking at the output of a Multi-select Text field. Here is an example of my Formula. If(Contains([Field1],"Value 1"), ToText("|Value 1:") & " " & [Field 2],If(Contains([Field1],"Value 2"), ToText(" |Value 2:") & " " & [Field 3],If(Contains([Field1],"Value 3"), ToText(" |Value 3:") & " " & [Field 4,If(Contains([Field1],"Value 4"), ToText(" |Value 4") & " " & [Field 5))))What's happening is that if Field 1 outputs "Value 1" and Value 4 then only the First IF statement will ToText and not the Fourth IF statement as well. The desired output should be "|Value 1 Field 2 |Value 4 Field 5" ------------------------------Russell Hansen------------------------------
I have 4 date/time fields, I need to excluding weekends and Output fieldtype is Duration Formula is WeekdaySub(ToDate([Completed Date]),ToDate([Start Date])) - WeekdaySub(ToDate([On Hold Stop Date]),ToDate([On Hold Start Date]))------------------------------manohar vankireddy------------------------------
I am creating an annual evaluation form for my team and for the goals section so we could track those separately, I created a child table to track the goals. I brought over summary reports in the parent table for previous year goals and new goals. What I am struggling with is that next year the previous year rating will not save in let's say the 2023 eval for 2022 - it will auto change so for example if I Opened this form in 2024 - it would change the previous year rating to the 2023 instead of the 2022 it should be. Is there a better way to filter the report or bring over the rating for that previous year or the year before, besides just the previous year summary field. I thought about making a new field and the manager just typing in the rating so it is saved - but I was trying to see if it is possible to be automated and avoid people typing errors. Adding in a screenshot. thank you so much for your help in advance. ------------------------------Zana ---------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.