Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello All, Wondering if anyone knows how to get creative here - I'd like a dynamic button within a singular column (field) of a report. This way, depending on the conditions, the button changes based on the next predicted behavior. Here's my situation: If the parent record does not have a related child record, display blue "Request Change" button. If the parent record does have a related child record, display green "Edit Request" button. I understand this would be easy to accomplish by using two separate button fields, but the idea is to keep it clean and predictable. Any ideas? Picture for reference... ------------------------------Aidon Olligschlager |Flight Operations Technical SupportPentastar AviationWaterford MIaolligschlager@pentastaraviation.com | 248-202-9587------------------------------
Hi all! I posted last week but am really stumped still. Some of my end users are requesting to save information while still working on a new record -- and in our workflow, it's common that they may be gathering datapoints over multiple hours (and sometimes in 15 minutes). They don't want to lose their datapoints as they complete collection - and we don't want to miss any of our required fields, which are critical to a number of areas from regulatory requirements to funding support. Someone suggested that I "hide" a section that has the save button and add the conditions on that my required fields must be filled in to show that section, but the save button is actually always present, so that doesn't quite achieve what I'm hoping for. Additionally, we have some layered requirements - if X is "Yes", then require 4 other fields. So I'm just trying to figure out the best possible approach to letting them save their progress, while not relinquishing control over getting those required
I have added a Text-multiple choice field that pulls it data from another table and field. The other table does have duplicate rows for the field I'm pulling in. On the old form, the drop down shows just 1 value for each but the new form shows the multiple options. Is there a way to correct this.------------------------------Carol Mcconnell------------------------------
🚀 Houston Quickbase Community: Join Us for Our Next Qrew Meetup! 🌟Register for this event here: https://lnkd.in/gP4BbzSACalling all Quickbase enthusiasts! After our successful inaugural meetup, we're excited to host our second Houston Qrew event. This time, it's all about what YOU want to explore and learn.👂 We're Listening:Share your ideas for topics, workshops, and discussions.Help us shape the event to your interests.📊 Have Your Say:Participate in our upcoming poll to voice your preferences and suggestions for the meetup. Your input is crucial!🙌 Spread the Word:Invite fellow Quickbase users in the Houston area to join in and enrich our Qrew.Let's make this meetup a collaborative and insightful experience for all. Stay tuned for more details!🔗 RSVP & Share Your Ideas Here:https://lnkd.in/gP4BbzSALooking forward to seeing you all!Cheers,Blake Harrison, Houston Qrew Captain------------------------------Blake HarrisonSystems Analyst / Quickbase DeveloperBCF Partners Capit
I know how to create record and display by using the "&disprec=1" tag. I also have used the example code page that allows you to pause and refresh. I would like to combine, as in my use case when I create the parent, I have actions fire which create 3 children. On mobile, it refreshes before the children are created, so i want to add a pause. However, I cannot get it to create the parent, pause, then display the parent. Any ideas?------------------------------Mike Tamoush------------------------------
I am using the beta forms and I have noticed that for child recods where there is a report on the parent record form, when a user clicks on view and the window pop ups, there is not option to edit from the pop up. Is there a setting somewhere for this, or is it just how the new forms work?------------------------------Carol Mcconnell------------------------------
Hi all, we use Quickbase as a CRM for client encounters at our social services organization. I'm looking for help creating a "count" formula based off of a text field. We have a table called "Service Subcategory" which is nested in a table called "Encounter" (so within 1 encounter, a client may have received many different services, called service subcategories). I want a count of the number of times a client received the "Hoarding" service subcategory in the past quarter. So for a given client, counting across all "Service Subcategory" instances... could anyone help with this case / with writing a formula? Thank you! Rachel------------------------------Rachel Plummer------------------------------
I'm running into a bit of a migration issue. We currently have a database on the old version of the forms (Pre 2023 modernization). There's a lot of changes that need to be done to the database, so I'm working on rebuilding the database which is now being done in the modern forms. In the old version of the forms, you could choose a report to use as the record picker for data entry, and it would give you more than the 3 default columns which you can set in the table settings. Here's an image showing what I'm referring to when choosing to use a report for the data entry: However, in the new forms I'm not able to find any option to choose a report to be used for data entry. It gives an option to "Select using record picker", and I can choose "based on report", and it will give the first three columns of that report. But I need to be able to get 4 columns. Each column is fairly distinct, so if I can avoid using a formula to concat two columns together I'd like to avoid that, and ac
Good day I want to capture the code (non key field) in a table but want to display the code description on a form/report. Any assistance would be appreciated.------------------------------DeShawn Jones------------------------------
This has been solved.
Hi all..... Have done a comparison summary report for sets of details in 2023 vs 2024. To calculate the averages, i have used the following 'summary fields' On the second field, is there a way to calculate the number of days (year to date) so i don't have to manually keep changing the number, and bonus points if someone could tell me how i would remove the 'bogus' averages appearing in each line (due to above) Cheers, Damien------------------------------damien page------------------------------
How do I delete users in the denied status? My attempt is to update my database including changing administrators. Any advice would be very helpful. ------------------------------Allen Maxwell------------------------------
I'm using a table report and would like to strikethrough the text all fields (columns) of an entry which has a [Project Status] that is "Cancelled". I've attempted a report formula (rich text) as follows:Case([Project Status],"Cancelled", "<span style='text-decoration:line-through'></span>")I'm not receiving any errors in the formula, but there is no strikethrough text on the relevant "Cancelled" entries.I've also attempted to specify a field, just in case the first formula wasn't specific enough, so I singled out [City ,ST | Site Name] with the same result (or lack thereof):Case([Project Status],"Cancelled", "<span style='text-decoration:line-through'>"&[City ,ST | Site Name]&"</span>")Any help is greatly appreciated!------------------------------Howard Dyer III------------------------------
Hello Quickbase community, I'm experiencing an issue with the new Quickbase forms where I have a predecessor field called "Predecessor Tasks" on the form, yet I cannot find it, even though I press the arrow icon to find the field on the form, it doesn't take me to it (see attached screenshot), and the form doesn't allow me to add the field to the form again.I wanted to know if anyone else has experienced this and if they have found a solution to make the field show up again, or how to remove from the form so it can be added again? Thank you!------------------------------Alberto TabladaLead Software EngineerBlueWell GroupFlorencia+50688083124------------------------------
This has got to be a DB design question. The App is called IT Software Maintenance Agreements. Table is Annual Agreements. Fields are things like, Software, Vendor, Budget year, Budget Type (Estimate, Actual), Account Code, etc. Next Due Date is one of the fields. Problem I am running into is, let's say I paid for a five year deal upfront. I would have a zero dollar entry for year 2. Same for year 3. I guess I can make that entry each year and then just reflect the Year 5 renewal date each time. Just thinking there is a better way to handle this. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I struggled with the title of this post, but hopefully got close. I am building all my apps for my org. I would like to have an App, but maybe that's the wrong way of doing it, called City Council. The idea would be this App has a Dashboard with a page for each department. On that departmental Dashboard Page would be the meaningful reports for City Council. Can I do that across apps, so to speak? It would be difficult, if not impossible, to get Council to open the many, many apps we will build to look at a dashboard for that app.------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I think there are ways, by DB design, to avoid this need, but it also might be worth asking. O might have multiple attachments, more than 3, needed for a record entry. As of right now, I can only see doing this by creating a field for each attachment. Is there a field type that allows multiple attachments in the one field? (I realize this delves into a parent/child or a one to many relationship.)------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I know where the FY settings are for an Application and how to set it. I also know how to use it on a Chart under the filter settings. But, I don't want to filter my chart by Fiscal Year. Rather, I want my FY field to be a dynamic filter. So, how do I create a field, and the formula, to put in FY based on another date field. Specific example, we have a Customer Sat Survey. I can potentially use either date field. Date Created or (user inputed) Date of Contact. I want a FY field that looks at this specific date and assigns it to a Fiscal year and then puts that year in the field. I can then designate that field as a dynamic filter.------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)------------------------------
My problem is that when i add an attachment from the inspection reports table the information that is added to the attachment table is from the inspection report table and not from the light tower table. I have 3 tables, light towers, attachments and inspection reports. light towers have many attachments, inspection reports have many attachments. When i add an attachment from an inspection report, I do not like how the light tower information such as light tower number, is not in the same field as the light tower number that comes from the light tower table. In order for it to populate in the field from the light tower table i have to manually choose the light tower again from a drop down. Obviously this reference field is already filled when i create an attachment from the inspection reports table. Is there anyway to have the related light tower field auto filled based on the related inspection report? Meaning, when I add an attachment from the inspection report table, I do not
I have an email notification set up to let the Sales Rep of a job know when a due date changes. Is there a way for the email to display the original due date and also what the new due date is? I turned on the tracking function for this field, but it seems like only I can see that info as the realm admin? Is there a way to share the info so it displays in the email to the Sales Rep? thanks!------------------------------Allison Watson------------------------------
Hi All, I have created a pipeline to fetch some data from Salesforce to quickbase i used Salesforce Generic SOQL query step but the output i received from this step unable to use in the next steps due to the popup is showing no attributes. How to write a jinga script to use the output of SOQL query. ------------------------------Hema Venkata Sainath Vemula------------------------------
For a specific field, (project status) we have the box checked ---Log the edits to this field, and show them on forms----we would like to run reports off this filed, but off what the current project status is only. When we go to make reports, its pulling all the log edits. Is there a way to filter by this field . ( Example we would like to filter by Active and if you change the field [DEC-14-23 xxx xxxx] New Request, Active )------------------------------Kari Lang------------------------------
I discovered an issue today, and am wondering if there is a workaround. We use SAML, so the Users email and password is governed by our IT Security Software. I can add users to QB, but until they login their first time, I get this notice when looking at a users information: Once the user signs in the first time, that will show the users email address. The issue I am running into is - I send out reminders to users, which must use, user fields. These user fields have no email associated, until the first sign in. Thus, they are not getting their reminders. Does anyone know if there is a way to force the issue? To be sure that External Authentication ID is known and the User has an email associated to their user name, before the user has signed in the first time?------------------------------Mike Tamoush------------------------------
Good Morning QB Community, Discovered a small hiccup that I can't figure out a solution for. I have an app built for the purpose of assigning tasks to users when on-boarding or off-boarding employees. I utilize two email notifications (single vs multiple records) to notify users of the new tasks assigned to them. The emails work in every circumstance except one: If Task #1 is assigned to User #1 and Task #2 is assigned to both User #1 and #2, only User #1 will receive the multiple record notification. User #2 will not receive anything. Other combinations that have been tested and work properly: Assign single record to User #1 Assign multiple records to User #1 Assign single record to User #1 and #2 Assign multiple records to User #1 and #2 It only seems to be a problem when you're generating multiple records and there is a user(s) with only a single assigned record. The notifications will skip these people. Any ideas how I can restructure to make s
Hey All, I have code that is ran from outside of QB that uses the XML API to accomplish various things, and I'm looking to move from the XML API to the restful one. Currently, each job uses the XML API call API_Authenticate in order to verify the username/password of a user, then get a ticket that is supplied to further calls. Is there an equivalent way of doing this with the restful API? I was looking at the various auth methods on this page https://developer.quickbase.com/auth and thought that maybe getTempTokenDBID was what I wanted, but I get 400 responses with the message "Domain not allowed" from that call. Is the best way to use the API from an external job to use permanent user tokens? Thanks!------------------------------Cody Medaris------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.