Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi, I have a mailto formula set up so that when we click the button, it opens a new email in Outlook with the emails address To and the Subject prepopulated. This works absolutely fine on the old forms, but on the New Forms it's opening a new browser window instead of Outlook. Is there any way to get it to open a new email from Outlook from the New Forms? The formula is: "mailto:"&[Compliance work - Email to Use]&"?subject="&[Subject of Email] In my Windows settings the default application for MAILTO is Outlook. So far it's taken me to yahoo, gmail and hotmail home pages, each time I refresh the page it takes me to a different mail provider. It seems to be ignoring the Mailto function. As said, on the old forms it works perfectly fine. ------------------------------Personal Tax Team------------------------------
I have created 2 pipelines to capture data for my Months table (reporting). The pipeline is running fine for both the above, however it is only capturing NEW data. I need to also collect the data/records prior to creating the pipeline. Can anyone tell me what I am missing??? Thanks!------------------------------Kelly Lyons------------------------------
I am building a form with the new form builder. I put a link in rich text that I am trying to get to open in a new tab instead of taking over the current QB tab. Any ideas how to do this?------------------------------Krista Sibery------------------------------
Hello, I'm trying to confirm if there's a way to use an open form to update an existing entry for a leads table that are already existing? At face value, I would believe a form would generate a new entry each time it's filled out, but I don't know what I don't know.Thank You :)------------------------------Anthony Wong------------------------------
Does anyone know of a way to pull data into quickbase from a IMB DB2 database?------------------------------Carol Mcconnell------------------------------
I am trying to create a formula that if a supplier name is equal to XXX, XXX, or XXX then check the supplier requires legal review box, however I keep getting different errors. Here is my current formula, any advice? If( [Supplier] = "Workday" OR [Supplier] = "Amadeus" OR [Supplier] = "Flightkeys" OR [Supplier] = "Google" , true, false) I have also tried: If( Or( [Supplier] = "Workday", [Supplier] = "Amadeus", [Supplier] = "Flightkeys", [Supplier] = "Google" ), true, false)------------------------------Elizabeth Schlagel------------------------------
Hi All , I've been trying to do group by as a formula due to I'm trying to create Gauge Chart that count title that has been added to field [Title] , when i use count() it count all records , i guess what i need to group by first all titles that has same name then count those groups of titles , in order to give me how many titles we have at the end Thanks in Advance 🤗------------------------------Abdelrhman Naser------------------------------
Can Pipelines read a table and then create a csv output file.------------------------------George Romanowski------------------------------
I just found the "Last Modified by" and "Current User" options for Notifications and want to say nice! Jim------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
If(IsNull([Related Order]) & [Type]="Non-conformance Report (NCR)","NCR-"&[Tag]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot]),If(IsNull([Related Order]) & [Type]="Material Problem Report (MPR)","MPR-"&[Tag]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot]),If((not IsNull([Related Order]) & [Type]="Non-conformance Report (NCR)","NCR-"&[Plant Number]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot]),If((not IsNull([Related Order]) & [Type]="Material Problem Report (MPR)","MPR-"&[Plant Number]&"-"&If(IsNull([Snapshot]),[Snapshot Override],[Snapshot]))))))------------------------------Sarah Burres------------------------------
Hello everyone, by following Approve button in the exchange I have set folling property for my apporved button: But everytime I click this button it will disappear, is there any way to let remain in the form? Thanks ------------------------------Said Zaripov------------------------------
Hey everyone, I am trying to build a simple workflow where after a user adds a sales group they need to add bank accounts, sales reps and contacts all in separate tables. The sales group table has a one to many relationship with each of the other tables so that we can have as many accounts, reps and contacts as needed. I decided to do that by building custom buttons of type either formula - url or formula - rich text and adding a parameter ifv=1 to each url so that I remove all native save buttons from the form to avoid the user accidentally breaking the workflow. It all seemed like a very good plan until I found out that the auto save on redirect does not work when ifv is set to 1. The error I get is that I need to save the record first.. When opening the forms without the ifv parameter the buttons work as expected, the current record is saved and the user is either redirected to the next step or the same form pops up for him if they chose a checkbox another account/rep/contact neede
Can someone walk me through how to set up an online payment option. My preference is to use paypal. I have a form the user fills out. It totals various child records they add as they fill in the parent form. When they are done I would like them to be able to click "Pay" and it send the "total" and "user name" fields to paypal for payment. Ideally after they pay I would like paypal to send back to update the record that this was paid. I am assuming this needs to be a pipeline with a webhook. While I have built pipelines I am not familiar with how webhooks work. Can anyone walk me through this?------------------------------Hadassa Pam------------------------------
My database is vendor contacts who may be in different time zones and work different hours. I'm trying to find a way to make it obvious to the person looking at the record to know if if the contact is reachable at a given moment. We are on Pacific Time. If I have a vendor on Eastern Time who is open from 8:00 AM - 4:00 PM EST, how can I make it obvious to my QB user looking at the record at 3:00 PM PST, that this vendor is closed. I created these fields: TimeZone - multiselect Time Open - Time Time Closed - Time Time Warning - Formula Rich Text I'm trying to write something like this: If ([TimeZone]="Pacific" AND NOW>[Time Open] AND NOW<[Time Closed]), then "Open"), If ([TimeZone]="Eastern" AND (NOW-3)>[Time Open] and Now-3<[Time Closed], then Open), else "They're closed right now." I know this formula syntax is wrong. Does anyone know what it would take to make it work? Or alternatively if there are better suggestions, I'm not locked into this setup. We do ha
Hello, I'm looking for a solution on how to build one report from fields that live in multiple tables - I have relationships set up, however not all fields are pulling in as an option to display in the report. Thanks, LB------------------------------LB------------------------------
Is it possible to export data from multiple tables into a single CSV?My thought right now is to build a 'combined table', and use automations to populate that table with the records I want from the other 4 tables. Then it's a simple report on that new table.Is there a way to accomplish this without actually having all the records in the same table?------------------------------Mike Tamoush------------------------------
We have a use-case where we would like to freeze a snapshot of month-end Inventory levels in a table that is a "clone" of our already existing Perpetual Inventory table. In my mind, it's so easy lol - so far I have: -Created a copy of the Perpetual Inventory table (Month-End Inventory) without any of the data. This gives me the table structure I need - same exact fields -When I try a Bulk Record Sets / Copy Records Pipeline step, quite a few of the fields I select from the Source table are not available in the Destination table as options. Does anyone have any insight as to why? I've reviewed some QB documentation on this function but do not see any documented limitations (Quickbase Help). There are a number of fields that do not show up as options on the Destination table and there doesn't appear to be any rhyme or reason as to which ones are included or not. Screenshot of the issue showing field 'Inventory on Hand' simply does not appear as an option: --------
Hi Everyone, We get bids from vendor on projects (RFPs). For each project we end up having different information submitted. As a result we often end up with an embedded table on the project record where only 10/40 fields have any information Users are annoyed that they have to look at so many empty fields. Is there a way to display only the columns in a report if values are present? For example, if the project has no value for "Rent" in any of the projects related "Bid" records, don't show the "Rent" Field in the project's embedded report. I realize that we could achieve this by having multiple reports, however, we've come to the conclusion this would require maintaining over 200 reports, so we're looking for another solution. Thanks!------------------------------Jake R------------------------------
I have for in which I have created two, but I want to create a cascading data filter for these fields 1) Option1(Multi choice question) (Drop down data is extracted from other data table) 2) Option2(Multi choice Question)(Drop down data is extracted from other data table) I want to do this when in option1 answer selection it should be the data matching from table in option 2 E.g table (data table ) Can anyone suggest how can i do this creation in form ------------------------------Nilesh Khabade------------------------------
Hello, I think I discovered a bug in Pipelines. I've tried troubleshooting this for several hours without any luck. I also encountered this issue several other times. Anyone else having this issue, or know any workarounds? Steps to replicate Insert Fetch JSON, Iterate JSON records, and Loop for each JSON record steps. In the Iterate JSON records step, specify a JSON records path. Inside the loop, insert a reference to a JSON value. Run or trigger the Pipeline, Pipelines can't parse the JSON value with the given path. I've tried the following paths but both don't parse any value: {{j.data_0.release.id}} {{j.release.id}} JSON that appears in the activity log: ------------------------------Frontman------------------------------
This works to works to create a record and land the user in View mode.URLRoot() & "db/" & [_DBID_SKTDS] & "?act=API_AddRecord"& "&_fid_6=" & URLEncode([Supplier])& "&disprec=1";Is there any way to land the user in edit mode?------------------------------Mark Shnier (YQC)mark.shnier@gmail.com------------------------------
Trying to flip or transpose a table report. I have a simple one to many relationship and a simple table report but grouped by a date field - 'week'.I want to create a table report but one that is flipped horizontally with the child records appearing as rows instead of columns.------------------------------
Does anyone have a formula for compounding interest (semi-annual) for loans?------------------------------Jesse Edsell-Vetter------------------------------
I am trying to add the ability to add more than one reference lookup field value to a parent record. I have two tables "Notes" and "Code_Violations". When I click on the "Create a New Note" button the Note form opens. On it there is the "Code - Violation" lookup field displaying the code violation options from the "Code_Violaitons" table. I would like the ability to add multiple code violations to one Note record if possible. Maybe, if possible, when I select the first one a new Code-Violation lookup field displays ready to add another if desired? ------------------------------Brian Dunk------------------------------
I have a mature app which relies heavily on scanning 2D bar codes to do Location updates on physical inventory items. One Inventory Item has Many Location Updates. The items all have a 2D Bar code on their label which essentially puts up an Add Location Update form up on the screen. The user then does a "save" manually. Currently we use regular smartphones to do the scanning (in fact just the personal smartphones of the field technicians) as it was a cheap way to get started, but with growth in volumes we are looking for a better solution. I'm looking to connect either via this forum or one to one with users who have experience with say a bluetooth scanner hooked up to an iPad. I found this on Amazon as an example. TEEMI 2D Wireless Barcode Scanner with USB Cradle for iPad iPhone Android Devices and Tablets, Support QR, PDF417, Data Matrix, Read barcodes on Screen Amazon remove preview TEEMI 2D Wireless Barcode Scanner with USB Cradle for iPad iPhone A
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.