Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a multiple choice field which has three options X, Y,ZI am working on creating a formula field for the dashboard.The logic is (if it is Y, then Y and if it is X,Z then sum(X,Z) and if it is X,Y,Z, then sum of (X,Y,Z))Can it be possible to be created in qb natively?Thanks------------------------------XYZXYZ------------------------------
Hello,I am working in Pipelines and am trying to send request to Azure Active Directory in order to receive an access token to be used to ping a secure third party API. I have tried multiple methods but each comes back with problems. When I try to use the Auth section of the webhook it says I'm missing the "client_secret". When I try to make the auth call its own web hook it doesn't see the "grant_type" in the body.Has anyone done something like this? If so how? Or is there some documentation somewhere to go off?------------------------------Jake Williams------------------------------
In case it helps someone to save a couple of hours solving this error, when you try to send a json array using jinja in pipelines.Error:Something went wrong executing a step. Try modifying your pipeline.Body:{"payments":[{% for r in a%}{"value":"{{r.vto}}"},{% endfor %}]}Valid:{"payments":[{% for r in a%}{"value":"{{r.vto}}"}{% if not loop.last %},{% endif %}{% endfor %}]}Reference: https://rogerpence.dev/omitting-the-last-comma-in-a-series-in-a-jinja-template/------------------------------Diretoria Mirantes------------------------------
Hi all - I'm trying to create a changelog that shows timestamps when a record's status has changed (i.e. pending, in progress, completed, etc.) I was able to create timestamps for all the different statuses that seem to work correctly. The issue is with the changelog where I'm trying to log and show not only the time/date the status was changed, but also the user who changed it. I created 2 fields:1) Track Changes: This is a simple text formula like: "Status="&[Status]2) Changelog: A text field to capture the changes (field setting are also checked to capture the user who made the change)I have form rules that update the timestamp fields as the status' are changed, and one last one that basically says when the record is saved to copy Track Changes into the Changelog field.So it almost works, the changelog tracks the time/date, user and status - however the status seems to be a save behind. For instance if the status was Pending and a I chan
I have a child table with data in different years. I have a field called Total Dollars that totals the cash by year. I'd like to have a Running total of the cash each year. How do I do that?------------------------------Mike McCartney------------------------------
I swear I saw an email a month or so ago saying that we no longer need to switch our automations to Pipelines by Jan 1, 2023. There is no current date but they will give us 6 months notice.I cannot find that email now, and want to be sure I saw that correctly. Can anyone confirm?------------------------------Mike Tamoush------------------------------
Is there a way to take the total of multiple entries like it shows in the report and get those to export to excel or into another report. The break down is an expense report is created, within this report are multiple weeks, each week has its own weekly total. I want to then get the total of all weeks for that expense report only. Full Report Grid Edit Email More 3 Expense Report Week records Employee Name Week Date Month Location HotelExpenses Per Diem Flat Rate Mileage Mileage CostTotal(Dollars) Mileage CostTotal 2 Mileage CostTotal 3 Toll Misc Cost Misc Comments DailyTotal Weekly TotalPay back Reviewed Reviewed on: Reviewed by: WeeklyTotal Knecht, MS, ACSM-CEP, Rebecca 1 11-14-2022 November 2022 Palm Coast $70.00 50 $20.47 $0.585 $8.77 $2.20 $92.67 $263.68 $263.68 Knecht, MS, ACSM-CEP, Rebecca
I was wondering if it is possible to have two tables, which have similarly purposed fields, be combined into one single flowing report?Example: I have a Jobs table which has a number of fields whose purpose are the following: Item, Price, Adjusted Price, Updated Price, Qty, and Final Price. They may not be labeled those names exactly but the above names give the purpose of the field. I have a Secondary Costs table which has a number of fields whose purpose are the following: Item, Price, Adjusted Price, Updated Price, Qty, and Final Price. They may not be labeled those names exactly but the above names give the purpose of the field. I already have a Many-to-Many relationship built with with Work Orders in the middle.Also, Jobs is already setup with Secondary Costs directly.The relationships are as follow:Jobs > Work Orders < Secondary CostsJobs < Secondary CostsCurrently I have a report builtin the Jobs table, placed in the Work Orders form to show all the jobs and ass
TIL , PS : I'm aware you can use loop.index but there was scenario involving where I couldn't . You cannot use a simple counter variables inside ninja loops. Case in Point{% set x = 0 %}Counter Value before loop {{x}}{% for myloop in range(6) %}{% x=x+1 %}{%end for%}Counter Value after loop {{x}} You would expect the output to be Counter value before loop 012345Counter value after loop 5Instead what we get it is Counter value before loop 0111111Counter value after loop 0Everything inside loop gets a fresh value of our counter X in case---After some painful searching I stumbled upon a Ninja function called namespace for solving exactly the same issue{% set x = namespace(value=0) %}Counter Value before loop {{x}}{% for myloop in range(6) %}{% x.value=x.value+1 %}{%end for%}Counter Value after loop {{x}} Now the output isCounter value before loop 012345Counter value after loop 5------------------------------Prashant Maheshwari---------------------------
Current User in Formula Query
Hi everyone,Just finished building a new tool for my team, integrating reporting to contacts tables to allow staff to look up contact records rather than repeatedly inputting the same data.However, our contacts table uses email addresses as the record ID. When it was established, it made a lot of sense to do that to prevent duplicate entries, among other things. We were only using that table to send emails once a month, and if we didn't know an email address, then that contact wasn't added to that table.I've now been asked - what happens if we don't have an email address (the newest system requires the input of an email address). My thought is to create a way for an automatic 'fake' email address to be created based on the community of interaction + '@noemail.com' or something to that effect to populate the field; but if the box is unchecked - to allow for regular entry of an email address.So - I wanted to see if this were possible:Have a checkbox - you tick if
Is it possible to compare two fields as a condition for a pipeline action? For example:When record is updated; trigger on field A, condition: Field A>Field BIt looks like I can only make a condition such as Field > 0, or some set value?My work around is to then search records in the same table as the action, where the record ID matches and then set my condition.Is this the only way?------------------------------Mike Tamoush------------------------------
This took me some time to achieve You can use Time.delta in Jinja to adjust hours ,weeks , months or even years. I had a case to create an auto reminder after 3 months after the date was created (ofcourse we could use a simple formula field but where's the fun){{((time.now|timezone('Asia/Calcutta'))+ time.delta(months=3)).strftime('%Y-%m-%d')}} Replace TimeZone with your time zone ------------------------------Prashant Maheshwari------------------------------
I am trying to figure out a formula for duration. my problem is that one set of date is Date/Time, while the other is only Date. QC Date - Date/TimeStart Date - DateThe QC Date pulls from a relationship, so I don't think I can simply change the QC Date to "date" only because of the relationship. However, what I am trying to do is determine only the number of days between the two and exclude the "time" portion, if possible. I thought i was close with this formula, but it does not like the subtraction.DAYOFYEAR(TODATE([QC DATE CREATED]))-[DESIGN START DATE]) All i need it to do is pull the date and ignore the time stamp - QC date 11/22 - start date 11/20 = 2 days. Is this possible? I looked at other formula functions as well, but to no luck so far.Thanks!------------------------------Bret Osborne------------------------------
I'm about done on my first build using Quickbase, I'm looking for something similar to a sumif function where I can summarize a sequence of number fields on a record where I only want to add up numbers greater than zero.There is a sum function and I tried the following without any luck. sum(if([Change Stucco Price]>0,[Change Stone Price]>0,[Change Lap Price]>0,[Change B&B Price]>0,[Change Shake Price]>0,[Change Shutter Price]>0,[Change Corbel Price]>0,[Change Soffit Total Price]>0,[Change Gutter Price]>0,[Change Plaster Foundation Price]>0,([Change Stucco Price]+[Change Stone Price]+[Change Lap Price]+[Change B&B Price]+[Change Shake Price]+[Change Shutter Price]+[Change Corbel Price]+[Change Soffit Total Price]+[Change Gutter Price]+[Change Plaster Foundation Price]),0))I know that this formula doesn't work, but figured I would put it here to give an idea of what I'm looking to accomplish.Any help is appreciated.------------------------
Getting fields from other tables & insert into one formI have five images (1-5) and also a part of a relationship diagram showing the three tables the data comes from.HREmployees are the workers who are assigned hardware (Software will be next to do, but for now just hardware.) The first image is an Assignment chart that is on the form. The one employee has two assignment pieces of hardware. BUT only one has a serial number, so the second piece of hardware will be blank. So the actual hardware for the serial number is (AHL-LAP-2433 - Laptop - Hewlett-Packard HP - ProBook 445 14 inch G9 Notebook PC - Win 11 Pro x64) Image 2 are the four fields that make up the HardwareDetail field I created, a formula text and is the Hewlett-Packard HP.Image 3 is the HR employee that the Hewlett-Packard HP is assigned to.Image 4 shows the serial number for the Hewlett Packard HP. Note the HR Employee has two assignement hardware records, but there is no physical hardware for her seco
Hi Is there a formula that removes the brackets from a phone number when a csv is exported from Quickbase? Other than changing the field to numeric------------------------------Jessica Matenga------------------------------
One of our apps is used by our sales team to track their daily activities so we have a calendar report on our dashboard with the initial view set to day. But the problem is that right now it's showing the first day of the current month and ideally we'd like to say the current day instead.Is there a way to set the initial view on a dashboard calendar report to default to the current day instead of just the first day of the current month?------------------------------Adam Bonny------------------------------
Hey everyone, I swear I've done this before but I can't for the life of me remember how I did it.I just need to filter the parent records in a drop down on a grid edit within a form. I have a parent record, Crew Time Record, and on the form for that record there is a grid edit to add multiple child records (Job Check Ins) and for each Job Check In there is a drop down selector to pick the related Job parent record. How do I filter the Job parent records that show up on that child record grid edit? Thank you!!------------------------------Elena Larrabee------------------------------
Hi Everyone,I need to add tooltip for column names so that users can hover over column for details. Is it doable? Thanks you!------------------------------Mrunali Kadam------------------------------
When adding an order item the user can select a profile from a dropdown. I have a scenario where I need to clear this selection for all items in the order. Using pipelines it won't allow me to set the dropdown to a null. What do I need to set the field value to be in order to effectly cancel any previous dropdown selections?thanks------------------------------Pete James------------------------------
Hi Everyone,I've added filters on the reports which shows up differently on different environments (copy/dev and prod version). Submission Status field -> Filter values: Proposal Submitted, Proposal ClosedIn 1st env. "Proposal Submitted" records show up 1st whereas in 2nd env. (production) "Proposal Closed" ones show up 1st. Users do not want to see closed records 1st. I'm not sure how does sort and group from low to high work for text. Please advice. Thank you!------------------------------Mrunali Kadam------------------------------
Hi,I have an App developed - and as part of the records created I want to capture the version number or unique identifier for the app. So going forward if calculations are changed I can identify during analysis when the App was updated.Is there a version number, unique identifier, modified that can be automatically captured for the overall App and saved as an element of a record.RgdsPatrick------------------------------Pat O'Neill------------------------------
When using a callable pipeline, does it return any data to the calling pipeline? If so, how do I access it? Later in the calling pipeline, I need RID for a record created in the called pipeline. I think I can store the new RID in another known record from within the called pipeline, and then grab it from there in the calling pipeline but that seems like an unnecessary hack.------------------------------Matt Hardy------------------------------
Hello,I am trying to create a form that a non user within my company fills out that will then create a record in an app I have in QuickBase. I made a Google Form and used Zapier. The new record was created but no fields had the data in them. I also attempted the EOTI, but that is just a little above my abilities/ knowledge. I have the HTML code but do not know where to go from there. I then tried pipelines... which these seems like it would be the easiest thing to achieve since I already have the Google Form, but I don't have the option to create a new pipeline. I would greatly appreciate assistance and some advice on which route is best and what I need to do to make this work. Thank you in advance!------------------------------Landon Wyrick------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.