Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
In my Resets Table, I need the Equipment Ordered Date to be blank if there is not a numeric value in the Table/Field - Projects Order Equipment.The field - Treat blank values as "0" is uncheckedAnd I have this formula to provide the date the equipment needs to be ordered by in my Resets TableIf(not IsNull([Project - Order Equipment]),WeekdayAdd([Start Date],-[Project - Order Equipment]))The result I keep getting (and I have tried several variations) is the Start Date.------------------------------Hans Hamm------------------------------
I know Quickbase reads these comments and takes them seriously, so I am hoping other people will agree with me on these 2 enormous mobile bugs, and perhaps it will become an important enough issue for them to address. If others have run into these 2 problems, please let me know, and let QB know!Mobile:1. Search does not work. Searching is such a basic function, this seems like a huge bug. You can search a report, but if you have an embedded report (a report link on a form), the search function does not work.2. Hide green + buttons (hide Add Button/Links). On desktop, there is a very good feature to hide the add button links so that users cannot create orphan records. On mobile, this is in the form of those Green Plus Boxes. They are supposed to be hidden when you click hide add/button links. This is a recognized bug for I believe 7 years, with still no fix. This can cause orphaned records. Additionally, if your button has any extra features, they are not used. This also seems like a hu
I am trying to take a summary field of users (which in reality is a text field of email addresses), and convert it to a user list field. My attempt did not work and I am not sure why. I created this formula in a field we will call [Converted To Correct Format Formula]:If(ToText([Combined Text Field])<>"","Touser(\"") & SearchAndReplace(ToText([Combined Text Field]),";", "\"),touser(\"") & If(ToText([Combined Text Field])<>"", "\")")That yields a result such as:Touser("email1@email.com), touser("email2@email.com")I made a user list field and if I do the following, it works:touserlist(Touser("email1@email.com), touser("email2@email.com"))But if I try this, it failstouserlist([Converted to Correct Format Formula])It tells me it is expecting a userlist but it is text, which I guess makes sense as it doesnt know what my formula field yields. Is there an easier way and I am just over complicating?------------------------------Mike Tamoush------------------------------
Hi Community,Our company receives Support requests via email from our customers, each one creates new ticket/record in Quick Base. Sometimes a customer will send two or more emails (different people send email) for the same issue. This creates what are essentially duplicate requests on multiple tickets/records.Can anyone suggest how we could use Quick Base to identify and write any duplicate requests received to the first ticket submitted, instead of creating a new ticket each time?Any ideas are very much appreciated. Thanks, Stephen------------------------------Stephen Cherepy------------------------------
Hi,Have a numeric formula, which is performing a number of calculations in order to determine an overall result. I must perform this calculation multiple times throughout the form with only minor changes to one of the calculations.Is it possible to expose the variables that will not change, so they could be used throughout the App - making them a Global Variable.RgdsPat------------------------------Patrick O'Neill------------------------------
I'm testing the Procore channel, but this question may be answered if youve worked with other Pipeline channels.If I want my trigger to be: 'When a project is created in Procore', does anyone know what permissions are needed for the procore account? I imagine this question is relevant to any channel where the trigger is something being created.I assumed read only rights were enough, since I am not attempting to create anything in procore as an action. However, it tells me I do not have enough permissions. Not sure if I just need some sort of admin rights, or if I specifically need to be able to create projects, in order to use it as a trigger?------------------------------Mike Tamoush------------------------------
I have a text field XY containing data"hellofriendhow are you"I m trying to detect if it contains line break or \n (which it does)contains([XY],"\n") This fails , what else can be done?------------------------------Prashant Maheshwari------------------------------
Hello,I am having an issue creating a seemingly simple pipeline: A) Trigger | File added or Changed to DropBox folder specifiedB) Import with CSVI have followed this course (https://university.quickbase.com/importing-csv-files-into-your-quickbase-app/1037410) and cannot figure out why this is happening. Error screenshot is attached. Any ideas, suggestions, or re-directs would be greatly appreciated.------------------------------Shane Miller------------------------------
Hello,I am attempting to build a date formula that will always refer to the last occuring Thursday.E.g., if today is Sunday-Wednesday, the formula will return the date for the Thursday of last week. If today is Thursday-Saturday, the formula will return the date for the Thursday of the current week.Thank you!------------------------------Quickbase Admin------------------------------
Good morning,I'm currently creating a report that displays within an app which shows the amount of days left till a date is approaching. I have some customers based on import that have dates in the past therefore the formula I've created to calculate to give me the amount of days displays blank for some of them.I was wondering if there is a formula or something that I could do that would hide the customers who do not have any information displayed within the field that does the calculations. Thank you all for your help as always!------------------------------C A------------------------------
I see where I can set a maximum number of characters restriction on a field. Is it possible to set a minimum restriction? ------------------------------Chelsea Carpenter------------------------------
Is it possible to create a user formula field that displays the current user?------------------------------Matt Makris------------------------------
I need help speeding up a pipeline.I have an app that tracks Printed Circuit Board Assemblies (PCBAs) by serial number and the components that are on them. The system lets the user barcode scan each PCBA serial number into a field and the scanner adds a linefeed to the end, so at the end of a run, there may be 100 serial numbers in the field. The system also has a list of which components go on the PCBA, and there may be as many as 150 of them.When the pipeline executes, it:1) Splits apart the serial numbers2) Start a loop for each serial number that: 2a) Creates a "top level" record for the PCBA with some master data as well as that specific serial number 2b) Searches for all of the component records in the master data table associated with that PCBA, then creates a record in the history table with the component info and the PCBA serial number tied to it3) Loops back for the next serial number and does it all againWith 100 serial numbers and 150 components, t
At some point over the weekend something broke/changed in QB and suddenly all of the roles in our app that had different homepages set for each suddenly started instead taking the user to the app default homepage instead. Big problem when there is information on some pages not intended for all users. Anyone else experiencing this or know how to resolve? ------------------------------Jeff Peterson------------------------------
I am trying to create a new exact form for one of my applications. This would be the first exact form for this app but I have created others for different apps. I'm using the same steps in creating this one but something isn't connecting and I have no idea why or what.The set up instructions says that you can't have application tokens enabled yet when I'm first presented with connecting to QB the login screen has a field for an app token. If I leave this field blank it prompts me to enter one. So I created a token for my app and entered it. The login screen is now happy but I never get the secondary screen where I can select the table the form should relate to or even to be able to give it a name.I've even tried the open from QB option but nothing happens. I'm starting from the QuickBase Exact Forms 2010 (64-bit version).dotm template file. Is there a newer one that I should be using? What troubleshooting steps can I take? So frustr
Currently using New style. A few weeks ago, all columns on all tables stopped wrapping text. Each field has "Display without wrapping" UNchecked. Table is so wide, you have to scroll very far to the right to see all columns. When New style is turned off, columns wrap text.------------------------------Taylor Allen------------------------------
Hi Quickbase community,I have an app that is principally used for posting events, which has a start and end datetime fields. My organization uses a calendar view to see the these events. Most of the time it is ok for there to be overlapping or conflicting events, but occasionally this will be a problem. We currently rely on users to check the calendar before creating a new record to make sure there is no applicable conflict, however I would like to build in some kind of automatic alert to help avoid user error. Basically, I need the user to be notified, either during the creation of the the record after the start and end datetime fields are set, OR after the record is saved, if the condition is met that any part of the duration of the event overlaps with the duration of another record.For example: Record 1234 has a start datetime of 10/12/2022 of 13:30 and end datetime of 10/12/2022 of 16:30. A user goes to create a new record (let's call it 5678) and sets the start datetime
I am pretty sure I know the answer to this (which is, this is not possible), but when using sort and group on a report, if one column is numeric and I only want the final total (total for the entire report), but do not want the total column to show in every single group, is that possible?Also, forgot to make my title reflect this question:Any way to search the grouped heading? Or just use the My QUuickbase Coach sneak technique for searching fields not on the table?------------------------------Mike Tamoush------------------------------
I have a many to many relationship between Patients and Labs. I have two questions: 1. How do I add a record to the join table (Patient-Lab) directly (and allow the user to choose which Patient and Lab to associate it with)? This seems very basic, but I cannot find the instructions to do this in the forum or in the help documents. I want the user to have the option to choose from a record picker the Patient and Lab they want to associate together. 2. How do I add a record to the Patient table that allows them to choose which lab they want to associate with this patient record? I need several values to populate in the record picker so the person entering in the Patient table will know which lab to associate.------------------------------Solace Sonder------------------------------
Good morning,I've created a pipeline to update a date field in one table from a date in another table. When I add or change the date, it works fine. When I remove the date entirely, it does not clear it from the other table. Is there an additional step I need to take for this?Thank you,Kim------------------------------Kim------------------------------
Hello,I have 1 App and 3 tables that I believe I need to utilize to get the proper results from my pipeline:1) Claims Detail Extract a. Member ID (numeric) b. Employer ID (text) c. From DOS (date) d. To DOS (date) e. Paid Amount (numeric)2) Claims Account Report a. Employer ID (text) b. Master DOS Start (date) c. Master DOS End (date)3) Member Spec Alert a. Member ID Lookup (text (reference)) connected to another app/table b. Spec Amount (numeric)Essentially, I would like to create a pipeline that searches for and sums the [paid amounts](1e) of every unique [member ID](1a) whose [From DOS] (1c) is On or After [Master DOS Start] (2b) AND [To DOS] (1d) is On or before [Master DOS End] (2c) AND [employer ID](1b) equals [Employer ID] (2a)If TRUE create a record capturing the [member id](1a) and the summ
Good morning, I'm looking to create an inventory system that we can track. I am wanting to have a table with all are inventory items about 30 items total that we will be updated manually as we restock inventory. But I am also wanting another table that can link back to it that employees can use to create an inventory pull form showing the item they took and how many and then remove that number from the main inventory table, so we know what we have in stock at all times. Im looking for some suggestions and help on how this can be done with linking them to show updated numbers as we pull items.------------------------------Matthew Jones------------------------------
I want to trigger a pipeline to insert a task record into a separate system, but only when the task gets assigned the first time (after the PM validates), not if it gets reassigned. We have an [Assigned To] user field that we use to set assignment, so I want to trigger the pipeline only if the record gets changed from a blank user (kind of like we can do on form rules). FYI - I can't do it on form rules because sometimes they run an import, and don't always use the form. Can this be done natively in pipelines?Thanks------------------------------Sean Boat-MooreManager SMB DevelopmentProject Management Office and Quality Control NCR Corporation sean.boat-moore@ncr.com | ncr.com------------------------------
I am having trouble setting up a Dynamic Form Rule.I want a message to be displayed whenever a record is saved. Why isn't this an option that I can select? When I choose the condition of a record being saved, my ability to select the option of "display a message" goes away.The reason I have not selected another condition is because this a form with many numeric formula fields, that are using lookup fields to do math.Every time i assign the form rule's condition to be based on a field (usually a lookup field from another table) it does not fire correctly when the records are saved.Any ideas on how to rectify?
- unchecking "Searchable" does not affect Workato search - unchecking does not affect Quickbase report filters - unchecking does affect Dynamic Filters According to Quickbase (search article here): Some fields never need to be searched: numeric, report links, and formula URL fields. Below is a list of what we found to be more accurate. Check box fields used in Dynamic Filters must be Searchable! Un-Searchable For Certain: Related Numeric summary Formula - Rich Text URL Record ID Report Links File Attachment Deprecated (Google it) Optional: Check Box Formula - Check Box Date/Time------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.