Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Is there a way to enable a notification to email an Outlook DG? I have tried: creating an email formula field with the address using the open permissions making the email a user email field to send as a recipient Adding it directly as a specific user recipient email All these methods worked with an individual email but won't send to a DG.Does QB allow emails to DGs?Thanks for any assistance!Ed------------------------------Ed------------------------------
I'm receiving a .CSV file via the Pipelines 'CSV Handler'. In the second step I'm using 'Iterate over CSV Records'. What I am trying to do is use the csv which looks like this: I want to create a single record in a table called 'Orders' for each order, and then child records in a table called 'Warehouse Requests' for each SKU under an 'Order', which will be used to generate a warehouse pick-list. I'm getting stumped by the first part of this. The pipeline runs and seems to loop over the records but only creates blank records for each row. I haven't even started on the next part which is to generate all of the child records for each SKU.Anyone have any ideas on what I might be doing wrong or if there's a different approach I should consider?------------------------------Jeff Peterson------------------------------
Button needs to show "DONE"THX------------------------------BuildPro------------------------------
I have a multiple choice field with the options '1,2,3,4'. Since Multiple choice is seen as text, for QB, these aren't actually numbers.I have a numerical field, [NumberField].In a pipeline I want to set [Multiple Choice] to [NumberField]. I am trying to set a text multiple choice to a number, and QB doesn't like that. My solution for now is just to create a formula text field with my calculation, ToText the result and use that formula field.Is there a shortcut to do this all in pipelines? I know below isn't right, but it paints the picture of what I want.Set [Multiple Choice] to: ToText{{a.NumberField}}------------------------------Mike Tamoush------------------------------
Hi all,We are taking some input from users as plain text. I'd like to use a formula rich text to style it up a bit.However, concatenating plain text into HTML requires replacing angle brackets < and > with &lt; and &gt; and ampersands & with &amp;.I can do this myself with multiple calls to SearchAndReplace. However I was wondering if Quickbase would consider providing a function called "Escape" that would handle all of this in one go.It would be especially great if links and email addresses could automatically become <a> tags, the way they do when you look at a plain text field normally. When concatenating these into the rich text, they don't automatically parse as links.Has anybody else dealt with this?Thanks.
Hello!I have a simple app with 4 tables containing information regarding documents. One of the fields on the form for each table is the date the document was implemented. How can I potentially highlight the record for a specific document to red/yellow if it has been over 1 year since the implementation date. I would like to do this without having to create relationships or additional tables. Is it feasible? If so, what's the best way to achieve this? Thanks for the help!------------------------------Karan Joshi------------------------------
Hello - I need to change the date on a time card submittal. I submitted time worked for last week on this Monday and the system processed it for this week.
How do display every record selected on the dropdown without erasing the previous, basically I wanna select as many item from the drop down and have them display on the stock item.------------------------------Boitumelo Segaole------------------------------
Any thoughts of how to add 3 months to a date, but if it lands on a saturday or sunday, bounce forward to the monday, or bounce back to the friday? My initial thought is to add the 3 months, check DayofWeek, then add or subtract a day if needed. Is there a better way?------------------------------Mike Tamoush------------------------------
Hi! I've recently been assigned as an admin for quickbase and have some question regarding a project I have been assigned. We have an ordering app that includes separate tables for vendors, internal requisitions, items, and inventory. I need to add an "order division field" to the internal requisition and each division will be associated with a list of product types. The product type will be in the "items" form. There is a relationship between: Each Vendor can have many internal requisitions Each Internal requisitions can have many item entries Each Internal requisition can have many inventory entries What I need to do is - When adding items to the internal requisition I would like to be able to only see product types associated with e.g. division A if the internal requisition the item is being added to is under division A. If division is B then only show product types for B. What is the best way to accomplish this? Do I need to create a separate table to associate divisions wit
This works...If(ToText([Job - Related Sub Payroll22 - 2nd COAT (DAY 1) DATE])<ToText(Today()),"<img src=\"https://images.quickbase.com/si/24/221-point_red.png\" title=\"DONE\">","<img src=\"https://images.quickbase.com/si/24/222-point_green.png\" title=\"TO DO\">")AND, I need to add:If(ToText([Job - Related Sub Payroll22 - 2nd COAT (DAY 1) DATE]) is blank,"<img src=\"https://images.quickbase.com/si/24/223-point_yellow.png\" title=\"ALERT\">"------------------------------BuildPro------------------------------
Hi, I'm not sure if this is possible or not. I have a home page that has a search widget. The Search widget is set to filter a report view for a list of employees. If the Employee name is exact - it will load the record instead of the report view. is there any way to set the search widget to load the report view only and not the employee record?Thank you------------------------------Amber Anderson------------------------------
Hi - I need to have the date changed on a Time Card - how can I do that? I submitted it on Monday of this week and the system assigned it for this week but the dates should be for last week.
I've read that color coding is not available in 'summary reports'. Is this still true?Is there another way to display a 'red yellow green' status by row on a summary report? For example:Column 1 = Year to Date Actual ValuesColumn 2 = Year to Date Expected ValuesIf column 2 > column 1, then "<img src=\"https://images.quickbase.com/si/16/221-point_red.png\"If column 2 < column 1, then "<img src=\"https://images.quickbase.com/si/16/222-point_green.png\"------------------------------JG999------------------------------
As of August 1, 2022 Quickbase is using a new customer billing portal for viewing payment history and managing payment methods. This change will have an impact to our customers paying with a credit card. As part of this change, we want to ensure all credit card information transfers are done as securely as possible. The most secure way to do this is to have you add your information to the new billing portal. Accessing the Payment Portal To access the billing portal from Quickbase: Login to your Quickbase account Go to the Account Summary page. This can be done from the My Apps page by clicking “Manage my account”. From the Account Summary page, click the “Manage Billing” button in the top right-hand You will be redirected to the Billing Portal, where you can view information about your account, or manage your payment method Adding a new Credit Card For your first-time use, you will need to add your credit card information. To do this,
How do I add an Excel template to a tab within an app?------------------------------Carol WoolmanA------------------------------
Hi Everyone,I wanted to set a notification which needs to act as a reminder. This should be generated 5 days before the meeting date only if there are some missing fields in the form and need to generate reminder( 4, 3, 2, 1 days) everyday until user adds data for the missing fields. I'm not sure how do I auto generate this notification each day until form is complete. Because in the notification settings, this will be generated only if that record was modified/ added.. etc. I do not want to directly create it as reminder since reminder has limited features. Need to add some fields in the email body and do not wanted to send a default table that reminder adds.------------------------------Mrunali Kadam------------------------------
Hello, We have one app that we use multiple instances of. Frequently we need a new copy for a new project. However the functionality highly depends on multiple pipelines. We only use pipelines to reference tables within the given database. Is there any way to copy the app and the pipelines? Thanks, Tara------------------------------Tara Stroup------------------------------
Hi, I have a multi-select text field : [ERP Products]I'm trying to have a Formula - Numeric field, to count the number of products that were selected. I have tried something like this: var Numeric ERPCounter = List(",",ToText[ERP Products])); // to get the text list of the products, then have a "," delimited, so that the next (Count) function would work.Then used: Count($ERPCounter) That doesn't seem to be working. Trying to find a way to count those products. Any ideas?Thanks!
Hi Everyone,I was trying to add summary report with filters on the dashboard but it doesn't bring filters to the dashboard and only show the entire report. Is there a way I can add filters?Can I create a chart or graph on the summary report? since it is a big report with 23+ records and don't see any option to add filters on the dashboard so these graphs would help users to get quick insights. Thanks in advance!------------------------------Mrunali Kadam------------------------------
Admin rights have been dumped on me and I have no idea how to update a drop-down list.I need to update this drop down by eliminating some options and updating others.------------------------------Carol WoolmanA------------------------------
We have 30+ roles in one of our QB Database applications. Because we are short-staffed, I need to give some people two different roles. How do I do this?I actually switched this person to the same role as someone who creates our I/O's but it didn't change what they see. There's no green Insertion Order button to create an I/O and that person has the same access as the person who does the I/O's. What do I have to do to give someone access so they see everything (green I/O button) that someone else with the same access has?------------------------------Carol WoolmanA------------------------------
Hi,I've noticed that some users in my apps have the status "denied". I'm just wondering what this means and how could a user gain this status?Thanks------------------------------Inas------------------------------
Hello,I am working on a project for my company, we are pushing NOTE_TXT data into a QB table to be read by our customers as part of a larger application. We're still developing right now. I am not the QB developer here, I am responsible for the data.It was discovered that we are going to surpass the 500mb limit on the table very quickly. The data we want to send in is already as lean as we can make it, the only thing I can think of to make it leaner is to either remove records, or truncating NOTE_TXT fields. Questions1. Can the 500mb limit be increased? Is that limit an arbitrary cap set by whatever plan my company purchased from Quickbase...or is it a physical limitation of the storage mechanism used by Quickbase?2. Can multiple physical tables be joined together into a single virtual table? 3. Can multiple tables containing the same type of data be addressed by Quickbase? Say, I create tables NOTE_1, NOTE_2...NOTE_n, and have something like an intermediate NOTE_LOOKUP tabl
Hey everyone,This is my first post on the community. I just wanted to get other users opinions on the exams. I've been struggling to get my certifications due to failing. I failed previous attempts at a practice exam for the builder certification, and just finished attempting my combined exam for the builder and expert certifications. I got 60% (failed). I've gone through all the modules in University over the past month as well as watched and studied Webinars and Empower videos provided. I'm feeling a bit stuck here as I've noticed being asked questions that are for things that were never taught in the University Training. Ex: Snapshots. I'm pretty discouraged on the quickbase training and unfortunately I need to get the certifications for my current position.Just wanted to see if anyone else has had the same experiences or has any tips for finally being able to pass the exams. What's odd to me is that I have a programming background, and this stuff seems easy, but the questions
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.