Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
HelloHow do i create a unique import ID for the following situation:Have an app that needs to aggregate information with two different types of entrySome teams have existing QuickBase Apps and a table to table import (Table A to Table B) is needed and some teams will directly enter information into the table (Table B). I attempted to create an unique identifier in Table B by aggregating two fields - State and Event Name. I wanted to use record ID instead but it did not seem to work on new records being added.Lashell------------------------------Lashell Thomas------------------------------
Hi all,I've created a report and included a couple fields to use as dynamic filters:1. ID Setup Complete - formula checkbox2. Store - Province - lookup from the stores table3. Store Position/Role - Text multiple choice1 and 2 are working fine, but when I filter on 3, I get no results. I've discovered that the issue is with special characters. The values in this field are "Dealer / Propriétaire" and "Store Staff / Employée de Magasin".I changed the values to "DEALER PROPRIETAIRE" and "STORE STAFF EMPLOYEE DE MAGASIN" and now the filter is working.Problem is, this looks not too great for our bilingual users as it doesn't really differentiate between the English and French.Does anyone have any ideas on a workaround for this?Thanks in advance!Kim------------------------------Kim------------------------------
I am attempting to make a field be required based on another fields value. IE: If the Field 1 = value of 1 , then Field 2 (date) is required , but if Field 1 value is 0 then field 2 (date) it is not required?------------------------------Scott Hunter------------------------------
I am attempting to copy data from an Excel file and past it into the Grid Edit report. I know you can manually click each field and edit data in the grid edit, but I thought at one point, you could paste by "filling down."I am beginning to think my only option is to import the .CSV file. However, I have had horrible luck with doing this as the fields never seem to match once imported. Please help me!
Is there a way to determine how much overall data is used in a field in a table. I have some formula RTF fields that may be consuming a great deal of memory in one of my tables. I am considering moving those fields to their own table and replacing them with a summary field. Or would the Summary Field take the use the same amount of data?------------------------------Paul Peterson------------------------------
It shure would be nice to show the fids for reference.I was going to put up a My Feedback but it's down.I have submitted a ticket to QB Support.------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Can anyone else confirm for me.Go to My Apps pageClick My Feedbacksidebar starts to load...and then it's gone. I have submitted a ticket to QB Support.TIA------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
HelloTo explain this, say there are four columns as below. In order to avoid entry of duplicates, I concatenated Customer and Sub ID and made it unique. Customer Sub ID Sales Key 10001 A1 $100 10001A1 10001 A2 $100 10001A2 10002 A3 $100 10002A3 10002 A2 $100 10002A2 10002 A1 $100 10002A1 Now, if I upload a CSV file to update sales for Cusomer: 10002 & sub id's A1& A2, QB rejects as duplicate records. Question: If I don't make it(customer & sub id) key, the table will get duplicate records. If I allow it, QB by default will not allow updates of sales for the key. How can I overcome this challenge?------------------------------Siva------------------------------
Hello All! I am new to Quickbase and I am having trouble finding out how to code. I need to make a report that tracks all employees and how long they have worked at my company. I have the basic information, (I.e. Start date, employee, etc.) but I was wondering of there would be an easier way to automatically calculate how long the employee has worked from when they were hired until the present date. I also need to find out how to code those times in to different sections (green= 0-1 years, blue= 1-5, etc) so I can graph that info. If anyone has any suggestions or can point me in the right direction to go that would be amazing! Thanks
Hi, I'm using the Copy Master Details button. I'm stuck on how to get this functionality: 1. User clicks button2. User goes to new record3. If the user tries to save the new record without changing the text field that is used in the Copy button, a data validation rule would prevent them from saving. I can't do this because I can't have a unique field and have the copy master detail button work. I thought there was a work around with the custom table rules but can't figure it out.How can I use Copy Master Detail wizard and prevent the user from saving the new record with the same name as the copied record?Thanks community.------------------------------Raymond Sakar------------------------------
Hi everyone,I've also opened this as a ticket with QB Support, but I'm wondering if anyone has had a similar experience?In November, I created a series of EOTI Forms that have a custom 'Submit' button in a Formula URL Field.It was my understanding that when the form settings are set to 'Auto Save' when redirected away from the page - that the results are submitted when redirected to a Thank you page.We tested every form in November, and they all worked and data was submitted successfully. Our team emailed the 'forms' individually to specific guests we needed feedback from - and not a single one of their replies was recorded. We tested it again internally yesterday, and none of the replies were recorded.My Submit code does do the redirect properly - tested it yesterday and it successfully redirects to the Thank You page; but the data is NOT submitted or saved to my form.Panicking a bit here - as this is urgent for our organization and I'm not understanding what's changed or
I am not super well versed in code pages but am wondering if anyone had any experience using them to make radio buttons display horizontally? I looked around previous forum posts and they had suggested using the following Javascript in a rich text formula field. However, Javascript is no longer supported in formula fields. Is there a way to create a code page that contains this and direct specific forms to that code page so the radio buttons display horizontally when adding, editing, and viewing a form?"<img src=\"/i/clear2x2.gif\" " &"onload=\"javascript:if(typeof QBU=='undefined'){QBU={};setTimeout(function(){" & "$('.RadioButtons br').remove();" &"$('.RadioButtons label.NoneOfTheAbove').remove();" &"$('.RadioButtons label').css('margin-right', '25px')" &"}, 500)}\">"------------------------------Marcela Corro------------------------------
I've got a report that I need to have the totals of certain rows calculated. I need totals for all "EST" budgets, "ERP" budgets, etc. Is there a way to do this within the report? Here's my report: ------------------------------Bethany Hudson------------------------------
Hello,I have a currency formula field that is subtracting a number of costs from a commission owed to a sales rep. The number tends to come up negative from time to time.I would like 1 of 2 options to support our math:1) Set up the currency formula field so it cannot be a number below 0.2) Create an additional field that will reflect the number shown in the currency formula field if it's above 0, and if it's less than 0 or a negative number, it will keep itself at 0In regards to option 2, I've attempted to use rules for that to occur but once the 'Project Cost' is created with the related information from another table, it will not 'fire a change' if it changes after it's been created.Thank You so much for your support.------------------------------Anthony Wong------------------------------
Has anyone used a date filter on the new dashboards? Near as I can tell, their preset ranges do not work. For example if you select 'previous year', no records show. Even if you select 'Custom Range' but manually type in 1-1-21 to 12-31-21, it does not work.However, if you use custom range "1-2-21 to 12-30-21" (just choose any range that doesnt also equal a preset range) it works exactly as expected.Has anyone else experienced this behavior?Update: This big major bug may just be Operator Error....doh.------------------------------Mike Tamoush------------------------------
Is it possible to send test subscription emails? If so, how would you go about doing it?Thanks in advance------------------------------Quickbase Pipelines------------------------------
Hi Everyone,I'm trying to find a way to relate a parent and child through a pipeline, after first ranking the parents, and then determining if the child meets certain criteria. The parent is a record of a call recording. The child is an independent contractor's schedule which includes their capacity in audio minutes for that scheduled period to complete a transcript of the recording. I've already written the formula field in the child to determine remaining capacity, now I'm trying to figure out how to get the pipeline to work.It's going to be a scheduled pipeline instead of being triggered by a new call record created because some calls are higher priority than others. There's also a priority formula in the parent table. Having the pipeline run on a schedule allows for the instance where record 1 and record 2 are created in close proximity to each other, but record 2 is a higher priority than record 1 and thus needs priority in the assignment.My initial thought is to start with a reco
Here's my setup of tables, apps and their relationships: Drivers (App 1) Driver Status (App 2) Departure Schedule (App 3) Relationships: App 1 - Many Drivers belong to one Driver Status App 2 - Many Driver statuses belong to one Driver - to provide a lookup field record picker of the Driver status for a Driver record. App 3 - Many Departure Schedule records belong to one Driver Status. In the driver record I select the driver status that comes from the "Driver Status (App 2)" table. Then in the departure record (App 3) I select the driver. Once the driver is selected in the departure record I need to have the driver status that's relative to this driver to be automatically displayed as a read-only field (no record picker), but it comes up blank. I've set up cross-app relationships between the apps with Viewer permissions, but beyond this I don't know what else I can do.------------------------------Serge Mozgalevsky------------------------------
Has anyone else run into issue sending to multiple users using the MailTo Command? When sending to multiple recipients, I had typically used a semicolon to separate recipients.It seems to function differently depending on the email client and device. For example:Desktop: Outlook seems to work fine when using semicolons. There may be spaces after each semi colon or not. Using commas to separate does not work.Mobile with gmail:Android seems to work fine with semi-colonsiOS works with commas but not semi colonsMobile with outlook:Android: untestediOS: Seems to work with semicolons only if there is a space after the semicolon, and even then it says the emails are invalid, however will send the email and it will go through.Using commas on iOS mobile is untested.Does anyone have a better understanding of this? Or perhaps any tricks of how to send to multiple recipients and have it work no matter the device and email client?------------------------------Mike Tamoush--------------------------
HelloI have two parent tables - projects and organizations. I created a many to many relationship through a joiner table - collaborations. How can I require at least one entry into the joiner table from the "projects" table.I consider using a multi-select text field instead and use the values from the project table, but i need the ability to pull in other information from the organization table.ThanksLashell------------------------------Lashell Thomas------------------------------
Can anyone help with the following color-coding formula? I couldn't find an example in the help guide of different types of fields in one formula.The first field is multiple choice and I only want to color code one of the three choices, otherwise, no color. The next three fields are checkboxes and I want to color code if true, otherwise, no color.I am getting an error only on the closing parentheses that says "expecting text but found bool". We would prefer to color code the entire record row for easy identification, which is why I am trying to do this from the Default report settings, but if there is another way, I would be glad to know it.Thanks! Case([Multiple Choice Field], "Option2", "#f0f0f0",[Checkbox Field 1], "true", "#dbfffd",[Checkbox Field 2], "true", "#ffebbf",[Checkbox Field 3], "true", "#ffffbf",)------------------------------Ashley Gwozdz------------------------------
Does anyone know a developer who can help us find the break in our code between quickbase and A.net? I cant find help anywhere and we are willing to pay for it. Long story short, we got a new token from A.net because we were setting up additional subscription software. We were unaware A.net generated a new token each time making all past tokens obsolete. Now we cant find how to fix it and quickbase has been 0 help to us. Can anyone provide us with a builder's contact for help? We are wasting so much time I cant take it anymore. Thank you in advance!------------------------------Justin Bucki------------------------------
Hi All,My team is looking to add a Quickbase guru to help build solutions that help our staff help our customers. Is there an appropriate place within Quickbase University or Quickbase in general where I can post a link to the posting for this opportunity?Thanks,TC------------------------------Thomas Cupit------------------------------
Is there any new logic to get a emailed report subscription to email at a specific time recurring or trigger off a record update like a notification?------------------------------Alycn Bjergo-Justen------------------------------
Happy New Year!I am trying to find the format bar to add to my tables but I can't find it. I also can't find anything about it in the QB videos. Thanks, Stacey------------------------------Stacey Renna------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.