Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi All,I am working on a project where Project Manager wants to track our Customer Engineers in the field while traveling and can check the exact location and time when he is reaching to the Destination. Do we have any feature available in Quickbase like that?Thanks in Advance,Anjali Sharma------------------------------Anjali Sharma------------------------------
Hello,I have a table Inventory orders in which whenever a checkbox is checked the Quantity field in another table Parts should get reduced by 1. I have created a pipeline for this. The issue here is, when the records are grid edited in inventory orders, and if 2 records having same Part ID in inventory order are edited at a time, ideally the number in Quantity of Part table should get reduced by 2, but it is reducing by 1. The cause is both the triggers are at the same time and the pipeline triggers at a time for both the records. But the ask is, it should trigger one-by-one and the number should be reduced by 2.Thank you!------------------------------Aishwarya Jinde------------------------------
Hi,I am trying to find a way to send email notifications to clients with a BCC. I was told directly by Quickbase that this was possible, as long as the BCC was pre-set, but I cannot see any way to add a BCC.I know I can send to multiple email addresses, but we need it to BCC to an internal unmanned email for our internal mail server to pick the email up, read who it was sent to and then link it to that client on other software we use.Many thanks in advance.------------------------------Joe Alderson------------------------------
Can we put all QB code pages on one domain and call it from other domains by formula url/formula text field?Regards,Ravi------------------------------Ravi Shankar------------------------------
My company currently uses Google Numbers for us all to enter in financial data to track our expenses, percent of our revenue, and projections for the next year. We have to enter the data individually from Quickbooks. I KNOW there is a way for me to pull this information from Quickbooks into Quickbase automatically. I just can't seem to figure out how to put this together. I added a small snapshot of what it looks like.Thank you in advance!------------------------------Jennifer Meyer------------------------------
I am trying to use the audit log feature, and have marked certain fields to be tracked for audit purposes. Am I able to search that field, in particular, to if and when someone has changed it? Or can I only search by a user/app?------------------------------Mike Tamoush------------------------------
I created a rich text field to report out the status of a record. It appears that QuickBase provides a great library of icons for status - we would like to use the red/green/yellow circles as an example. However, for the color blind, it would be helpful if this also included an "R" in the middle of the red circle, a "Y" in the middle of the yellow circle, and a "G" in the middle of the Green circle.Is this something I can custom create? Or is this something that QuickBase can provide?Example of an already available Icon that could be more color blind friendly: ------------------------------Katelyn------------------------------
In this series, I meet with former Quickbase customers, discussing their experience with the Platform, solutions they created, and what they are up to now at Quickbase. Check out my chat with Christine Rosa below!
I have a button that when clicked changes a Date/Time field (57) to when the button was clicked. I am now getting a JavaScript warning when I open the properties window of the button field. How can I get this working again?Thanks,Brian------------------------------Brian Dunk------------------------------
I have a Search step that looks at all the child records for a parent. In that Search I am collecting a single Date Time Stamp Field.Then I am evaluating the field to get the max value using this Jinja Expression:{{a|max(attribute='child_table_date')}}It does work, picking the maximum value from all the fields in the child table. However I am getting much more than just a date time stamp.--- child_table_date: 2022-11-04 00:00:00+00:00 created_at: 2022-07-26 02:40:56.063000+00:00 id: 3 last_modified_by: email: DLarson@MCFIndustries.com first_name: Don id: 56472559.bjvz last_name: Larson screen_name: DLarson_MCF record_owner: email: DLarson@MCFIndustries.com first_name: Don id: 56472559.bjvz last_name: Larson screen_name: DLarson_MCF updated_at: 2022-11-17 04:10:31.507000+00:00 ...I hoped to only get2022-11-04 00:00:00+00:00which I would use for another stepSurely there is something missing from initial expression and it should not be providing everything else about the recor
I have a project reference field that the stakeholders would like to use their current reference number for. The reference number should not be generated when the record is created (so I can't use the record ID in the formula). The format of the reference is:BU-001-23"BU" never changes. "001" should be auto-incremented over the last number and start from 001 at the beginning of a new year. "23" is the current year. I would like to create a button called "Generate Project Reference" that, when clicked, will generate the reference and populate it in the Project Reference field. Once a Project Reference is assigned a Project record should not be deleted, only given the status "cancelled" if it doesn't go forward past that the point it gets a reference number. My understanding of formulas is still fairly basic. The main thing I'm stuck at is determining how to find the last number in the table to increment from. It seems creating a separate table
I am trying to finalize my set up to look at my companies profit and loss in live time broken down by employee and monthly, quarterly and annual numbers.I would like to compare data across multiple tables and also be able to organize it by date from each table. I am trying to avoid using "A summary of a specific field" with "matching criteria" set to during "Current Month" etc The reason I am trying to avoid this is because I want to see the date written: November 2022- $$$, December 2022- $$$,January 2023 $$$etcWe want to look back historically for productivity and if we use the above, we would need to set that summary field for every scenario and still would not be able to look at it all together as it is a moving target.The hardest time I am having is filtering the information up to the parent table with a date attached to it. Here is my current set up.Table: Employee (Parent Table)Employee Salary ExpensesAncillary Expenses Related to EmployeeEmployee Re
Is it possible to pass along a value in a redirect that can be used as a filter in the report I redirect to?For example, say I click a formula rich text button, and in it is a line like this:var text url = URLRoot() & "db/" & [_DBID_GROUP_IDS] & "?a=q&qid=7&_fid_7=" & $rid;Where _fid_7 is the [related parent id], and make that report filter on [related parent id] = _fid_7?------------------------------Christopher Greene------------------------------
I've built a customer contract form in Docusign and am trying to connect it via piplines. The only problem is, the numeric fields on my Docusign template don't appear as input fields on the pipeline.I converted the fields to text, and am able to input data, but then the calculation fields don't work.------------------------------Anne Martin------------------------------
Is it possible to have the same parent field multiple times with different inputs in one form? I was hoping to have multiple owners for a company, the way I imagined the form is to have separate dropdowns for owners.------------------------------frnmj------------------------------
I have an e‑mail notification that I can't get to work and I after a lot of testing and searching I am still unable to figure out why it isn't working.I have a "Projects" table. One of the fields is "Approvers" which is a lookup to a "Project Approvers" table. I had earlier tried using a user-type field, but had the same issues. The Project Approvers table uses a single-select user field as the key field.Other notifications DO work. The notification owner has access to the application and table (it has an admin role and access to everything)The e‑mail notification settings are:Permission type: Recipient (I also test with open pulling from the e‑mail lookup field of the Approver table, either way, doesn't work). Notification Name: Send Approval RequestNotify Whom: The user in the field: Related Project ApproverNotify When: a Project is modified or added AND when Any of the following fields change: Related Project Approver Message Type: Custom messageSu
Increased Visibility of Pipelines for App & Realm Admins If you’re wishing it were easier to see if someone else has built pipelines that are interacting with your Quickbase App, or simply wanting to know what pipelines other people have created, then you’ll be excited to hear about two of our newest features. In September 2022, we introduced a new view for app managers that provides visibility into any pipelines that are connecting to that app. We also rolled out a new way for realm admins to find comprehensive information about all the pipelines in their account. These new capabilities ensure that you’ll never have to be in the dark about anything that has the potential to affect you, your data, or your workflow. In-App Visibility Connection Central provides the agility and confidence for app admins to know which pipelines touch their apps, if any, whether they need to know so they can troubleshoot or work on integrations. Previously, app admins had no way of knowing which pipel
The native behavior of Save & Keep Working will save Both the edit made to embedded child records and whatever changes made in the form to the parent record. The code below Does Not do that. I found the below at: Alternatives to common JavaScript Insertion techniques var text rid = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%"); var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $rid; "<a class=\"Vibrant Primary SaveBeforeNavigating\" data-replaceRid=\"true\" href=\"" & $url & "\">Save & Keep Working - Rich Text</a>" My endeavor is to have a Custom Button behave the same way as the Native "Save & Keep Working" button. Save both parent and child record edits, redisplay in edit mode. Why a custom button? you may ask. Because the other options "Save & Close" and "Save & Next" I do not want to be available to the end user. Any assistance is appreciated. Thank you,CGreene-------
Is there a way to email the output for an exact form. Instead sending a hyperlink to the output via a notification.------------------------------Willis Taylor------------------------------
I am importing transaction data that includes the account holder name and want to limit the view in the table to only records corresponding to their user accounts. EG, QB user johnsmith@email.com can only see records with account name JOHN SMITH. Suggestions?------------------------------Tom Griffin------------------------------
Hi everyone,I have an IF statement that I would like to use to swap out a column for another column when a condition is met. The goal is to have this formula evaluate the condition for each row. For some reason, when just one record in the table meets the condition, the entire list of records is getting changed and not just the individual record. Anyone know why this could be?Here is my formula:If(IsNull([RecordID (Official) - Country_CCC_Pts]),[RecordID (Official) - Total_Points],[RecordID (Official) - Country_CCC_Pts])Essentially all this formula is doing is saying if RecordID (Official - Country_CCC_Pts is null, then use the total points column. Else use the Country_CCC_Pts columnAgain, I need this to only apply to the records that meet the condition, not the entire column all at once ------------------------------Spencer Chaffee------------------------------
Hi Quickbase Experts,Do you have these Apps -ABC GeoLocate Contacts (QuickBase GeoLocate Latitude and Longitude Example) & ABC GPS Requests Apps (Capturing Latitude and Longitude GPS with QuickBase)?Please feel free to share with me (anjalisharmaojha@gmail.com), if anyone have these Apps shown by Krik Trachy on Youtube.Thanks in Advance!!!------------------------------Anjali Sharma------------------------------
I have a table sorted in descending order by date. Records are automatically added to it by a Pipeline triggered by events (formerly via automation but it was migrated). I just recently discovered that it doesn't appear to be getting updated. However, when I did an import of the necessary records, it failed for duplicates. When I tried to manually add a record, it failed for the same reason. So, QuickBase thinks the records are in the table but I cannot see them no matter what I do. I have viewed the List All report, List Changes report, tried searching the List All report for a date that I know should exist, and I tried doing a custom report for all recent dates that I cannot see. Nothing shows up. Any input would be greatly appreciated. Thank you in advance to whomever can help.------------------------------James Carr------------------------------
Hello!Having an issue using a summary field to rank customers based on revenue. On our Customers table, the Total $ Shipped is a summary field, and I'm wondering if it's causing the problem I'm seeing in my formula query.Here's my formula:var text formulaquery = "{236.GT.'" & [Total $ Shipped] & "'}AND{236.XEX.'0'}";If([Total $ Shipped]=0,null,Size(GetRecords($formulaquery))+1)When I look at a report that sorts by this ranking, it has no number 1 record, and two number 2 records. The two records that are tied for number 2 do not match. They are off by almost 10,000. It then ranks 4, 5, 6, and 7 accurately (except for skipping number 3) and then has two number 8 and two number 10- which also are not equal to each other. I've read that it's best to use user input fields for formula queries because there's additional background calculations going in to summary fields, but it wasn't really made clear that it wouldn't work with summary fields. Any way to get this to work?-----------
So, can someone explain why on one dashboard, I see "add filter", but if I create a new dashboard I do not have it? Both have show filters checked------------------------------Hans Hamm------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.