Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
The rules in the new form builder are utterly unpredictable and loaded with bugs, as others have noted. At this point, it is largely unusable unless you don't have form rules. Where do I go to find out what bugs are already reported before I start putting in support cases? I don't want to waste my or QB supports time with things already reported. I have already wasted hours on these forms. ------------------------------Drew Voge------------------------------
Hello all,A lot of you may already know this but the migration tool cannot recreate table-to-table imports in pipelines. When I asked the support group about this, they stated I would have to recreate the table-to-table solutions in pipelines. That was all well and good but we have 20 apps and each one has 4 or 5 imports that run daily. But after looking around a little I've found a simple solution.Schedule a Pipeline in the WebHook Channel: Make Request, and run the Quick Base API Call "API_RunImport" with the URL:https://target_domain/db/target_dbid?a=API_RunImport&id=10&usertoken=user_tokenThe dbid is the db when you're in the edit section of the table to table import you want to use, and the id is on the same URL line. I've tried it and it works.
I actually have two questions: Can you print the new gantt chart? Can you create a master gantt that puts all of your active projects in 1 gantt? I know the project field is collapsable but i don't see a way to do it. ------------------------------David Hyde------------------------------
So I am very confused here. I am developing a software to update some of the necessary fields in QuickBase for us, however, I am getting this error. Error: "Can not change the value of the formula field with ID \"17\"." And as you can see it is stating it can not change the value of a formula field nor will it do a reference field or lookup field. However, with the button we currently utilize within QuickBase this is exactly how we do this. Button Code: Now in QuickBase I only see one type of API call to both insert and update a WO, so is there some way with an external API call I can do this also? QuickBase docs: ------------------------------William Hunter------------------------------
I have a dropdown option for a Resource to add additional helpers. Dropdown field: " How many helpers?" the choices are 1-5. Depending on what number they select, is there a way for it to show that many additional fields of "Helper name" and "helper total hours"? So if the resource selected 2, then 2 additional fields will show so they can input the 2 helpers names and hrs worked. I can just add 5 additional fields for names and hrs, but if they are empty they take up too much space. ------------------------------Dell Delemar------------------------------
I have an application where a pipeline is going to a third party to retrieve the current mileage of trucks and inserting into my main table Maintenenace records field [current Mileage]. I have a calculation in [next service] which is a formula adding a select amount of interval i.e. 10000 miles to the current mileage, which will then list the next service value. Problem is they all keep updating every night when the pipeline pulls the current mileage. So when I look at the record the next day, the current milegae of course has updated and unfortunately it also updated next service. So there is no way the truck would ever reach that mileage. I need the report that lists all of these numbers to stay static, but also I need it to be editable in the future. I hope I explained this well enough. This is my first time on the cummunity web site.------------------------------Daryl Price------------------------------
Hello, I am looking to set up a trigger to update several fields in my Employee table when a new record is created in my Position History table. My Position History table holds records for current and previous positions for the related employee. The fields I'm looking to update in my Employee table are department, unit, location, and position. Essentially, I would like the most recent position record added to act as the employee's current position. I have a relationship set between the two tables and have tried adding Quickbase actions to modify the employee record, but nothing seems to be working. Please see screenshot of my table set-up. ------------------------------Erika Brown------------------------------
Hello QB Pros! I am trying to set up a field that compares the entry of one field to a list in another field and gives a result based on whether the fields value is in that list. Example. User enters a Part Number "12345" in the the part number field. Another field looks in another table for Part Number "12345" and returns the text "Out of Stock" or some other text.I gather it is probable a combination of If and Get Field Values.Thanks for your help!------------------------------Conor Gray------------------------------
Hey folks, so I'm trying to find the first monday of the month in my pipeline, and I'm struggling to find a way to insert my own info to create a date to work with. Here is the beginning of my current attempt, with the problem laying on getting firstDay into date format... {% set firstDay = time.date(a.year, a.month, 1) %} {% set weekday = firstDay.strftime("%w") %} Would appreciate any help here with this, thanks in advance!------------------------------Aiden Perez------------------------------
I need assistance with this formula. I am trying to formulate the following: - If the date in the CAT - Cats Complete Date field is in the same month and year as the date in the Monthly Period field, then return 1, otherwise return 0. CAT - Cats Complete Date is a date/time fieldMonthly Period is a date field If(LastDayOfMonth(ToDate([CAT - Cats Complete Date]))=LastDayOfMonth([Monthly Period]),1,0)------------------------------Melanie Proebstel------------------------------
Hi all. I am hoping somebody could give me some advice relating to setting up a webhook in Pipelines please? I am trying to 'Post' to an external site (Digidentity) following their API documentation. This particular one is to retrieve an application token. I have managed to get this to work in Postman, but when I enter the settings in Quickbase I get the following error: json:Object error_description:"'grant_type' required." error:"invalid_request" The API documentation tells me to include the following data: The bit I am struggling with is how to enter the grant_type and scope within the API. I have tried to add this into the 'Body' and this is when I get the error above. Here is what I have typed in to the body field: { "grant_type": "client_credentials", "scope": "1e78xm7xxx3c9p1e"} I have checked this in a JSON viewer and it appears to be in the correct format, but I still get the message to say 'grant_type' requi
Here's an Excel based API tool I created that allows you to test various Quickbase API's. It was developed as groundwork for a far more ambitious Quickbase/Excel project I?m working on. So if you need something to create, test, or just play with API?s against your Quickbase apps, this may meet your needs. Enjoy!Kenhttp://home.surewest.net/firch/Quickbase/QB_API.xls
Hi, I'm trying to get my users to authenticate themselves using their Quickbase username/email address and password credentials. These credentials are for the authentication to further make a few API calls.In other words, instead of user token, I want to authenticate using username/ email and password while making Quickbase API call------------------------------Praharsha K------------------------------
HI I'm trying to merge two tables that have similar primary keys I have uploaded the data in one table it was smooth but when I tried with the other table it showed that I have many duplicates and same time I want to pull that data from both the tables to one single table.------------------------------krishna------------------------------
Ive noticed on the new forms, if you edit a record and save or cancel, it doesnt land you on the record, but rather returns you from whatever report you launched off of. Is this expected behavior or a bug? Anyone know? *Update - I just noticed there is a now a 'save and view' option in the save dropdown, so clearly designed behavior. ------------------------------Mike Tamoush------------------------------
Recently I built a pipeline to do a decimal-to-hex conversion between two fields. The pipeline worked properly when running under an administrator account, but failed when the same pipeline was built by a user account. When the user account tried to enable the pipeline, the user would receive a toast notification "Remote API returned authentication error" like the one below. After some trial and error, I determined that enabling the "Edit field properties" permission on the target table for the pipeline owning user solved the problem.------------------------------Michael Herman------------------------------
I have a Master table that pulls data from SAP and brings along with it the name of the analyst responsible for that record. I can also bring in the email if needed. I would like to send notifications and reminders to the analysts and so would like to automatically assign the record to that analyst using a user field. How do I do that? All analysts will be 'users' of this app.------------------------------Deepa Prashant------------------------------
Hi all. I'm hoping somebody can help me with this please? I am trying to run a piepline webhook to 'POST' to a third pary application. The authorization method I need to use is 'Bearer Token'. Can this be done using a webhook in pipelines? I have tried for a few hours and can't get it to work. Thank you, Michael ------------------------------Michael White------------------------------
Is it possible for (QB) to automatically generate an issue when a recurring service's scheduled date arrives?------------------------------Roberto Figueroa------------------------------
How would I revise this code to have the word ORANGE in color #FFA200 and then the rest of the sentence in green again."<div style=\"color:#34a853;font-size:300%;font-weight:bold;\"align=\"left\">"&"To update the work ticket: Please use the orange SAVE AND RETURN TO MRI button ABOVE to save this review and update the work ticket."&"</div>"------------------------------Melanie Proebstel------------------------------
Hello - I have a pipeline that looks through a table for records that meet certain criteria. Each record found is then updated. I would like to send an email summary of the records updated with one or two fields from the record (for example record ID, record owner, field ID 1 (status or record). I believe this would go outside of the For Each step (so after the loop of searching and updating records) but not sure how to capture/input the fields/summary of what has been changed. Is this possible to do?------------------------------Thanks in advance,Jennifer Paschal------------------------------
Hi everyone, just like Josh, I've been an making everyday better with Quickbase for 7 years. I love coming out with solutions for everyone... whether that's for Beca, our clients, my mates with start-ups or the wider Quickbase community. ------------------------------Matt Stephens------------------------------
Okay, I need to send a report to users in a user field but I want each user to only see their records. The report would be records that are pending for 5 days or more. Any idea how I can do that?------------------------------Carol Mcconnell------------------------------
I have created the Parent-child table form , but when I go to child form --> Setting ---> notifications ----> I didn't find the field from parent table (where i want to send the notification )------------------------------Nilesh Khabade------------------------------
Hi Quickbase community, I have a parent table and child table, where I want to duplicate the child records. I would like to duplicate all of the child record fields, but change the value in one of the text fields to "new" to clearly identify the duplicates. This is my formula URL: "javascript:void(copyMasterDetailButtonHandler('&relfids=7 &destrid=" & [Record ID#] &" &sourcerid=" & [Record ID#] & " ', 'xxxxxxxx' ))" The xxxxxxxx is the master table ID and the relfids=7 refers to the field for the report link for the child table. Is there a parameter that I can add which would not copy every field in the child record? Many thanks. Chris ------------------------------Chris Sipes------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.