Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello,I recently submitted a question here regarding creating a new record with values copied over from the original (by using formulas instead of the native QB copy functionality). (question linked here if needed)After some more testing I noticed the formula fails on certain characters. Below is my current formula. For example if [Problem Statement] is...Build X provisioning work flow from X to downstream systems, building on the capabilities from 1234 ABC (X) (ABCD-e) (QB# 1234)...The formula will copy all fields ABOVE [Problem Statement] in the formula, it will only copy over the text within [Problem Statement] up until the "#' symbol, and then none of the other fields in the formula are copied over. I have also seen the same happen with "&".How can i structure my formula so it does not fail once it reaches certain characters?URLRoot() & "db/" & [_DBID_INTAKE] & "?a=API_GenAddRecordForm"& "&_fid_8=" & [Initiative Type] & "&_fid_7=" & [Re
I CANNOT figure this out, after google, quickbase community, and quickbase support, I cannot seem to figure out how to get the embedded report of my choice to show up in my exact form. I was not authorized to pay for an additional subscription per my company. PLEASE help me. I am a novice at this area of QuickBase. This is what quickbase gives you, and no matter how many times I fiddle with it, nothing shows up! ~=qdb.GetURL("DetailsTableDBID", "API_GenResultsTable^query={'DetailsFieldID'.EX.'"+ field["MasterSourceField"]+"'}^options=nvw.ned.phd.nfg.sortorder-A.groupby-V^slist=DetailsGroupFieldID^ts="+ new Date().getTime());~------------------------------Newman, Savi------------------------------
I have a user that is experiencing an issue that seems to have started when QB released the new Table Reports on 8/1 (Our instance starts with D so in the first group). I have created a support case for this as well, but I know how hard it is to troubleshoot when you can't duplicate the issue. When the user tries to apply a filter to any report, the screen goes blank. I have had it come back with no results, but column headings are still visible. The users whole screen goes blank. I have attached print screens. I have tried clearing browser history and using a different browser (happens with both Chrome and Edge). Is anyone else experiencing this issue? If so what have you tried?------------------------------Julie Meeker------------------------------
I am trying to assign a certain role the ability to edit certain fields. I've checked the advanced tab on the specific table and have verified the users only have this role assigned, however despite this the role and the users still have the ability to edit fields. How is this possible?? How do I fix this??------------------------------Ariel Combs------------------------------
Hello,One of our team members is using the QuickBase app to scan in QR codes.Until recently they have had no trouble clicking on a selected field and having the Bar Code icon appear.This week the Bar Code icon appears but disappears before they can select it.It maybe disappearing behind their vitrual keyboard. Has anyone else experienced this?Is there a way around this? Thanks!------------------------------Carmelina Macario------------------------------
I am trying to figure out a good way to simplify user searching for client headquarter locations. I currently have an open text field allowing users to enter HQ location, however this allows a lot of discrepancies in the way users are entering data. One example of this could be entering data for Kansas City could look like this: KCMO Kansas City, Missouri Kansas City, MO Kansas City I don't want to have an entire address field because we don't need it and it takes up too much space on my form. One solution I thought about was to create a multiple choice field populated with most major cities and states our clients reside in, but allowing users the option of adding choices so we would at least have some consistency in formatting but I wanted to throw the idea out to the community and see if anyone else had run into/solved this problem as well. Thanks,Jen------------------------------Jen Black------------------------------
Does anyone have experience linking Smartsheets to QuickBase? This would include bad experiences if you're willing to share.There are probably a variety of ways to do so. The API is the one I'm aware of.Also curious if anyone has had experiencing integrating Asana or Monday.com. I see there is a pipeline for Monday.com so also curious if anyone has gone that route. Sorry if this question is a bit open ended. I'm evaluating PM software for several teams with different use cases, so really, any info is useful.Thanks!------------------------------Jake------------------------------
Is what I have below possible to accomplish in QuickBase? If so, what steps should I take to accomplish this?Anytime an assignment gets scored in QuickBase, it pulls each individual's assignment score, cached date, score, attempt, and a lot of other data (from a gradebook sync). Name Assignment group Assignment Name Cached Date Score Attempt Name1 A (1)- 9/12/2022 9/13/2022 0 1 Name1 A (1)- 9/12/2022 9/20/2022 0 2 Name1 A (1)- 9/12/2022 9/21/2022 1 3 Name1 A (2)-9/19/2022 9/25/2022 1 1 Name2 A (1)- 9/12/2022 9/13/2022 0 1 Name2 A (2)-9/19/2022 9/25/2022 1 1 Name2 A (1)-9/12/2022 9/20/2022 0 2 Ideally: anytime someone's assignment gets graded (and it's a group A assignment): A new row would be added to the below table (assignment name) There could be a field that calculates that individual's maximum assignment score Name Assignment Name Max Score Name1 (1
In the App I am working on there are 3 tabbed sections that an outside user fills out and "submits". On a fourth "Internal" tab my clients have several steps that they take internally using the info filled out in the first 3 tabs. My client is asking that those first 3 tabs be locked for editing by internal users during certain points. I know I can lock edit access to the entire form easy enough, but to break it into parts, the only way that I know of would be to create a dynamic form rule listing what would be 100 fields in those first 3 tabs as read-only when in a certain status or when a certain user is working on it. Is there a better way to do this?------------------------------Chris Swirtz------------------------------
Hello, First Time Poser here. We're working to build a priority review rhythm that pulls in some view of our capacity plan as it relates to active projects. We already building up schedule timelines from a project management perspective, but this view is something leadership has requested.To drive this, I am trying to build the report below in Quickbase, but cannot find a way to add the series name(Project X) to display inside of the BAR. Using the Stacked Bar Chart, I can create the basic data picture, but it's more readable for the team if I can include the project name directly in the bars. Any ideas on how I can get this report onto a dashboard?Thanks!Jonathan------------------------------Jonathan Lewit------------------------------
Is there a native way (Perhaps with pipelines?) to extract data from an Excel file that is uploaded to a file attachment field?I know that Juiced has an add-on for this, which I may use, but if there is a new native way, I always prefer to keep things native.Maybe this has been addressed before but I can't seem to find any community postings on the subject.------------------------------Mike Tamoush------------------------------
I'm trying to set up a notification to go to a group of people (in multiple different roles). But rather than type in their email addresses manually, I want a way to keep the list dynamic, so as the list of users in these particular roles changes, the notification will always go to the correct, most up to date list of users I want to send it to. So this notification would go to "the user(s) listed in this field.I have a team members table with a checkbox field called Coordinators (fid 63). This checkbox is used for a handful of purposes, and I want to use it to send a notification (from a different table called Requests) to the employees who have that box checked. I have the following formula in a formula list user field, but it's throwing an error, saying "expecting user/userlist but found textlist." I've tried wrapping it in various UserToEmail/userlistToEmail functions etc. but nothing seems to work. If the formula query is returning fid 13, my email field on the team member table,
I have a pipeline that is triggered via a webhook. That is, when I call a URL like "www.pipelines.quickbase.com/hooks/webhooks/XXXXXX" it runs the pipeline. The issue is that I am calling this via a popup window and when it runs the window remains completely blank so the user has no idea if something is happening. I can write some html/javascript to print something out and call the webhook but I need a way to return a response object or something like that when the pipeline is finished so that I can display "all done" or something like that to the user. Is there any way to do this?------------------------------Andrew Patricio------------------------------
Howdy, I have a table of Zooms that I add notes to, and for the Zoom group I'm in. When I click on my App Table for the Zoom videos, the URL field is nice and small in width. Perfect!Now I decided to make a report and added this report Widget to the dashboard for myself & the group, and it shows the Zooms & notes. BUT I can't get the URL field to shrink in size, just on the dashboard. Is there a way I can do this? I do like that when I use a report I get an update icon to the left, that lets me know that someone submitted an update.------------------------------Bob T.------------------------------
Introduction I am pleased to introduce a significant tool that we are releasing in Quickbase called Performance Insights. This will help builders of Quickbase apps diagnose and resolve performance hotspots within minutes, without getting a PhD in software architecture. I want to share why this is such a big deal and the describe the unique challenges that we face at Quickbase when it comes to performance. What makes Quickbase special? I joined Quickbase more than 20 years ago as an early engineer. Over the course of those twenty years, I've had the great opportunity to work on many of the core features. Even after all that time, I'm constantly amazed by the vision of the Quickbase founders. You can hear more from the founders, who I was lucky to have worked with, towards the end of this keynote presentation. Their vision was both bold and simple – let anyone (not just computer scientists) build applications of any level of complexity without writing code. The software will do all the h
I have some questions about pulling in the most recent data from another table to a status field. Here is the loom video------------------------------Jennifer Meyer------------------------------
I am wondering if there is any way when I add a user to one of my apps, that if that user is in a certain role, that they can be added automatically to a user field that has a custom user list?Or can a user field with a custom user list pull based on the user role?This would save me a headache since I tend to forget to add them to the user fields.------------------------------Carol Mcconnell------------------------------
Is it possible to perform actions such as save a snapshot of records within a linked report that are checked (selected)?For instance, I'd like to save all of the Document Name(s) selected within the linked report to another field (Schedules) like a snapshot.There is a realtionship of Parent/Child but one Parent could have 1 Child record or it could have 15 Child records. But I only want to capture the Document Names of those records actually selected with a checkbox value in the report.------------------------------Robin Mcintosh------------------------------
Is there a formula--similar to ToText(UserRoles("Name")) to display a user's role on a form when a user is selected from a drop down? ------------------------------Charlene Dougall------------------------------
Hi friends!I am trying to convert a timestamp over to a Date/Time field and am failing miserably. I have a text string that am I am extracting elements from using multiple formula fields, one of which is the intended Date/Time field. I have all the other text fields working just fine but can't get the formatting right on the Date/Time.A snippet of the text I receive is: {"owner":"frank@example.com","leadsource":"leadballer","time":"2022-08-11T13:18:08+00:00","type":"InvitationAccepted", ... I can easily get that converted to text via a Formula-Text field and the formula:var number start = Find([Original JSON], "\"time\":\"");var number end = Find([Original JSON], "\",\"type\"");var number startlength = Length("\"time\":\"");Mid([Original JSON], $start+$startlength,$end-$start-$startlength)However, when I change over to a Formula-DateTime field and try to use ToTimestamp or other type conversions, it fails and I get a blank result. Any suggestions on how t
Hello all,Just curious on if anyone has a direction about using Quickbase as the data store and connecting it to excel.Ive seen QuNect and thought about giving that a try. Also was curious if this could be done through pipelines ODBC.Thank you for all your help!------------------------------Griffin Starr------------------------------
I just want to make sure, before doing this, that I can change a FIELD NAME and that it will update throughout my App. 1. The change will not "break" formulas?2. The change will have NO adverse effects on anything?3. I am aware that if the FIELD NAME is used in a PIPELINE, the pipeline will break - I am not concerned about this.Thank you------------------------------BuildPro------------------------------
I have a proposal review system that is set to notify people when the status changes on the proposal to flag them it is ready for their review.....However, I want to also send an email if the comments area changes (i.e. someone asks a question). but, unless I am missing something, I cannot use a text multi-line (with logging) field as a trigger for additional criteria in a notification?Any ideas how to get around this? I had it on a blanket when modified setting and it was firing off WAY too many emails quickly.------------------------------Ivan Weiss------------------------------
How would I check to see if a field has the same value in the same field in other records after clicking Save and Close? Can a pop up show saying the field on this record is a duplicate to the field on a different record? Also, check only if a checkbox is not checked? If the checkbox is checked don't check at all.ThanksBrian------------------------------Brian Dunk------------------------------
Hi, I added the values of a field in a summary table.Now I need to compare that summarized total number to another number in another table...How do I make a report and do this formula?Thanks.------------------------------Joe Blouin------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.