Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a header on my form that will show my process user. I have 8 fields for process user, but I would like the one with the lead team checkbox checked as the one that shows up in the header. I think this is doable by a formula, but I am not sure how to write the formula. Any assistance would be greatly appreciated. ------------------------------Kari Lang------------------------------
Hello, I have a date field for users to input a date of birth, but I'm wanting to know if there is a way to make the field not have the date be a future date or entered in a incorrect format? For example, 12/20/2023 or 05/32/0210? Thanks, LB------------------------------LB------------------------------
I have a relationship between team member and compensation. It tracks all of the compensation offers to each of my employees. I have a payroll report on the team members table that runs every tuesday showing me everyones payroll to confirm with our payroll service. How do I ensure that it only returns the most recent create date record on that report? Right now it is showing me the highest salary. For some reasons some of the ownership reduced salaries so on the report I want to get the most recent date created compensation record, not the highest salary------------------------------Ivan Weiss------------------------------
Hi All, Has anyone used the CASE function based on a range of a value, is not working the syntax for me... see below what I need in general... CASE([AGE], <=12,"Child" > 13 AND <=19,"Teen" >19 AND <=21, "Young Adult" >21 "Adult" ) Thanks in advance... ------------------------------Miguel Francis------------------------------
I've done a number of webhooks successfully and never run into this issue. I am using the format below, to allow for grid editing and multiple record changes. I keep getting error 30, which QB says is there is no such record in the table that matches the ID. However, I am matching the record ID to itself, so it should be impossible for the record id not to exist. Can anyone spot the issue? Why is it telling me there is no record? <qdbapi><udata>mydata</udata><usertoken>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</usertoken><apptoken>xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx</apptoken><records_csv><![CDATA[%RepeatOn%[Record ID#],[Weekly Report Key Formula], %RepeatOff%]]></records_csv><clist>3.23</clist></qdbapi>------------------------------Mike Tamoush------------------------------
Hi, I have a spreadsheet from another database I need to import into Quickbase on a recurring basis & need help coming up with the right steps/ if logic. Spreadsheet contains a unique ID from the other DB, as well as a unique ID from a soon to be parent record already in QB. The majority of the records will have a 1:1 parent-child relationship, in which case it's easy to import the records & use the existing QB ID to create the parent-child relationship. However, there will be some records (roughly 5-10% of my spreadsheet) that contain matching soon-to-be QB parent RIDs. In these instances, there will usually be 2 records with matching RIDs but could be as many as 4 or 5 I believe. In this situation, I need a couple things to happen: All records containing matching parent RIDs should be associated to the existing parent, AND of those records, I want to find the record with the highest numerical "other database unique ID" & create a new parent record for it. Thi
Hello, I'm wanting to add an API button in a child table that would add a parent record and also add the parent record id to the related field in the child record. Basically the same thing that adding a record from a record picker does but pre-populate fields in the parent record. Is this possible?Thanks in advance for any advice!------------------------------Sam Rettig------------------------------
I am new to Quickbase and have been tasked with making some changes to one of the apps. I tried to copy the app completely but, it was too large and was not an option. I then copied the app without the data and it worked. Now, I am in need of connecting the data rather exporting from one and importing to the copied app. Is this possible and if so how? Also, if it is possible, will users of the New App be able to enter data on it and not effect the old? I am unfamiliar with tokens and api requests in QB so any help/guidance would be greatly appreciated ------------------------------John B------------------------------
I'm trying to import a YAML. But this shows a validation error. I'm not sure how to resolve this. Can anyone help me with this? ------------------------------Prakash Murali------------------------------
Hello, I have two tables that use API_edit to update records. One of them works like a charm and I can see that the table has been updated daily irrespective of a change in data. This table that works well has fields which are all populated with data. That is every field has a data element. The other table that runs without error as shown below: <?xml version="1.0" ?><qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>459</rid> <num_fields_changed>0</num_fields_changed> <update_id>1699466034771</update_id></qdbapi> does not update the table. Zero fields were changed. This table has fields that may or may not hold data for that record. There is no other difference that I have been able to discern between the two tables. I would like to see this table also show an update date even
I don't know why this is so confusing to me but for now it is! In this help article:How to add Cascading Dropdowns – Quickbase HelpYou can add a 3rd conditional field. Can you add more than that? If i wanted to add a 4th or 5th? Is that possible in the same way you add the 3rd field or is it different?------------------------------Renee Hansen------------------------------
I'm having difficulty developing a formula text field that displays a Status on a coming up report that are due. Currently the reports could be due Monthly, Quarterly, or Annuel. I have the following field to collect information: Reporting Monthly Start Date, Reporting Quarterly Start Date, Reporting Yearly Start Date, Reporting Submitted Date. The Submitted Date field idea is to track the date which the report was submitted. The other start dates would be the starting due date of the report, if they are due monthly, quarterly, or annual. The idea is to have the Status be displayed on a QuickBase report showing "Soon Due" or "Due" when a certain duration is met from the next due date. Such as if due Monthly, then Status would be "Soon Due" 14 days before next due date and all the way till the due date status, "Due" which would be on the day before it is due for a 1 day buffer. This would be cleared if the Reporting Submitted Date field clears and the report is current. Any
I have an app that tracks employee accommodations and there are about 650 units. I am trying to figure out the units availability over a range of dates I know when the unit is occupied because I have a "reservation" record with a start and end date. So I'm trying to report when there is not a reservation. The reservations are not necessarily back to back so say within the month I need to show the available days. Any ideas on how to report on what's not there? ------------------------------Julie Meeker------------------------------
Has anyone developed in all 3 platforms? Can anyone give insight on the where they fall short of QB, or perhaps any advantages? I love working in QB, but was recently asked why not just Smartsheet or Powerapps. I didn't have an answer, since I have never used them!------------------------------Mike Tamoush------------------------------
In short, I need to know which reports are run, when, from which table and by whom. I thought a Pipeline event would work but a report run doesn't seem to be a recognizable Event. Is there a way to know what reports are being run? I have lots of reports that I believe are junk now and I need to clean house. ------------------------------Alan Sulzer------------------------------
Hi There, I'm from HCB Cloud CoE team and we are extensively using QB for our day to day work tracking purpose. Im an administrator for several application, however, when we try to add new member as a viewer or participant, a pop-message shows saying, Realm admin must register new member. Please let me know how I can add our teammates to access QB apps and how can I figure out who is our Realm admin? Regards, Kazi Anisha Falguni Sr Analyst, Application Development Email: falguniK@aetna.com NOTICE TO RECIPIENT OF INFORMATION:This e-mail may contain confidential or privileged information. If you think you have received this e-mail in error, please advise the sender by reply e-mail and then delete this e-mail immediately. This e-mail may also contain protected health information (PHI) with information about sensitive medical conditions, including, but not limited to, treatment for substance use disorders, behavioral health, HIV/AIDS, or preg
How to know who is your Realm admin? Im a admin to our QB application but whenever I try to add new user, a pop-up massage shows realm admin must register the new user------------------------------Kazi Anisha Rah Falguni------------------------------
I have attachments within Table A, called Publication Tracker, and I would like to quickly access these attachments via single field, both for a report and so I can ideally pull this info into another Table B, called Project Tracker. I have used the List formula field which would be perfect except it just lists the attachments from the selected fields as text, rather than links to the documents.Is this possible to do, and how?
I've looked up community discussions on this topic but cannot ascertain if there is a way to do this yet. My form rules work without issues in logging changes to a field in a table. But I've received a request that users would like to add multiple records together rather than one at a time in a form. So I thought of providing a report and have them use GRID EDIT to add multiple records together. But how do I track who approved a record and when? Can I use a formula field that uses snapshot to see who modified the record when that "Approval" field changed? Any creative way of doing this? Thanks Deepa------------------------------Deepa Prashant------------------------------
Hello, I have a parent table and a child table I am working with. The parent table has a field called [CList Master (Pipeline generated)] The child table has a field called [Clist current page] I am trying to create a pipeline that when a record on the child table is created, modified, or deleted it will search for the related parent record. Once found, it {{CLEAR}}'s the field called [CList Master (Pipeline generated)]. Next, it searches for all related child records to that related parent record. Once it finds all related child records, I have a for-each child record loop in the pipeline and (finally the Issue...) I would then like pipelines to update the parent record's field called [CList Master (Pipeline generated)] (which is now null) and list all unique [Clist current page] values.I have attached a screenshot of the parent and child record as reference. Thank you in advance------------------------------Shane Miller------------------------------
I would like to create a text formula that removes blank spaces and changes text to lower case. For example: [Field A] = New York City[new formula field] = newyorkcitythanks
Hello everyone and Happy Friday! I am trying to get some of our departments to shift away from creating schedules in spreadsheets and into Quickbase. I've got a framework built up between two related tables so far: Staff Members and Calendar Events. Where I'm getting stuck is how I can add functionality that would make this more convenient than copying and pasting cells in a spreadsheet. Specifically, I'd like to create the following: Ability to duplicate days for a staff member for a custom timeframe in the future. Example: Duplicate this calendar event for Joe Schmoe every Monday-Friday through the end of the year. This would give my coworkers an easy way to draft up a framework for the year and then adjust accordingly for PTO, Days Off, and other specifics. Any ideas how I could add this functionality? By way of pipeline? URL Formula?------------------------------Aidon Olligschlager |Flight Operations Technical SupportPentastar AviationWaterford MIaol
When a new 'Lead' entry is created in my app, the field for Address: State/Region is fully spelled out (i.e. Alabama). We've set it up this way and this part can't be changed.What I want to happen is this:Anytime a new 'Lead' entry is created, I want to create an action or formula that creates a separate field for the State abbreviation.For instance: A new lead comes in. The state address is California.Need to create new field entry of CA for this lead. How can I do this?FYI: There's another post that is somewhat related, but I couldn't figure out how to execute based on these instructions:Reference: https://community.quickbase.com/communities/community-home/digestviewer/viewthread?GroupId=103&MID=30396&CommunityKey=d860b0f8-6a48-487b-b346-44c47a19a804&tab=digestviewer{{ "Alabama"|replace("Alabama", "AL") }}Thanks,Matt------------------------------Mathew Crist------------------------------
I have a button that triggers a pipeline. The pipeline creates a new record. Is there a way to automatically open a form with that new record when the pipeline is finished? I have searched this forum and the internet in general without finding anything that makes it look like this is possible. ------------------------------Aaron Bab1692@att.com------------------------------
Hello all, I am fairly new to QuickBase and have been watching videos to help further my skills. I am trying to create a multiple-choice quiz where employees can take but not edit their quiz. I would also like them to see their scores at the end. I have seen how to do a formula version with the If function giving them one point. Just wondering if there's ways to do so. Thank you. Christian V------------------------------Christian Verduzco------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.