Recent Discussions
Multi-Select Fields with Commas in Pipelines
I have a text field in one table that I need to use to populate a multi-select text field in another table via Pipelines. The text field contains a semi-colon-delimited list of people, including their name and title separated by a comma (Person 1, AA; Person 2, BB). This format is required for our purposes and cannot be changed. I have already created a multi-select formula helper field in my original table using the Split() function to translate these values to the correct format prior to using Pipelines to copy them to the other table. In my original table, the formula multi-select values appear correctly: Person 1, AA Person 2, BB However, once Pipelines copies the value, it seems to be exploding and recreating the multi-select options and now also considering the commas to be a delimiter, so my resulting values look like: Person 1 AA Person 2 BB I assume this is a bug and not intended behavior so I will submit a support ticket, but in the meantime, does anyone have a workaround for how to get the result to populate correctly without seeing the comma as a delimiter?
Report Based on User's Role
Hello, What is the best method to create a report based on a user's role? I created a table which contains a list of users, their ID, and their role. I tried to establish a table to table relationship with the Projects table and User List table. But, the User List table fields are blank on the Projects table default report. I tried to import the User List data into the Projects table, but this option failed to work for me.
ServiceNow Table Object Creation Pipeline Not Fetching Data
I have configured a QuickBase Pipeline to trigger when a new record is created in a specific ServiceNow table. While the pipeline is triggering and executing Poller events as expected. But it is not retrieving data from ServiceNow into QuickBase. I would appreciate any guidance or recommendations on resolving this issue. Thank you for your assistance.
Quickbase Email IP Address Range Migration
[Article most recently updated March 2025] Quickbase keeps an up-to-date Sender Policy Framework (SPF) record for all email servers used to send email from our platform. Please note that if you use SPF, you can still adhere to your organization's spam filtering policy without having to allowlist the IP addresses of approved senders. See http://en.wikipedia.org/wiki/Sender_Policy_Framework for more information on SPF. Important: Note that SPF is our recommended and supported method for spam filtering. Since the IP address ranges of our email servers will change without notice, customers should NOT allowlist IP addresses as a first step to ensure Quickbase emails are received. If your organization does allowlist email IP addresses, you should plan to implement SPF as soon as possible. Please see further details on IP allowlisting and Quickbase Email Deliverability Solutions for Spam Filtering in the article linked HERE. If you DO choose to allowlist IP addresses, despite our strong encouragement to do otherwise, here is the CURRENT range used by the Quickbase Platform. US instance IPs EU instance IPs 156.70.3.202 156.70.3.203 156.70.3.204 156.70.3.205 156.70.3.206 156.70.3.207 156.70.3.208 199.15.225.8 199.15.225.9 199.15.225.10 *Note: EU IPs only apply for customers connecting to a <realm name>.quickbase.eu account 156.70.16.254 Our help article about Quickbase instances for more information: https://helpv2.quickbase.com/hc/en-us/articles/20973575550356-Hosting-Instances If you have any questions regarding the information above, please do not hesitate to reach out to the Quickbase Technical Support Team by opening support case A guide to Quickbase Support Options: https://community.quickbase.com/blog/getting-started-blog/get-the-help-you-need-a-guide-to-quickbases-technical-support-tools/83202Dashboard Format Question (summarizing)
I am messing around a bit here looking to create a dashboard to summarize some specific information. I am starting with a report. My fields are as follows: Market Type (subject), Probability (in percent 0,1, 10,20,70,90), Expected Revenue (in dollars), Status (open or closed), Region (for filtering later) Example Data: Football, 10%, $1000, Open, East Baseball, 90%, $500, Open, West Football, 30%, $700, Open, South Soccer, 10%, $600, Open, South I am trying to summarize this in such a way that it looks like the following: Market Type 0 1 10 30 70 90 Grand Total Football $1000 $700 $1700 Baseball $500 $500 Soccer $600 $600 Grand Totals $1600 $700 $500 I have been messing around a bit with both a TABLE and SUMMARY report and I am getting mixed results. What would be the best way to approach this? I have a feeling i'm overthinking this a bit. Any suggestions would be appreciated.
Pipeline: Create a parent record if one does not exist
I have a child table (created by form engine) which contains a field that will be the (custom) key to its parent. The child table may have one or several records which should relate to one parent record. I created a pipeline that does correctly create the parent records, but it seems slow, and we could have many people entering these child records at one time. It is using an upsert (on rows created in the last five minutes, currently) to handle the fact that if there are multiple child records, only the first one should create a parent. I saw this discussion, below, and that's what led me to use the upsert - because of the comments about contention causing pipeline errors in this scenario if another strategy was used. Automation to create record if does not exist | Qrew Discussions This discussion is from several years ago though - is an upsert still the best way to go in this scenario? And is there any way to make it faster?Time Zone change
Good morning, I am building a Transportation application for my team to use. When we request a pickup time from our transportation vendor, it is always in central time since we are based in Texas. Can QB convert the central time to local time based on my selected city? For example, I have an employee who needs to be picked up at LAX at 10 a.m. Pacific time, but we can only enter 12 p.m. Central time. How can I build a formula in QB that will convert noon central to 10 AM when I select LAX as a city? The same goes for all the cities we service. How can I make sure Daylight savings are accounted for? I have attached a spreadsheet of the cities we service regarding their summer and winter times.Formula Query for a related record's file attachment URL
Hey Community! Does anyone have a formula for a query to pull the URL of a related record's file attachment field? I'd like the URL to appear on the parent form and the user can click to download the file. Thanks! ------------------------------ Raymond Sakar ------------------------------