Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, Just started using this tool. How to change timecard entry view by date as columns and project code as rows so reduces going back and forth edit each project? please see attached mockup. Weekly view would do, instead of monthly, as well... ------------------------------DATTA SHIVASANE------------------------------
Hello Quickbase community! I can mass delete field attachments, using a date range, for example from 2016 to 2019, delete the data of that field, not the entire record.------------------------------Herberth Solano------------------------------
Hello! I just realized they have removed the Email option from within the new form layout. Is there any other way to email a record directly to someone? ------------------------------Matthew Wolffe------------------------------
I want a pipeline that, when a record is created in table A, it will look to see if the record exists in Table B. If it doesn't exist, create a new record in Table B. If it does exist, concatenate the text from the new record in Table A with the existing record text in Table B separated by a comma. I also want to add a value from a field in the new record from Table A with the corresponding value from the existing record in Table B. For example, the new record is created with "some text" in field 5 and the number 3 in field 8. The existing record in table B currently has "a message" in field 2 and the number 1 in field 5. After the pipeline runs, I want the existing record in table B to read "a message, some text" in field 2 and the number 4 in field 5. I can create the pipeline, search for the existing record, setup the condition to determine whether or not the record exists, etc. I'm assuming I need jinja expressions to concatenate the text and i
We have print forms buttons throughout our application and also use the more dropdown from within some forms to print. These are not working as of the past few days. Anyone else experiencing this same issue. It gets hung up loading the preview.------------------------------Zach Shumate------------------------------
I have created the basic summary report but I what I actually need is to have the three columns to the right, actually be rows. So I want Vendor and year and then under year, I want the next three columns to be rows. Thanks. ------------------------------Carol Mcconnell------------------------------
I'm trying to build a pipeline that runs hourly, to perform an API call. However, I would like for the same pipeline to perform a second action once per day, at a specific hour (when the hourly run happens in the 6:00AM hour). I understand to build an if statement as so: IF [expression (advanced)] evaluates to TRUE [____________________________________] and I know that the Jinja for "now" is {{time.now}} How would I build the expression that returns true only if the current time is within the 6:00AM hour? ------------------------------Scott Dye------------------------------
Good morning,I have an embedded report in the app I am working on where the data comes from a different app. However they have related fields. I am wanting to filter this embedded report by the field the reports have in common. The problem is well, i dont know how to do this, i am guessing. I am looking into "Filter using report link settings" and not understanding that. The context is that this embedded report shows assets that are related to the mission i am looking at. The mission was transferred to a different app because this type of mission is handled very differently than other missions. So to recap, I am trying to only see assets that are assigned to the mission i am looking at in my current app through this embedded report, but these assets are tracked in a different app. Thanks so much,------------------------------Bailey Desormeaux------------------------------
Hey all, I'm working on a tracking setup / creation log for pipeline runs and had a best-case-scenario question. When a pipeline runs, does it have access to the link to that run's URL? The one that you see if you go to an individual "This run's activity" link from the pipeline itself. My ideal outcome here is that I'm using the pipeline to stamp that run's activity URL onto the record it made so that we can just hop to the run if there's an issue. (Alternative is to just link to the pipeline's general URL, which is fine, but certainly less efficient) Thanks!------------------------------Tom Keaten------------------------------
Looking for a formula that can take a date field and tell me "Next Week", " In Two Weeks", "Next Month", "Future" (aka too far beyond next month) ------------------------------Korrie Clark------------------------------
Hello everyone! I am currently having an issue with the Gantt chart reordering milestones and tasks on its own. Has anyone ever experienced this before?------------------------------Tabby Jalloh------------------------------
Our fields have various stages for the status (0%, 30%,... 100%). We also have fields for arrival date and quoted lead times that get added together to populate a promise date. What I want to do is when the order is set to 100% Closed Won (from the drop down option on the form) AND and arrival date is populated the quoted lead time is then added to the arrival date to generate a promise date. I feel like I'm close with the following. IF([Status]="100% Closed Won") WeekdayAdd([Arrival Date], [Quoted Lead Time])------------------------------Justin Olsen------------------------------
Hi! I have this formula and need the disclaimer to be on the top line and "Please direct those requests to the appropriate Product Team on the second line. I tried to put \n but it doesn't work. "<font color=indianred><font size=2><B>"&"***DISCLAIMER*** Please direct those requests to the appropriate Product Team."------------------------------Vanessa Alexander------------------------------
Hi, Can someone please assist me in how to create a url button to update text multiple choice field using URL botton.------------------------------vikas pasula------------------------------
I have an app with ~100 active pipelines performing all sorts of different actions, but there are some performing similar actions that sometime run in parallel and occasionally run into each other, causing debugging issues trying to figure out which pipeline most recently performed an action on a record & why. Is there a way to create a pipeline that could create a record in a Pipeline Tracking table anytime a new pipeline is created or modified, and what update was made, or is pipeline auditing something that would have to be done manually by our team anytime they made a new one? Just trying to think of ways we can better organize how these are being used so we can see potential issues ahead of time. Tagging pipelines only goes so far. ------------------------------Harrison Smith------------------------------
Hello: I have a Graduation Data table that includes the following fields: Term - Text-Multiple Choice Field Program Title -Text Field Count - Numeric Field Data 2019 Spring, Science Program, 10 graduates 2019 Summer, Science Program, 20 graduates 2019 Fall, Science Program, 30 graduates 2019 Spring, Math Program, 5 graduates 2019 Summer, Math Program, 10 graduates 2019 Fall, Math Program, 5 graduates Goal: To create a bar chart that states the Science Program had a total of 60 graduates and the Math Program had a total of 20 graduates in 2019 I tried different combinations of X and Y axes but could not get the bar chart the way I wanted. I figured I would need to create a new field, Graduate Count per Program per Year Formula - Formula Numeric, but I cannot get any formula to work. I realize I cannot have two different field types in a formula. Any help would be greatly appreciated. Thank you,------------------------------Roula-----------
Is there a way for me to create a table of events that mirror Outlook's recurring appointment functionality? Example: Daily, Weekly, Monthly, Yearly recurring events. Here is the scenario: I have a simple table of events (Name, Date, Duration). I create one event (Weekly Status Meeting, 3/18/24, 60 mins). I would like to be able to select the period of time that I want this event to be duplicated (in this instance, I need Weekly until 7/31/24). This is one example; however, I need a solution that would allow me to create Daily, Weekly, Monthly, Yearly events based on the existing date, and for a selected period of time (end date). I hope this makes sense.------------------------------Myoshia Boykin-Anderson------------------------------
Hi -- I'm attempting to update access permissions to an existing table which has Records according to 4 different Teams (Team A, B, C, D) where Team is a field associated with each record. Each record has basic title information and more confidential details. I would like all users to be able to see the title information, but only see the confidential details of the Teams they are associated with. Some users are associated with multiple teams. I've tried creating different forms to assign to specific roles, but when I assign multiple roles to individuals, the additive nature of the roles makes users see more data than they should. I've also tried to create a dynamic form rule to show or hide the appropriate sections based on the user role and the Team field but since there are four teams, I need four rules and that creates a conflict. Is there a simpler way of solving this problem? Thanks in advance!-------------
We are slowly creating New Forms for our apps, replacing the old-style forms. What would make our job a lot easier, is being able to export the current dynamic form rules, so we can tick them off / reconsidering how we achieve some of the functionality. Any thoughts?------------------------------Nick Charalambousnick@em-dev.co.ukLondon, UK------------------------------
Formula goes up to "3- Checklist Complete" but stops there and I cannot figure it out. If([Level]="Level 4" and [Documents Available]=false, "1 - Waiting on Documentation",If([Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= false, "2 - Checklist Incomplete",If([Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true, "3 - Checklist Complete",If([Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]<>"", "4 - Waiting on Approvals",If([Level]="Level 4" and [Documents Available]=true and [Checklist Complete]= true and [Approvals Needed]="", "5 - Review Complete"------------------------------Sarah Burres------------------------------
The objective is to prevent adding a child record to a parent a second time from a record picker. A simple business case is adding parts to a Bill of Material from an Item Master. A given Assembly might need 30 parts from the 10K in the Item Master and I am trying to make sure that the User cannot pick the same one a second time. ------------------------------Don Larson------------------------------
Hi All, I'm not sure where to start with this one. It seems relatively simple, but my search terms have yielded me nothing thus far (As you can probably tell from my ambiguous titling of this message!) .....I know, it hardly makes sense to me (the title) and I know what I'm trying to ask! Staff/Employee Application: I have a staff application that has multiple tables. One table is the employees themselves; another is their assignments. Since we have employees that often move from one team to another, assignments are added as active, then the previous one is "inactivated" (via checkbox). In the report that I have built (based on dates, etc) - I am pulling in the ACTIVE assignment. Is there a way to add a column to this report (a field, I'm assuming) that shows the first INACTIVE assignment's record for TEAM NAME? Specifics of this report: This report is specifically for anniversary dates/bonus eligibility - for specific people.
Hello Quickbase community, I have a Reservations table that has multiple related records in a table called Document Library. Each of these records has a PDF attached. When a reservation transitions to the "RESERVED" state, I need to automatically send an email with all the attached PDFs to the email specified in a field named Email. Is it possible to achieve this using a PIPELINE?------------------------------Herberth Solano------------------------------
WRONG APPLICATION DETAIL IS VISIBLE IN MY TIME REPORTING TOOL AND I AM UNABLE TO FIND MY APPLICATION IN THE TOOL. PLEASE HELP. CORRELATION ID OF APPLICATION IS - 10410------------------------------YASH LAKHOTIYA------------------------------
Does anyone know how to have a Slack Pipeline reply to an existing Slack thread? The full case is that I want to create a slack post when a project record is in 'draft'. Then, when the project moves to "Approval Requested", I'm trying to get it to reply to the slack post created when the project went to 'Draft' I'm able to store the slack "Conversation" and have it reply in the conversation, but haven't been able to figure out how to post as a reply. Thanks,Jake
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.