Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have created a pipeline to send an email via Gmail, and I have selected the only option available for 'Link (advanced)'. Now I'm trying to create another pipeline so I can identify which messages received from Gmail are linked to the original email sent. How do I fetch a linked record? ------------------------------Kelly Bianchi------------------------------
I need to use the following field in a date range [cln enc date - date] It's a date-formula field.I am trying to check for current dates, within last week (7 days)last week 8-14 daysand then 15-21 days.I try Boolean logic with AND and use ToDate, Today, etc but getting errors, such as mixing date and time. I just want date calculations and don't care about time of day. I have image of the date fields there are. There are a lot of date fields, but I didn't create most of these. The [cln enc date - date] is the field that is used to match encounter records.------------------------------Bob T.------------------------------
Hello, I just discovered that there is a watermark feature for Exact Forms Plus! Sadly, I keep getting an error, and am hoping it's an easy fix. Here is the JuicedTech documentation. Watermark. This allows you to include a watermark in your output document. format is Text|Color|Font-Size (v9.4 and above) Here is my error message: ERROR CREATING WATERMARK IN DOCUMENTObject reference not set to an instance of an object.Make sure the wm url parameter is in the format wm=TEXT|COLOR|SIZE Exact Forms Plus v11.5.10 You'll notice I am on a higher version than the minimum v9.4 required. here is a portion of the code inside my formula url button:& "&efpdte=854"& "&wm=DRAFT|RED|65"& "&uid=855:" & UserToEmail(User())& "&docfmt=docx&stream=y" If I comment out the watermark line, everything works perfectly. Any ideas? ------------------------------Shane Miller------------------------------
We have drivers who must call a system that records their callouts. QB creates a record for each EID callout. I need to create a report that returns the EIDs - that call out 11 business days in a row. . HELP!------------------------------Penelope Wilson------------------------------
I am looking for creative solutions to a request I received from our CFO. I have a line/bar graph report in a child table that is not relevant until filtered by a parent record. Therefore, on the graph is displayed on the parent record. The CFO likes this graph but has asked, how she can see this report for each parent record side by side on one page or document. So far, the only solution I came up with is to create a separate report under the child table filtered for each parent record and then lay all those reports out on a dashboard. I don't want to do this because it would mean that when we create a new parent record someone would need to create a new report and update the dashboard and the same if a parent record is removed. Any ideas on how this can be done differently? ------------------------------Hadassa Pam------------------------------
Hey Houston Quickbase Fam! 🚀 First off, my apologies for the radio silence – the holiday season and a family situation kept me away longer than expected. But hey, I'm back and super excited to chat about our first-ever Houston Qrew meetup on October 26th, 2023! Wow, What a Crowd! We thought maybe 10 of you Quickbase wizards would show up, but guess what? We hit a sweet 15! That's right, our Qrew is growing and how! 🎉 Reflecting on Our First Gathering Our meetup was a blast – more than we could have asked for our first time around. We picked the topics, but noticed we could've stirred up more chit-chat. Lesson learned, and we're all about making things better. We Want to Hear from YOU! Your ideas matter big time! What do you want to talk about next time? Shoot us your thoughts for future meetups. After all, this Qrew is all about what YOU want to explore in the Quickbase universe. Get Ready for Weekly Fun Challenges! Here's something cool – we're rolling out weekly challenges in our Q
I wish to stop my pipelines running outside of working hours I have an IF section with advanced expression. What is the correct syntax to check whether the current hour is greater than or equal to a given hour? I have tried {{time.now.hour <= 15'}} {{time.now.hour <= '5}} but these don't seem to work thank you------------------------------Pete James------------------------------
I am having trouble creating a field that can be added to the series section of a pie chart. The pie chart needs to show how a color associated with each condition to be able to split the pie chart in the sections. My formula keeps saying expecting boolean and I am not sure why. I have included a 1 at the end of each condition and a 0 at the end. Can some one help with getting the formula to work please? Here is the code: if([Days Open] <= 30, [(HIPO) / (HVL)] = "HIPO", "#2ca01c", 1, // show green if the event is HIPO and days open is 30 days or less[Days Open] <= 31, [ (HIPO) / (HVL)] = "HIPO", "#ad0707", 1, // show dark red if the event is HIPO and days open is 31 days or more[Days Open] >= 60, [(HIPO) / (HVL)] = "HVL", "#2ca01c", 1, // show green if the event is HVL and days open is 60 days or less[Days Open] <= 61, [(HIPO) / HVL (HVL)] = "HVL", "#ff0808", 1, // show red if the event is HVL and has been open 61 doays or more // conditions above apply to closed event
I hope someone can help with this....here is my issue: I have a drop-down field to choose a customer name. Then there is a conditional field for "Sign Types", so when you choose a customer it shows you all of their sign types. The problem is now when I go to choose the customer, it shows me multiples of the same name. If there are 6 sign types for a particular customer, then it is showing the customer name 6 times on the list. It didn't used to do this, it used to show just 1 choice for each customer. I'm not sure when it changed, but I cannot figure out to to fix it. How do I fix this? thanks in advance!------------------------------Allison Watson------------------------------
Has anyone found a way with the File Manager Plug in to make it dynamically fit to the width of the screen? The iFrame settings allow you to set the pixel height/width, but leaving either blank causes it to corrupt itself on the new forms. Any insight into a way to have it dynamically fit the width of the container that it's in?------------------------------Chayce Duncan------------------------------
I am trying to create a folder and subfolder in that folder in SharePoint. It does create a folder but not subfolder. How to specify the path for the subfolder correctly? I tried so many ways and none of them gave me needed result.------------------------------Olena Bilinska------------------------------
I have the following code on a formula field to highlight a checkbox field if it's false. I copied this code directly from the Quickbase article about it so I cannot figure out why it wouldn't work. The first backslash highlighted below is the one producing the error. Please help! If([Send Letter]=false, "<div style=\"color:white;background-color:red;\"> false</div>, [Send letter] ) ------------------------------Hannah Engelson------------------------------
In the Gantt plug-in, marking a task "inactive" from the Advanced menu greys it out on the task list and Gantt bar. However, once you save and exit the Gantt, it appears nothing happens with that data to retain it, and the tasks are no longer inactive when returning to the plug-in. Any understanding as to why this is, and what functionality the inactive option does have? Thanks!------------------------------Carlie Maheurin------------------------------
I have the following tables. (Drivers) have many (BOL) have many (BOL Assignments) have many (Inventory Tracking) I am trying to create a status for a driver based off of the deployment status of the assets that he has on his truck. The deployment status is in the inventory tracking table. The inventory status is updated based off of some check out/in fields. So based off of the statuses of the assets on his/her truck i can know what the drivers status is. If he/she is busy or not busy. Is it possible to get this status from a table that is so distantly related?------------------------------Bailey Desormeaux------------------------------
I was wondering if anyone was having the same issue that I am having? On the new forms and a user field, when trying to search for a user, sometimes it works and sometimes it doesn't. ------------------------------Carol Mcconnell------------------------------
Hi Everyone, I am trying to create a report that will summarize a numeric field per address, but I need to display other fields on the record... Does the platform supports this? Example of today's report output: <!--td {border: 1px solid #cccccc;}br {mso-data-placement:same-cell;}--> Customer Cust ID Terms Invoice # Subdivision Jobsite Address Material Customer PO# Date Ticket Qty Unit Price Pulsar Homes 13249 15 101 Allen 9999 Test Dr Millines 12345 11-28-2023 78932-92740 2 $120 Pulsar Homes 13249 15 101 Allen 9999 Test Dr Millines 12345 12-05-2023 78932-92740 2 $120 Pulsar Homes 13249 15 101 Allen 9999 Test Dr Millines 12345 12-08-2023 78932-92740 2 $120 I would like to display these 3 rows grouping them by address and adding the Qty as well as Unit Price... I am able to do it but I can not include the other fields.... only Address, Qty and Unit Price... Any help will be greatly appreciate it! Regards... ------------------------------Miguel Francis-----------
I am wondering if I can populate a date field if two other fields match? I have a form where there is a checkbox if a "Coaching session" occured. There is also a field for the "Topic" of the coaching session. When the checkbox is checked the date for this record is populated in a Date/Time field. When a new record is created and the same Topic is selected I would like the date that the record (previous record) with the "Coaching session" checkbox checked populated in the new records "Coaching" date field. Is this possible? Thanks, Brian ------------------------------Brian Dunk------------------------------
I have two multiple choice fields on the same table. Each record has a required field called "Program Type," and an optional field called "Scope." There are three program types that will use the scope field, the rest won't see this field when viewing or editing these records on the form. Each program type has a different set of choices they can use within the "scope" field. I would like a way for the form to show only the appropriate options to when the "program type" field is set to these unique values. I am still using old forms on this table. Example of what I would like the drop down to show based on program type. Program Type 1 Scope A Scope B Scope C Program Type 2 Scope D Scope E Scope F Hopefully that's clear, thanks for any advice you may have! Jen -- I know I have done this other places in my sy------------------------------Jen Black------------------------------
How do I go about allowing each user to have their own default page?------------------------------Landon Wyrick------------------------------
Good morning, I have a request to have an embedded report on a form be filtered to show assets that are only on the related mission that we are creating the BOL for. I am thinking that when you are adding a record, in this case, you are unable to have the embedded report already filtered because the record id is not created until after the save. Logically however i thought it was possible because when the record (BOL) is created, there is a mission no, which is on the BOL that i am creating, and their are assets that are already assigned to that same mission. However the embedded reports lists all, and not simply the assets that are on the same mission. Thanks in advance,------------------------------Bailey Desormeaux------------------------------
Hello! I have a pipeline that has been made better over time but isn't the most efficient thing. We have an hourly invoice. We add timecard to the invoice. However, one company wants some summary data we can only get by creating a record in a summary table. So the current pipeline: A. Timecards are added to an hourly invoice, and we have a checkbox to trigger the pipeline. B. The pipeline prepares a bulk record upsert to relate the timecards to the summary table.C. The pipeline searches for all the related timecards. For each timecard (loop):D. Add an upsert row to related the timecards to the summary table.E. Look up a record in the summary table, to see if it already exists. Condition: If not exists then F. Create itOut of loop. G Commit upsert to relate the timcards to the summary table records. What I would like to do is when I search the timecards initially I would like to get a list of the unique values for the summary table. Then use those uniqu
I am migrating an App from Legacy Forms to New Forms and having problem with adding child records from the new parent form. Example: Project table has a child table for 'attachments'. In Legacy forms, the add button launches the child form, where an attachment type is identified, User and date are populated, attachment of file is made and user is redirected back to the place in the parent form to view the child table. In New parent form I have added the embedded child table and can view the exiting records. When I click the Add Attachment button, it launches the child form, and when completed has following two issues: Does not populate the relationship field leaving the child record orphan Does not redirect back to the Parent Form at all The table relationship and adding of children records works fine using the legacy form, but fails when trying to add children records from New Form. What should I try?------------------------------Annetta Coleman----------
Does anyone know how to write a formula to do what the below rule does? With the new UI, it removed some build functionality to the rules and I can no longer use the builder to do it and need to write a formula. ------------------------------Elizabeth Schlagel------------------------------
I'm trying to find the number of records created in the last 24 hours using the following code, but getting a type mismatch error, any advice? Count(If([Date Created] > ToTimestamp(ToDate(Today()) - 1), 1, null))------------------------------Troy MacPherson------------------------------
Good afternoon, I hope this is possible, I am on a child table, i was hoping to be able to have a button that checks a check box, showing that an asset needs maintenance, then creating a maintenance report in the maintenance table. The table the button is on is not related to the maintenance table. So in my limited amount of url formula knowledge I suspected that I needed to somehow get back to the parent table which is related to the maintenance table, then go from the parent table, to the maintenance table to then create a maintenance report that will bring in that record ID, then bring me back to the table i started on. I created an action from the initial child table that when the checkbox was checked it created a new record in the maintenance table, but i figured it was not possible to get the related id over there because the place of origin, where the "needs maintenance" checkbox is checked, is not directly related to the maintenance report. I hope this makes sense. My current f
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.