Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I understand the EOTI access, role, etc. I have enabled that as an option for our Customer Survey App. I don't necessarily want them to land on a home page, I just want them to see our survey/form. What is the best practice for something like this? ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Please make this work. thank you Case([Task]="PRIME" and [Take/Off Calc - CALCULATION TYPE]="CEILING.HSF",[Take/Off Calc - CEILING CALC HSF],[Task - Task Phase]="Paint.Interior.Item", [Take/Off Calc - NON-STRUCTURAL ITEM COUNT]) ------------------------------BuildPro------------------------------
I'm trying to compare the date created (fid1) to the current time, based on a value in KM Tier (fid1481). The pipeline runs without errors but I'm not sure if this syntax is correct. Does this look correct? This should resolve to TRUE if, for example the KM Tier is 1 and it's more than 24 hours past the date created. {% if (fid1481 == 1 and now > fid1 + hours(24)) or (fid1481 == 2 and now > fid1 + hours(72)) or (fid1481 == 3 and now > fid1 + hours(96)) or (fid1481 == 4 and now > fid1 + hours(240))%} {% endif %}------------------------------Jeff Peterson------------------------------
What is the best way to set this up? QB Notifications, or Outlook Channel? We have a customer sat survey. Would like to, based on department chosen by submitter, send an email to that director. In QB notifications, it looks like I have to create a notification for each department. I was hoping to create one, where i referenced the email address of the Director in that other table. Would Outlook Channel give me this capability, without having to create a separate rule for each Director? Some other way?------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I have a URL formula field that is set to 'display as a button on forms & reports'. Using the new form designer, I try to set the width of this field to 300 pixels on the form. However, the form continues to ignore these width settings so the button takes up the entire width of the column on the form. Has anybody else run into this? Any suggestions?------------------------------Aaron Bab1692@att.com------------------------------
I'm hoping there's something simple I'm missing here. I'm building an app to eventually have users update a record. I'm a newbie when it comes to this, so I have low confidence even in the questions I'm asking. I'm using Ionic Framework to build an Angular app. The issue is this; when I click a button on the app I want to send a payload, in this case it's updating one field with some text, just as a test to get it working. I feel like I'm knocking at the door but it's not opening. When I use API Documentation and test the POST request it works perfectly and I'm able to update the targeted field. But when I trigger the request on the app all I get is error 404: Not Found. I'll be happy to share the code, but first I'd be interested if someone is willing to examine it to see if there's a simple fix that will work, or if it's something that is going to require many programming hours and a hefty fee. If the later is the case then this may not be the correct forum to work this issue out. If
I have 3 table.1. RFP 2. Document Requests 3. Linking TableRelationship is described below.RFP is parent of Document requests and Document Request is parent of Linking table.In my exact Form Document I want to show following. I want the document to be generated at RFP Table. How would I do following.Document Request 1 Linking 1 (info)Linking 2 (info)Linking 3 (info) .....Document Request 2Linking 1 (info)Linking 2 (info)Linking 3 (info) ...------------------------------Amna Anwar------------------------------
I have 10 individual sections with owner information listed (Section - Owner 1, Section - Owner 2, etc). I have a field asking the number of owners and I was attempting to use that inputted answer to hide the extra owner fields (ie. # of Owners = 7, Hide Sections 8, 9, & 10). As soon as I have more than one rule, the earlier rules stop working and only the last will hide the appropriate Sections. All other answers that should trigger the form keep at 10 owner sections listed. Any ideas? Thanks.------------------------------Matt Legowski------------------------------
In my Vehicles app, I want users to be able to see the list of employee names (from the HR app) and select a name for the Driver field. I have two users (me and test user named Tony), both with the administrator role in the HR app. Our permissions in the Vehicles app are different - but the pick list of driver names is coming from HR. So I expect to be able to see the list of names both as myself (I see the list) and testing as Tony (list is blank). I get the same result if I use a specified report for the pick list or the default record picker. Any ideas..?? ------------------------------Samantha Sand------------------------------
I'm trying to create an app for product owners to go through the checklist with a set of questions before releasing the product. A Product form will have a checklist type and there will be a set of questions associated to that checklist. Product table: User enter product details here and the form will have the checklist type to choose from the task table. Pipeline will run and import questions related to that checklist type Checklist table - Checklist name, type, checklist owner.(we have 37 different checklist) Questions table- same Question can be used in multiple checklist(all the questions used in the checklist is added to this repository) Sub questions table- will have sub question details. Template table - To show checklist , questions and sub questions associated with it Task table- Pipeline will run and import questions related to that checklist type from Join table to task tale Please help me with the below questions: How to set dependency between questions ( questions m
Using legacy forms, when a user needs to add a new Make (parent) to a Model record (child) - they click "Create make" at the bottom of the picklist and it opens a pop-up window where they can create and save the new Make and then it automatically returns to the child record so they can continue. This is the behavior I want. But if I use the forms builder - when the user clicks "Create make" at the bottom of the picklist it opens the parent in a new window altogether, and it doesn't return them to the child Model record they were trying to create in the first place. I looked for a setting to control the target behavior but cannot find. Any ideas..? ------------------------------Samantha Sand------------------------------
I am looking to create a button (URL formula) that will save the current record and redirect to a Sharepoint site. I see posts in the community for redirects to another QB location. Is it possible to redirect to an external site? If so, what would that formula look like?------------------------------Colleen Burch------------------------------
I am having an error within a pipeline, I think that is the email of the recipent. the error message is this: "Remote service reported an error: The email address for the recipient is invalid. The recipient Id follows. Recipient Id: 1" I am populating the client email (recipient) with quickbase information. Please if somebody could solve something like this, I need your help. Thanks! ------------------------------Francisco Ojeda------------------------------
I have a multiselect text field that has 20 options in the field currently - If the user selects one of the options marked no, is it possible to make it to where the other 19 options can't be selected?------------------------------LB------------------------------
I have a Pipeline created which should be triggered when a record is created in Incident table in servicenow, but the trigger does not work.------------------------------Hemanth H.------------------------------
thank you for the reply . so I am in the process of creating a supply chain management system that handles the procurement of raw materials, their conversion into furniture, and subsequent sales. The system incorporates an automated budget that dynamically changes based on transactions-increasing during furniture sales and decreasing with raw material purchases. The challenges I'm encountering in the implementation revolve around optimizing the forms in Quickbase. Specifically, I am seeking assistance in ensuring that the forms accurately reflect budget adjustments, effectively track income and expenses, and provide a user-friendly interface, considering the intricacies of managing transactions and budgets in a seamless manner.
Hello! I am trying to make a pipeline that emails an attachment when a new record is created but when I run it I get the following error. "Remote API returned authorization error: 403 FORBIDDEN" Does anyone know why?------------------------------Kirstynn Rowe------------------------------
Looking for some Quickbase formula syntax help: I need this formula to check for multiple RFC Types: Original (checking for one value): ([Project Booking Type]="Proposed" and [Opportunity - RFC Type] ="Contract Renewal") Need (something along these lines to include multiple RFC Types: ([Project Booking Type]="Proposed" and [Opportunity - RFC Type] IN ("Contract Renewal",'"Up-Sell/Cross-Sell") I'll also need a version of this to check for RFC Types NOT IN the values. ------------------------------Chris Green------------------------------
Hello my ladies and gentlemen, I'm Peter, the reason for my comment or question is that I want to create a supply chain management system in Quickbase, but I can't automate the table and I'm also having problems with the pipeline
I have an application that uses a reference field to pull in info from another table and another drop down with different options. Is there a way to make the drop down only display certain options based off what is selected in the reference field? I've looked at the conditional info, but that doesn't seem to apply to only having the field show the options that apply based off what is selected in the reference field. For example if the user picks ABC store then in the line of business field I only what the option 123 to show...------------------------------LB------------------------------
Hi All,I am working on creating an email that is sent out from a company gmail account and would like to use an alias instead of the email that was used to authenticate the gmail channel step. Has anyone figured out how to do this? I have tried entering the alias and other emails in the workspace and it always defaults to the email specified in the connected gmail account. ------------------------------Ryan Dubbink------------------------------
With the removal of javascript, does this mean the use of their native copy master button cannot really be used? I mean, you can create it, but you cant modify it it in any way (even a button color) because you cant save. I like the native one, rather than the api because it lands you on the new record. Does anyone have a good work around?------------------------------Mike Tamoush------------------------------
I'm trying to figure out this expression that would return TRUE If the current day is not sunday but I'm having some trouble with the jinja here. {% if (now | weekday) != 6 %}{#TRUE if The current day is NOT Sunday#}{% endif %} I know that first line is wrong, but I'm not clear on what the correct syntax should be. Anyone have any idea?------------------------------Jeff Peterson------------------------------
I have a Pipeline Search Step that returns an array of records. From that result I need to find the record id# of the one with most recent date field (not Date Created) If my data set was this RID Date 200 15 Jan 24 68 12 Dec 23 8 21 Jan 24 The answer that I am looking for is Record ID# 8 as that record has the highest value for the field Date. If one of the Jinja / Python gurus has some insight it would be gratefully appreciated. ------------------------------Don Larson------------------------------
I have a general reference table for Fiscal Year. (For consistency purposes.) The problem is, the end result is twofold... On a drop down, the oldest years appear first, resulting in a required scroll down to get to the most current year (Would like to reverse this. Newest and future years at the top of the drop down.) In a chart, the chronological order ends up being "reversed". I would like it go left to right, instead of right to left. See attachment. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.