Qrew Groups
Connect with others from your area, or who share the same role, professional interest. Find your Qrew here!
Recent Discussions
Formula needed to pull out most recent status of a logged multiple choice field
I have a multiple choice field, PICC Request Status, that is also a logged field. Most recent choices are at the top and on their own line. Trim(Right([PICC Request Status],"]")) pulls out the first logged status with the dashes: --------------Needs Review The current field contains -- [MAY-13-25 Molly Smith] -------------- Closed -- [MAY-12-25 Molly Smith] -------------- Action In Progress -- [MAY-12-25 Molly Smith] -------------- In Review -- [MAY-12-25 Molly Smith] -------------- Needs Review The end result of the formula should just be Closed. What do I need to adjust in my formula?Solved27Views0likes5Comments
Set Height for Rich Text Field
I have a form rule that automatically puts text into a rich text field but I would like the rich text field height bigger. How can I do that? I added the the formala rule to set the height to a certain number of pixels but it doesn't seem to be affecting it.Solved11Views0likes1CommentParent to Child Reference Field
When making relationships between parent and children records I understand how to add additional lookups. But when you do that then those fields need to be "updated" when adding a new child. What I am seeking is a way that when a child record is created, and related to a specific parent, that the child record would show the value of additional fields from the parent. Example: Parent record has Name, Address, Phone Number, Favorite Color Child record has Child name, lookup field to select parent which would bring down the Parent Name and Favorite Color Currently when setting the relationship I would connect on Related Parent then add the lookups for Parent Name and Favorite Color, but when actually creating the new Child record once I select the related parent, the Parent Name and Favorite Color are not populating. If I want those to display the value, I have to manually update those fields (thus not benefiting from setting the relationship to the Parent). What am I missing? This seems like an easy ask but for the life of me I'm just not seeing a pathway to make this work.Solved19Views0likes2CommentsHow to Calculate Completion Percentage Using Multi-Select Boxes
I’m trying to create a formula that calculates the completion percentage based on a series of multi-select checkboxes. For example, if there are four checkboxes and three of them are selected, I’d like the formula to return 75%. Is there a way to achieve this in Quickbase? Any help would be greatly appreciated! Thank you in advance!Solved31Views0likes5Comments
Primary and Secondary Contacts from Table
I'm pretty sure this is a simple many-to-many relationship, but my brain hitting a wall and cannot comprehend how to set this up. We have an app in development where employees can submit reports of things happening in their day to day. Each report is then "assigned" to a person or department from a Responder table to follow up. I most cases, each report will only have one Responder so I have a normal one to many relationship set up currently. Now, occasionally, we have a situation where there will be a Primary Responder, but another department/s or person/people are included for line of sight/further conversation, ie Secondary Responder/s. I would like to have two fields, one for primary and one for secondary so I can differentiate between the two when the Pipeline kicks out the email to everyone. Is this a simple many-to-many relationship or is this going to be a bit more complex? Thank you!Solved21Views0likes2Comments
Can I have 1500 or more fields in one form in one table, spread across multiple pages?
I will be creating a new app. In one table, is it possible to have a form with around 50 pages, and each page would have anywhere from approx 10 to 50 fields (probably only a few pages would have 30-50 fields, most pages would have 10-20). Therefore, the total number of fields in the form would be anywhere from approx 1,000 to 2,500. Of that total, around 200 fields would be derived fields (formulas). I would also like to have form rules that hide certain pages based on a field selection. NOTE: for each record, only about 60-100 fields would be populated. Are there limits that would prevent me from adding that many fields? Or could so many fields cause performance or other issues, like problems with form rules functioning properly? While it is possible for us to pull out most fields into other tables and connect to the main table using relationships, for our users ease of use and ease of reporting, we are hoping to contain all fields in one form in one table.Solved35Views0likes4Comments
Duplicate Record Checker
Hello, I have a form with two fields named "Year" and "Quarter". The Quarter field is a dropdown with options such as "Q1", "Q2", etc. The Year field is a numeric field where users enter a year (i.e., 2025). What I need help with is displaying a error message when users have duplicate Quarters for a single given year. Example: If a user has a record with "Q1" for the Quarter and "2025" for the Year, they cannot enter another record for 2025 with Q1. They may only select "Q2", "Q3" or so on for 2025. Hopefully I explained this well enoguh for someone to understand. If I can elaborate more, please let me know.Solved61Views0likes5Comments
Using pipelines to log the date/time including the seconds of a record change
I have a pipeline that logs when a record was changed in a tracker table. I need the date/time of the change to be accurate to the second. I can't have a pipeline copy the Date Modified of the source record to a Date/Time field in the status change record as we would lose the seconds. I can't use the Date Created of the record created by the pipeline as this and the user's action are offset by a second or two. I need this to be when the user made the change, not when the pipeline created the record. I created a Formula - Date/Time field in the source table that is ToUnixTime([Date Modified]), then the pipeline copies that to a Number field in the status change record. This works, however I'm in search of a more elegant solution than creating a formula field in every table that needs this. Is there a Jinja expression that will give me the ToUnixTime() of Date Modified without having to create a formula field?Solved22Views0likes1Comment
