Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello,I have a question pertaining to pipelines and the sum function within jinja2.I have created a pipeline:Step A: searching through records on table 1 for each A do:Step B: Look Up a Record on table 2 where the Query is [key field table 2] equals [a.key field table 1]Step C: Update Record*for step C I am trying to update a numeric field on table 2 which is a sum of [a.paid_amount] from table 1 where the [key field table 2] equals [a.key field table 1]. I have tried putting the following in Step C for the field that is to showcase the summed value:{% set total = namespace(value=0) %}{% for r in a %}{% set total.value = total.value +(r.paid_amount|default(0, true)) %}{% endfor %}{{ total.value }}and {{ a|sum(attribute='paid_amount') }}I keep getting this error however: Validation error: Incorrect template "{{ a|sum(attribute='paid_amount') }}". TypeError: 'Record' object is not iterable Any recommendations of any kind would be greatly appreciated. Thank you-----------------------
Hi Quickbase community, On the forms within my apps I have an attachment field. The users that work at customer locations are completing these forms and attaching attachments on their iPhones or iPads. These attachments can easily be viewed on the desktop version after the form has been completed but the users who use the mobile app are not able to view these attachments or delete them after submitting them. How do we go about this issue?------------------------------Landon Wyrick------------------------------
Anyone have a work around to get the Max time from a child record? Maximum Summary field does not work on times, only numbers and dates. There must be a work around I am not thinking of? Maybe convert the time to a 24 hour clock, and then to a number? Then max the number and convert back?------------------------------Mike Tamoush------------------------------
Hey experts,I am trying to use the value of a field (Date/Time or Date field) in a Pipeline to be sent to a webhook. I need to output an ISO date but can't figure out how to convert it to the right format.Currently I'm getting: 2023-01-16 15:59:19.671000+00:00I need: 2023-01-16T15:59:19.671ZIs there a Jinja function or something I can use to make this conversion? ------------------------------Jeremy LahnersLeadBaller------------------------------
Hi,I have a code page where users can input their information and it goes directly into QuickBase in Javascript and HTML. Our clients were wondering if a prompt could be given to users if they entered in a zip code that is not in their service area - like the Zip Code is not found in their LIST. Here is what I have so far but it is not working. As can be seen below, the fid is 16 of the field users input their zip code into. Zip Code is my LIST the client gave me (I gave a couple examples). I believe the OnChange is not working and instead should be OnInput? I would like the promp to ideally happen oninput instead since its a input field. For reference zip field (fid 16) would be what the user inputs. Otherwise is ther another way to get the user's input, check if its included in a LIST, and if not have text or a Pop up or Alert?:<script lang="javascript">function CheckForZip{var zipcode = [94602,95616]var inputzip = "<field fid=
Hello -I have two tables - Projects and Employees. Employees holds employee information like our internal employee ID, email, name, department, etc. I have several relationships built between the tables to allow users to lookup an employee and pull in related information to that employee (One Employee can have many Projects).I have been asked to create report that pulls in employee information on the Record Owner in projects table. I am not sure how to accomplish this given no one would be "looking up" the value but instead I need to somehow pass the data from the Record Owner field to the reference field in the relationship.I've created a formula field that returns the internal ID from the Record Owner user field. What is the best way to pass that value to the reference field in the relationship to then lookup related information like department?------------------------------Thanks in advance,Jennifer Paschal------------------------------
I have a commission field that is calculated. My boss wants to be able to change the amount. How can I copy the values in that field into a field that can be edited?Thanks,Lori------------------------------Lori Pelzel------------------------------
I have a "paid date" field that I have converted to text field in order to use a formula to display the paid date in a using 2 different formula fields (for options to group/filter the report)I need to highlight the fields that are blank in both reports. I am using the Case function in both fields and I think I need to add If-then as well? Any ideas how to get this to work? ------------------------------Kelly Lyons------------------------------
Hi - I have a form with multiple sections. I would like to make one of the sections read-only if a condition is met. Other than make every field read-only (which I'm trying to avoid b/c there are 100 fields in this section) is there a way to make the section read-only?Thanks!------------------------------Scott Cote------------------------------
Hello,I want to create a text field that would auto-format a number entered in an open to the public app to include dashes in the correct locations. I need a dash after the first two numbers and before the last two numbers when the middle section can vary from one number to four numbers. User input 12345678 changes to 12-3456-78User input 12649 changes to 12-6-49Any suggestions?------------------------------Rhonda Jones------------------------------
Hi All,We've set up a pipeline to our email to find a file. We're able to find the file in the pipeline, but when we try to import the CSV into our QB application, we get the following error:Validation error: Incorrect template "{{a.file_transfer_handle}}". ValueError: invalid literal for int() with base 10: 'file_transfer_handle'Can anyone please give insight on what we need to change to resolve this?Thank you!------------------------------VW------------------------------
Hello Quick Base Community,I would like to know what is the time limit to migrate automations to pipelines.I appreciate the help!------------------------------Kevin Portuguez------------------------------
Use Case: Dynamic Form Rule populates user and date fields when a condition changes from False to True. Dynamic Form rule option is checked to Fire the Change only when the condition changes from false to true. The condition that fires the change is selection in a multiple choice drop down being changed from blank to a choice. This works well for an existing record Problem Statement (1): When creating a new record, the user and date fields are automatically populated even though the condition is False. Problem Statement (2): If the multiple choice condition is set back to blank, how to remove the data that was automatically populated to the user and date fields.------------------------------Annetta Coleman------------------------------
Hello,Novice API user, Pipelines only has access to Quickbase Channel.I have 3 tables that began as copies of an original table. 250 fields each. Over time they have been modified and are now slightly different from each other. I have been asked to review the Field Help Text Values of the fields that are named the same across all 3 tables. I am trying to pull the Field Name and Field Help Text into a CSV for the purposes of comparing values.Any guidance would be greatly appreciated.------------------------------Nick Bellows------------------------------
For my pipeline file output name I'm trying to format an output report filename field based on a specific date in Jinja2. Based on that date the naming convention should include which quarter the data contains. ex. Report Date = 12/31/22Desired outputfile name = Report_(#QYY)_<MM-DD-YYYY> eg. Report_Q422_01-10-2022How can I manipulate the date to return a number for the quarter ?------------------------------Jerome Mitchell------------------------------
I regularly use little API URL formula buttons like this one.var text $CopyStatustoPreviousStatus = blah blah blah ......; $CopyStatustoPreviousStatus& "&rdr=" & URLEncode($ReDisplayReport)That works well when I have a button dedicated to either refreshing the record I am sitting on or refreshing a particular report.I also use this great technique a lot to not refresh the report (so the user does not lose their place in the report or does not lose their Dynamic filter selections.var text URL= blah blah blah ....;"javascript:" &"$.get('" & $URL & "',function(){" &"$.jGrowl('email Triggered to Prospect', {life: 5000});" &"});" &"void(0);"But I would love to know how to make a button which will do some blah blah blah stuff and then refresh the screen - that way I could have the same button be used on any report and any record. Ideally it would reload the screen and preserve the user's Dynamic filter selections if they were on a report. If there a way t
I have a table called Outsourcing and a related table called Invoices. The Invoices table just has a date and $ amount listed in the table as a history on the Outsourcing record.I have 2 fields in Outsourcing named Last Date Invoiced and Last Amount Invoiced that are currently just manually entered data. No relation to the Invoice table fields.I would like the Last Date Invoiced and Last Amount Invoiced fields in Outsourcing to contain the date and amount of the most recent record in the Invoices table so we don't need to update this information in 2 places.We are very basic Quickbase users and I have no idea how to make this happen. I have written very basic formulas, but just don't know where to even start on this.Any information would be greatly appreciated. Thank you.------------------------------Kathy ------------------------------
Good Afternoon,I have a made a query summary metrics table that summarizes projects submitted per month and costs per month. Then the table also has a YTD field..Based on Quickbase Junkie's Easy Metrics Table using Formula Queries youtube video. This is working great, but I would like to have a Fiscal YTD calculated (Sept. 1) instead of calendar YTD. I have changed the fiscal year date in the App settings. I was curious how to reference Fiscal Year (In place of FirstDayofYear ) in the query or how to change my formula to run from Sept. 1-Aug. 31Thank you!Here is my current YTD query formula that is working:var text QUERY = "{1.OAF.'" & FirstDayOfYear([Month]) & "'}AND{1.OBF.'" & LastDayOfMonth([Month]) & "'}";SumValues(GetRecords($QUERY,"*******"),8)------------------------------Michael Peoples------------------------------
Is it possible to summarize the values of two fields in a summary report? I've got these two fields "Origin Airport Code" & "Destination Airport Code" that I'd like to summarize in one report.Thanks in advance for any help!------------------------------Khalid Daoud------------------------------
I have a CSV Pipeline that is only importing the first column in the CSV. Suggestions?------------------------------Paul Peterson------------------------------
I would like to access information about my pipeline inside the pipeline's steps. For example, I want a Pipeline to populate a field using the Pipeline ID so that I can trace a result back to source more easily. What is the syntax for accessing a Pipeline's attributes? I've tried the following to no avail:{{pipeline_id}} {{id}}{{this.pipeline_id}}{{this.id}}{{.pipeline_id}}{{.id}}------------------------------John Erdmann------------------------------
Hi,Is there a way to create a bar chart that compares values across multiple fields?For example:Y Axis - I want to basically count total entriesX Axis - I want to show the values / counts from 4 different checkmark fields (so simple Yes/No values). It would be even greater if the chart allowed for grouping.However, in spite of this help article (Quickbase Help) saying you can have multiple fields for the Y access, I don't see the option to add additional fields anywhere I hover on either the Y or X access fields.Suggestions?Thank you!------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------
Hi,I have a code page where users can input their information and it goes directly into QuickBase in Javascript and HTML. Our clients were wondering if a prompt could be given to users if they entered in a non-valid zip code. Here is what I have so far but it is not working. As can be seen below, the fid is 16 of the field users input their zip code into. Zip Code is my list the client gave me (well a couple examples). Is it the OnChange that is not working (On the Form:)? I would like the promp to ideally happen oninput instead since its a input field. For reference inputzip would be what the user inputs. That could also be incorrect possibly and there's another way to get the user's input:<script lang="javascript">function CheckForZip{var zipcode = [94602,95616]var inputzip = "<field fid='16'>" + $("input[name=_fid_16]").val() + "</field>";if (zipcode.includes(inputzip)) {alert ('yes');}}On the form:<tr><td st
Hello, looking to crowd source some best practices for importing and standardizing addresses in Quickbase. I know QB uses MapBox but they have some odd formatting practices. For example, they spell out pre-directionals and don't follow common address formatting that we all familiar to: USPS and Google Maps.I have a lot of existing addresses that I would like to import, not all are in the best condition. The address needs to serve has a unique field since multiple records & tables will relate to an address. My users will also be entering new addresses so I want to avoid the following which would cause several different address records even though they are the same.123 N Main St123 North Main St123 N Main StreetThanks!------------------------------David Semitekol------------------------------
Hello Quickbase Comunnity!Is there a way to modify or eliminate this logo and email in notifications?Thank you very much. Regards, Herberth Solano Vargas. ------------------------------Herberth Solano------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.