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 table of customers. Users are able to add customer records, but not edit them.Before they are able to add a new customer record, I want to 'force' them to search existing customer records to make sure they aren't creating a duplicate.If the customer record is found, they can select it to view the record.If the customer record is not found, they need to be able to add a new customer record.There may be a much easier way of doing this - and if so, please let me know - but this is how I have it set up right now....I've set up a Search table and connected it to the Customers table.Customers = parent; Search = child.From our home page, the user clicks the Search customers button which opens a new Search record. They are presented with a dropdown list of Related Customer records where they can search for the customer they are looking for. If they select a customer from the list, they are shown related customer fields which will help them identify if this is the cust
We have a multi-select field called "Portfolio" in the Projects table. When a fundraiser is added (from another table) to the projects, we would like to have their dept checked in the "Portfolio" field but not uncheck other choices already checked. Right now it is done manually but usually missed getting done. Pipelines does not allow for writing code to a multi-select field. How can I 'check' a choice in a multi-select without affecting the other choices checked?------------------------------Amy Gosz------------------------------
Is there a way to name a picture attachment as you upload it into a record from the Quickbase mobile app? Also, is there a way to rename an attachment that is already in the record? Quickbase automatically gives it a file name when taking a picture using phone camera with a string of numbers which isn't meaningful.------------------------------Brian Hunot------------------------------
Hello -I have an automation that triggers on modification of a record. I would like to add criteria to that will not run the automation if I am the person that modifies the record. I know how to do this via notifications because you can select the user from a dropdown when adding Last Modified By as a criteria. In the automation however, it gives you an empty text box. I have tried typing my full name as shown in QB, the way my name exports "FULL NAME <QB ID#>.Anyone have any guidance on this? I can turn off the automation to do the bulk uploads I need to do but I do them regularly so I would prefer to build it in to the automation if possible. If this would be easier with a pipeline I am open to that as well, but I would have the same question as to proper syntax for entry of my name/userid for the criteria to read correctly.------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hello Community How can I create a pipeline that changes a checkbox at a specific time every day?For example: Monday 23:00check box = trueTuesday 23:00checkbox = falseIn this way my email will be sent when that checkbox field is edited.Thk u very much.Redgards, Herberth Solano.------------------------------Herberth Solano------------------------------
Hello Quickbase community!I'm trying to send a graph by email but I get this whenever they are graphsWhat could it be ?Thak you very much. Regards, Herberth Solano Vargas. ------------------------------Herberth Solano------------------------------
You will love this one.Trying to build an app that tracks vendor (partner) contracts which include services, number of units by service and pricing by service, then be able to have partners report on that each month so that we can reimburse them.So...I asked Chat GTP to write that for me. What I can't figure out is how to get the related Record ID # (which I assume is the ID referenced below for each table. For example Contract_ID or Service_ID) is to the related tables so that they tie together. I have created the relationships but they definitely are not connecting by themselves.Here is what I got back: To model this relationship in a relational database, you can create the following tables: Vendors: stores information about vendors, including vendor id, name, address, and any other relevant details. Services: stores information about services offered by vendors, including service id, name, description, and any other relevant details. Contracts: stores information
Hello Quickbase community! I have a question Somehow I can select the fields I want to appear when I select:Thank you very much.Regards, Herberth Solano.------------------------------Herberth Solano------------------------------
Hello -I have several tables in my QB applications with data from other sources using a script to push data from internal databases. We have one table that is not updating properly and are getting this error reported. Other tables that do not have the Key Field set to Record ID are working as expected so I am not sure why this table is giving us trouble. The Key Field HAS been changed since creation, could that be causing an issue? We have tried wiping the table and rerunning the script and get the attached error.Any guidance you could provide would be greatly appreciated!------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hi everyone,I have a report that my purchasing team uses to assign "Order details" to a PO (line items). In our business a single item might have accessories for multiple line items. I am trying to figure out how to do some row shading....Attached is a screenshot of the report. My attempt to row shade was to take the frac of the record ID/2 to try to see if it is even and if so make it gray. but based on sorting that does not work.So how do I do one of the two things:Ideally shade based on the item # field which you will see on the screenshot. So in this example the blank line item would be shaded, A01 would be non shaded, A03 shaded, and Z01 both line items not shaded (since they are attached)In the event that is tricky I would sacrifice for true alternate row shading for readability but cannot figure out how to do that either.Thanks!------------------------------Ivan Weiss------------------------------
Trying to understand how to correctly use the dashboard KPI Widget Delta change feature.My scenario:I have a chart/gauge report called 'Alerts today' that counts the # of alert records based on an Alert Date field. The report is filtered where the Alert Date is during the current dayI then created a Dashboard KPI widget and selected the Alerts Today report. I want to take advantage of the Delta Change feature and selected the same Alert Date field as the 'Field for Comparison' and the comparison period as 'Yesterday'. My hope was this would show some kind of "delta change" of the # of alerts from today compared to the # of alerts from yesterday. But the delta change is always showing the value of alerts from today.For example- if we received 100 alerts yesterday and 20 alerts today I was hoping 'delta change' would show either "↓80 alerts but instead its showing "↑20". I'm assuming I have some conflict between the filter in
Did QuickBase remove the ability to group reports? Users used to be able to click the three dots next to a field in a report and group the report. Now it seems only administrators can group reports. Is there a setting somewhere we can change this? Lots of users relied on this function so it's kind of disappointing. Thank you in advance! ------------------------------Gelo------------------------------
I have a field that has javascript embedded in it to provide a confirmation to the user when they acknowledge via a button. The code is at the end of this post.How do I do this in the new approved javascript format? I guess I need a code page but I basically searched the internet to get this to work, I am not really familiar with javascript. I dont know how to call a code page or if I just simple move this javascript into it and make it a js file?var text URL = URLRoot() & "db/" & [_DBID_THE_ELITE_WAY_VIEWS] &"?a=API_AddRecord" &"&_fid_6=" & URLEncode ([Record ID#]) &"&apptoken=HIDDENFORSECURITY" &"&_fid_8=" & URLEncode(User()) &"&_fid_10=" & URLEncode(Today());"javascript:" &"$.get('" & $URL & "',function(){" &"location.reload(true);" &"});" & "void(0);alert('Confirmed');"------------------------------Ivan Weiss------------------------------
In the Pipelines help article it states there is a step limit of 26. I have found that you can add more than 26 steps and it even seems to complete them all. I have ran a Pipeline with 30 steps that completed the final step, they were all using the Quickbase channel. I am using the Bulk Record Sets: Remove Record(s) step for every step in my Pipeline except the first which is a trigger based on a record being deleted.Is anyone aware of how this limitation is actually imposed on a Pipeline?I know that using the Quickbae channel is said to have no billable steps used, is the 26 step limit of a Pipeline based on billable steps only?For a step to be counted towards the 26 step total does the step need to actually find records? Or is a step simply an entry in the Pipeline no matter if it finds records or not?Those are the only things I can come up with as far as why I am able to seemingly go past the 26 step limit. If anyone has any additional insight here that would be awesome. Even better
I am trying to formulaically change a date with a PipelineIf I hard code the change in the date it will work with the following expression{{a.date +time.delta(days=2)}}However if I use a variable {{a.date +time.delta(days='a.numeric_field')}}I get the errorValidation error: Incorrect template "{{a.date +time.delta(days='a.numeric_field')}}". TypeError: cannot concatenate 'str' and 'int' objects The field a.date is the string and a.numeric_field is my integerI have tried all sort of variations to convert the data type such as 'a.numeric_field|str' Str(a.numeric_field) However my syntax is aways wrong.Any suggestions would be greatly appreciated.------------------------------Don Larson------------------------------
Hello!I have a few questions folding together at once here, and would love to know if anyone has any recommendations for me: Is there a way to create a grouped bar chart displaying months together, to display year-over-year trends similar to what this person has here: Similarly, is there a way to create a summary report that ALSO displays the months together, and not as their own lines in a table (that seems to be all I can achieve) - see crude screenshot here: Last - Is there a way to set up notifications to email a visual chart (such as bullet #1)? It seems I am unable to do so, but can have a notification set up populating a table such as bullet #2. Ideally, I'd receive the chart in my email monthly. The one thought that has occurred to me to solve for #s 1 & 2 are to create fields for Month, and Year, and have rules that will fire a change to those fields once the date has been filled in..... but that seems like a really convoluted workaround and I'm not even confident I coul
I did not have time to do a lot of research regarding this question because I am running a big job....but this pertains to this. I want to give my client access to their record only. This is a high-profile job, and I do not want them to have to login or create a user account.Is there a way to send the a link so they can see status updates, photos, and any notes in their job record?Thank you,Jennifer------------------------------Jennifer Meyer------------------------------
Has anyone figured this out? I need to create a child, but when the user lands on the child I need the record ID to already exist.The reason is, once on that record I want the user to use the Juiced Signature addon. This addon, like all of their addons is great, but understandably requires a Record ID to work.I could make a 'Save' button so the user saves, then signs, but I want the process to be: Worker has ipad, clicks add Attendee, they enter their name, sign, then 'save and next' and hand it to the next employee.Once they are in the signing process, I think I can make this all work using %%rid%% (I can make a custom save and next button). However, the trick is getting the first person to sign, or if they need to add another signature....it's trying to get this to happen from the parent.------------------------------Mike Tamoush------------------------------
We have two apps in Quickbase. One of the apps serves as a CRM and another app is for inspections. When I view an account in the CRM app, how can I have a report appear on the account screen of inspections for that account?------------------------------Landon Wyrick------------------------------
I am wondering if there is a way to display a record that is tabled within the App as text on the App's homepage. I have a table called "Daily Safety Message" where each day there is a different message. Currently I am running a report that filters the current days message and I just simply display that report on the homepage. However, I'm wondering if there is a way to display that message in text format on the homepage?------------------------------Yobani Maldonado------------------------------
I have a very simple pipeline that takes Quickbase records and appends to a Google sheet; the pipeline finds records in my Quickbase table that match a criteria and should append to an existing google sheet. The append to google sheet keeps returning an error -"Something went wrong executing a step. Try modifying your pipeline."I am not sure what this means and QB support is nonexistent or just have my going around in circles. I feel as though my pipeline is constructed correctly. Images below as the data is not sensitive.I've tried different variations of converting each header row but still unsuccessful, not sure what the issue is. ------------------------------Niraj Shah------------------------------
I have a text formula (plain text) that includes a number of "\n" for line breaks.I use a dynamic form rule to fill [Multi Line Text Field A] with the value in [Text Formula].Everywhere there is a line break, it puts: <BR><char code="10"/>The only solve I have found so far is to make my Multi Line field A, a rich text field. Does anyone know why when it fills during a dynamic form rule, it suddenly converts to rich text? And if there is a work around?------------------------------Mike Tamoush------------------------------
Hi all, I'm trying to generate a block of plain HTML that uses certain fields from all records in a table, and places these into a standard format. The idea is to generate the HTML which can copied and pasted to a third-party web publishing platform. The HTML is fairly simple - just bulleted lists and a few headings. Here's the general HTML format I want to follow. <h4>Static heading text</h4> <ul> <li> <strong>[Field 1 from first record - only if it has a certain field value]</strong><br> [Field 2 from first record - only if it has a certain field value] </li> ...(generate using all records from a table) <li> <strong>[Field 1 from last record of table]</strong><br> [Field 2 from last record - only if it has a certain field value] </li> </ul> I've done something similar in Google Sheet where certain cells a
Hi Team,I have an image that I trying to embed in one of the notifications. All the text is populating properly but the image is not populating. Need your help. Please find the attachment for reference. The highlighted red part consists of image which is not displayed in email notificationThanks!------------------------------Sam Shah------------------------------
How do you filter a report to only display the most recent record?------------------------------Kimberly Massa------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.