Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Just curious if anyone else is experiencing 'funky' behavior in the last week or 2. Funky meaning: Randomly being kicked out of QB, pages randomly refreshing, pages randomly not loading. It is not super frequent, and refreshing fixes most issues, and not consistent enough to troubleshoot easily. Also not enough to put up much of a fuss. I am just curious if anyone else is seeing anything like this, to see if I can narrow it down to my realm, our firewall, browsers, Quickbase as a whole.... If no one else has this, then I know it's internal.------------------------------Mike Tamoush------------------------------
I have a old form I am currently trying to migrate to the new format. The old form has a rule: when the record is saved, if [Field Name] 'has been changed to' "this" and [Field Name] 'has been changed from' "that" Abort save and say "cant do that" I am having trouble replicating this in the new form, as it doesn't have 'changed to' and 'changed from'. Any ideas on how to achieve the same result?------------------------------Luke McInnes------------------------------
Each Parent record needs an annual review. I want to avoid someone creating two records for the same year. However, since I can't use a look up field (Parent Account#) in a unique field formula, I don't know what I can do to avoid this. I would like to concatenate the Parent record Account # and the child record Year to create that unique field value. I've tried searching for something similar but can't seem to find the right solutions. Any suggestions?------------------------------Amy Gosz------------------------------
Is there a way I can use Quickbase to provide information to Fastfield? I want to do inspections on a building but I would like my accounts in Quickbase to show in the lookup field on Fastfield. I only see the option to use spreadsheets. With the Quickbase/ Fastfield integrations, it seems the only integration is Fastfield feeding Quickbase with info. I need Fastfield to pull data from Quickbase. ------------------------------Landon Wyrick------------------------------
Nevermind, I found it. I had been looking right at, just moved past it too quick. For future users - Manage Roles\User Interface. Right in the middle of the table. "Hide Import/Export Links" I feel like I am missing something very obvious. I have a form that is enabled for EOTI. I feel as if I have hidden everything properly and limited access, but the Import/Export option is still available. This doesn't seem right, but I can't track it down. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I have pipelines created for our service application to create tech dispatches via Outlook calendar events when tasks are created. I want to add a link to the task record in QB as part of the Outlook event body but I cant seem to create it. Can anyone help or know how to do this? ------------------------------Joshua Case------------------------------
Hello, Hopefully this is simple for a jinja2 master. I have a pipeline that is running the API_GetUserRole. I have everything working, except for when a user has multiple roles. When that happens, I get a blank value for role_id and role_name. I shortened the jinja2 to pull all data so I can see what is happening. Here is the jinja2 to pull everything: {{ b.json.qdbapi.user.roles }} Here is the output on the QuickBase record: OrderedDict([(u'role', [OrderedDict([(u'@id', u'45'), (u'name', u'Claims - Processor (Incela/Hawaii Legacy)'), (u'access', OrderedDict([(u'@id', u'3'), ('#text', u'Basic Access')]))]), OrderedDict([(u'@id', u'55'), (u'name', u'EUTF Add/Edit'), (u'access', OrderedDict([(u'@id', u'3'), ('#text', u'Basic Access')]))])])]) This is what I hope to accomplish and see within the record: Role_ID: 45 ; 55 Role_Name: Claims - Processor (Incela/Hawaii Legacy) ; EUTF Add/Edit This was my last attempt at Jinja which output the value of "No roles assigned": {% if b.json.
Do cross-application relationships break if you transfer an app? I have connected tables grabbing data from another app, I was told I can create a data connection sync, but does it turn into a regular table during the transfer or is it easy as plugging in the data connection?------------------------------DIPA PANCHALL------------------------------
I have a user reporting that they tried saving a record but that it didn't save. "When I hit the "Save and Close" button it did the usual save process (the little yellowish-orange box with "Save" in the middle) and then when it reloaded none of the data was there." I suspect user error (pretty sure they left the form open for days before trying to "save" their work) but they are adamant that it's not user error but an issue with Quickbase itself. Thought I'd post to see if anyone else is getting reports of issues with Saving from their users in case there is an actual QB issue here?------------------------------Emily Keskey------------------------------
I want to create a bar graph that shows users with records assigned to them by day of the week and have the bar chart show days of the week where there are 0 records for that day. I believe I have to do some type of report formula but I can't figure it out. Any help is appreciated. ------------------------------Joshua Case------------------------------
Good afternoon, I am brainstorming how I can assign numerous assets to one mission quickly. The relationships are as follows: Each Mission has many Asset Assignments Each Asset/Service has many Asset Assignments The intermediary table is the asset assignment table. However when we create 15 new assets, we want to be able to assign them to a mission quickly instead of having to create 15 different deployments one at a time. I was trying to use the grid edit mode in the intermediary table (asset asignments) but it is difficult to select each asset. My colleague asked if it was possible to grid edit in the Asset/Service table. He wanted to simply select the mission the asset was assigned to and fill down or copy/paste that mission to each necessary asset. However this takes the intermediary table out of the picture and does not track those deployments on the intermediary table. I was trying to figure out how i could potentially copy and paste the related asset number into the asset assign
Hi, This will be the first time I am hoping to call an external API. So far here is my pipeline but I am running into an authorization credentials not provided. Here is the documentation but I am unable to figure it out: And an example below: Here is the error the pipeline is giving me: how do I provide the authentication credentials? Any help would be incredibly appreciated. Thank you so much!------------------------------Lija Harris------------------------------
On mobile, when you click on an embedded report, it shows you the children in a list. There is no way from this list, to get back to the parent (that I can find). Does anyone have a work around? This seems like a giant oversight, but what is new on mobile. There is the general 'back' button, but this only works if you happen to click into the embedded report and immediately back out. If you then view any child, and return to the embedded report, the back button of course takes you back into the child. My only thought is to make a Return to Parent rich text field and put it in the report, but then it says that on every child and is just ugly, and takes up one of the valuable visible field spots. Is this just another instance of mobile being difficult? Or am I missing some obvious return button?------------------------------Mike Tamoush------------------------------
So, my app has multiple Roles and each Role has a set of Users. I want to create a drop down field which will have choices of Users within a specific Role. How do I achieve that?------------------------------Deepa Prashant------------------------------
It's easy to move rules up/down the rule number chain using the old forms. For the life of me, I can't figure out how to do it using the new forms. Probably something simple that I am overlooking. Also, does anybody know what the 6 little dots are next to the rule #? I hover over it and/or click and nothing happens. Thanks...Aaron ------------------------------Aaron Bab1692@att.com------------------------------
I have two tables currently: Projects and Tasks (the Projects table being the parent). Only one person can be assigned to a project but a project can have multiple tasks. Each task also has an "Assigned To" field. Employees can be assigned to either the parent project or child task or both and not every project has a task. I am trying to calculate a "total duration" across the projects and tasks table. I have a Total Duration field for each project record and a Total Duration field for each task record. I'm trying to figure out how to blend this data so I can calculate this across each team member assigned either a task or project. The following rules would apply: If user is not equal to user in the Assigned To field on the project table and user is equal to user in the Assigned to field on the tasks table, then value = Total Task Duration; If user is equal to user in the Assigned To field on the projects table, then value = Total Project Duration. If user is equal to user
I've searched the community but can't seem to find my answer. We need an icon to pop up when a checkbox is selected. I found this website but it's not really working and I'm using the following formula but that's not working either. Help! QuickBase Support Center - Icon Urls 16x16 If([Requires Supervision]=true,"<img src=https://images.quickbase.com/si/16/221-point_red.png>")------------------------------Vanessa Alexander------------------------------
Good afternoon! I am curious if there would be a way to have an initial search (that searches only phone numbers) on my dashboard and if no results are found, another search option is available? My issue is that reps are not searching by phone initially and duplicate accounts(records) are being made. I realize that I could make phone a unique field, but we do have some instances where there will be duplicates, so I have been holding off on doing that. Or another possibility would be if phone number field could check for duplicates at entry prior to saving the record, but that would mean a lookup field and I do not want to do that. Any advice...direction...is welcome and appreciated. Thanks, Kim ------------------------------Kim Cameron------------------------------
Hi, I have a status in one table and when it changes, I need it to change a status in another table. Is this possible? I cant seem to find a way to see other tables when I set the action in the Quickbase pipeline.------------------------------Ray------------------------------
Not sure which one I need here, or if there is another way of doing this. Have a table with Fire Calls, types are Fire and Ems. I need to show both on a chart, which I have already done. I need a third set of bars that combines these two, Fire and EMS, and shows them. The Excel version screen shot is below, and then my QB version is the next screen shot. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I need an URL to allow me to Add a record, then save it, and then allow me to edit it. When hitting the add record button it creates a form filled out but the users need to add a document then hit a checkbox on a report link. When the users hit save the checkbox from the report link did not go through. They then have to edit the record and hit the checkbox again. This checkbox is in a report link that is to another table. I need it to where they don't have to keep going back to reselect the checkbox. This is the current formula: URLRoot() & "db/" & [_DBID_TABLE_1] & "?a=API_GenAddRecordForm&_fid_8=" & URLEncode ([Field 1]) & "&_fid_22=" & URLEncode("Document") & "&z="------------------------------Ricky WhiteRicky------------------------------
Hi! I recently added a List User field ("Estimator(s)") to my table where the person adding a new Project record can indicate one or more individuals involved in quoting a project. I would like to create a summary report that shows how many projects each person is quoting. I created a Summary Bar Chart showing "Estimator(s)" on the X axis, and # of Projects on the Y Axis. X axis is Grouped by "Equal Values." The problem I am running into is let's say Mark Smith is quoting 10 projects alone, and 6 other projects with various other individuals. It's difficult to see the full volume of Mark's work since now I have 6 other bars on my chart showing Mark's name along with the other person he is quoting with. I would need to scan the report to find his name across all the bars and manually total them. I realize the report is doing what it is told by seeing these combinations as unique values. However, is there a way to show all projects where Mark's name is included in
Hello, I have a summary report where depending on their completion date will get grouped together by the work week they're supposed to be in but im having issues trying to sort them properly since the days are text. They show up like this. I would very much like these sorted from oldest to newest. Any ideas? The choices for the custom sorting didnt really give me a lot ------------------------------Tim D------------------------------
I have a pipeline that is throwing this error and I feel sure that this needs a loop somewhere but I cannot figure out a good way to add the loop as it does not show me a valid target. Is there something more comprehensive on adding loops that what is in the knowledgebase?------------------------------Matt Matt------------------------------
I feel like this has probably been answered and I just don't know the right terminology to use to find it. I maintain 20+ reports that exclude data for a list of specific users. Anytime someone moves and that list of users needs to be updated, it's currently necessary to go into the filter section of all 20+ reports to manually adjust the filters to exclude the new user (each user has their own exclusion filter). There are 15 excluded users and they are in various roles so I cannot use that field to filter. I'm wondering if I can create a new table of the list of excluded users and use that as a filter for all of the reports instead of updating each report separately? Or I'm open to other suggestions. I'm pretty new to QB so I appreciate any help.------------------------------Jeremy Shearouse------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.