Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Sam Trachy's Daily Office Hours won't be back until January 6th. It's also worth mentioning that Orientation Office Hours is back on the 7th. Have a fantastic holiday everyone!
I'm finding that when I select a group of users to receive a report subscription, the email is sent separately to each recipient.This is not terribly useful for management reports. I would like the group of recipients to be included on the message together, so that users can "reply-all" and discuss, ask questions of the data in the report.Is there a way to accomplish this in subscription settings? Thanks,Mike
Created a form that has a file upload section. This section allows people to submit photos of themselves. This is used for Medical purposes, we need to print out records to include the uploaded image. Initially this worked as intended by displaying the picture when printing. Once this was officially put in production, it stopped displaying the image as intended.the test record: Print preview: The print preview used to show the uploaded image on the record but now its just the file name.
Apologies if this has been covered elsewhere, couldn't find any help articles or posts that covered this via search.I have reports I've built with filters (that take a while to click and set).Looking for ways to take an existing report, copy the settings, but select another type of report or another type of chart without having to reprogram all of the filters and report settings from scratch each time.Can I:Take an existing Report and convert it into a Chart Report?Take an existing Report and convert it into another type of report?Take an existing Chart Report and convert it into another type of Chart Report? Thanks,Mike
Thanks to those of you who have helped me get this project manager up and running! I'm encountering I think the last issue related to this specific workflow I'm trying to tackle. When marking off a task on project 5, I want it to create a task on project 8. This is currently how I have it set up, but changing the task in project 5 to complete does not trigger the pipeline to start.
Hi, I was wondering if anyone can figure out how to avoid saving a record with duplicate attachments.The scenario is as follows: I have created a new version form and added three fields attach type. These are mandatory. In legacy forms, this works partially because as I only validate that the name is not identical between the attach type fields. But quickbase has no validation at the level of the attachment field content level. Thinking outside of the box I have implemented the following dynamic formula to avoid saving, when these attachments are duplicates. But when I implement this dynamic rule in the new version of the form. it doesn't work.
Hi all. I have a webhook for Table A, and I want it to run a Table to Table Import into Table B whenever records are added to Table A. Here are the details of the webhook:Enpoint URL - https://amzl.quickbase.com/db/*********?a=api_runimportBody - <qdbapi><usertoken>%user.token.************%</usertoken><id>12</id></qdbapi>I'm still new to QuickBase so I'm never 100% sure with what I'm doing but I'm guessing the "12" is referring to the ID of the import.
I'm helping develop an app to track and reserve company vehicles. One of the requirements given to me was to prevent scheduling conflicts for the vehicles - essentially not allowing any overlaps for a given vehicle. I have searched this before and I found some answers on these forums that helped point me in the right direction but I'm still coming up short.What I've done is pair two formula queries into a field that would check for start and end time overlaps and add the queries together. The field is simply called Conflicts and if it is over 0, I know there is a conflict. My issue is two-fold.The first formula I used and works (sort of, we'll get to that) isSize(GetRecords("{7.OAF.'"&[Start]&"'} AND {7.OBF.'"&[End]&"'} AND {10.CT.'"&[Vehicle - Vin Last Four]&"'}",[_DBID_RESERVATIONS])) + Size(GetRecords("{6.OAF.'"&[Start]&"'} AND {6.OBF.'"&[End]&"'} AND {10.CT.'"&[Vehicle - Vin Last Four]&"'}",[_DBID_RESERVATIONS]))First things first is
Made a scheduled pipeline to look at a "formula - duration" field on Table A (Calendar) that signifies how many days until an event there are. If it is between 0-75 days, it should create a new record on Table B (Project Manager). For some reason, however, its just returning 0 records, and going through as successful. Even though I have a record where the column is 5 days away. I will continue to work on this, but I didn't know if anyone might have some ideas why it is not seeing this record on Table A and making a new one on Table B?
I'm encountering I think the last issue related to this specific workflow I'm trying to tackle. When marking off a task as complete on project 5, I want it to create a task on project 8. This is currently how I have it set up, but changing to task in project 5 to complete does not trigger the pipeline to start.
I have a grid edit table report that requires the user to select the "Related Content Allocation" before editing the rest of the columns/fields. However, the dropdown is displaying the related field's record ID, which isn't very user-friendly. Is there a way to display other related field values in this dropdown rather than the record ID# easily? ------------------------------Matt Makris------------------------------
Hello Construction Qrew! Thank you to all who were able to attend Tuesday’s Construction Meet Up. Here’s what we discussed: Kaity Strong-Steele, Solutions Consultant, shared the power of the Procore-integrated-Quickbase experience. Customers who can leverage both Procore and Quickbase to manage materials tracking, bulk updates, customize access reports , while leveraging the enhanced project management features are at the cutting edge of construction technology. It’s not about making your workflows fit around a technology - it’s about making QuickBase's agile capabilities fit around you. A huge difference in the market. Speaking of making technology fit your needs, Rob Salaj, Customer Advisory Director, shared how the present and future Construction Apps in the exchange are being built with customer use cases in mind. As these apps continue to roll out, we will continue to highlight the customizable capabilities show where you can make impactful change. Next, Ro
Does anyone know how to add a link to new notifications? In old notifications you can simply make a rich text link and reference the field, but in the new notifications it just shows the rich text field as text.My use case is: The notification fires from a child record, but I want to be able to have a link to the parent record in the email.
Working in a Business management app of multiple companies with all their job info/history. Have created a summary report showing monthly revenue and GP %, with the columns grouped by month so the total rows are YTD totals for each customer. Is there a way to make it only display top 15 customers? It is auto set to alphabetical with sorting disabled because of the cross tab sort... Ideally i could sort them high to low by the YTD total rows, but it is not an option. Any ideas how to navigate this? Some companies have 100+ customers so it looks horrible as is.
Is there a way to add basic text formatting in field help text (not in legacy)?I want to add a space break between 2 short sentencesWhen I try, my field help text simply returns lorem ipsum<br/>lorem ipsum2instead of formatting itself like:lorem ipsumlorem ipsum 2
I have a Projects table, with a button in the form which opens in a new tab a single page application contained in a code page.The link looks like this:https://realm.quickbase.com/db/abcdefgh?pageID=17&projectId=81902&a=dbpageThe &a=dbpage was added so that the code page loads wrapped by the Quickbase applicaton interface (with the tables in the left navigation and the header at the top).Recently I noticed that this doesn't work any longer and the page opens in a blank page. Is there a way to fix this?
Hello,Does anyone know if they've released similar functionality to the legacy forms that allows editing embedded reports?We have a new form that needs a child relationship to capture n-records. The problem is that this record creation is available to EOTI and they should only be able to Add Records, not View or Edit. In other words, if they navigate away from the record they're creating (parent) to create a child they'll never be able to get back!
Hello,Has anyone found a more elegant solution to the problem of a list of user identifiers like ID's, usernames, emails, and casting or converting it to a UserList data type?I have found people mentioning a variation of the brute force approach which is essentially what I use. I have a count and conditionals to try to reduce needless processing. My total runtime is 0.073 seconds.ToUserList( If([Related Users - Count of Viewer Users] > 0, ToUser(Trim(Part(ToText([Related Users - View Access]), 1, ";")))), If([Related Users - Count of Viewer Users] > 1, ToUser(Trim(Part(ToText([Related Users - View Access]), 2, ";")))), If([Related Users - Count of Viewer Users] > 2, ToUser(Trim(Part(ToText([Related Users - View Access]), 3, ";")))), If([Related Users - Count of Viewer Users] > 3, ToUser(Trim(Part(ToText([Related Users - View Access]), 4, ";")))), If([Related Users - Count of Viewer Users] > 4, ToUser(Trim(Part(ToText([Related Users - View Access]), 5,
I'm trying to write an If statement in Pipelines for an email that if the Separation reason is retirement, do a line break and include the field value for if they are staying with the company as an instructor. If the reason is anything else, do a line break and move on to the next line.{% if a.reason = "Other - Retirement" %} <br>Staying as Instructor:<b> {{a.instructor}}</b><br>{% else %}<br>{% endif %}This is the same-ish format I was using for another Pipeline and it works just fine so I'm so confused as to why this one isn't working. The error says Incorrect Template. expected token 'end of statement block'. got '='I want it to look like this if true:Reason: Other - RetirementStaying as Instructor: Yes/NoNext line: ValueIf False it should look like this:Reason: Other - ResignationNext line: ValuePlease help!! Thank you!
One of the few things I ever said that Quickbase lacked was design capabilites, particularly in form design, and when I saw that they were making changes to that I was pumped. Now that I have used it a bit, I am scratching my head... Although I do love some of the options they have added, why would you take away things like being able to have the field label on the side or on top? And the addition of columns was great! But why take way the ability to have a couple small fields still be able to be on the same line within those columns? I'm trying to mimic a form that is currently in Excel and the section that currently only occupies only about a 3rd of the page, a user will have to scroll down to finish entering all the info because of the spacing. Am I missing something or does forms design still need some work?
Using a Formula-Numeric type, I'd like to grab the number of records that exist in another table that resides in another QB application. Can this be done?I thought I could run a query, then use the "Size()" function on what was returned but that is not working out so well.Any suggestions?------------------var text QueryURL = URLRoot() & "<dbid>?a=API_DoQuery&query={3.GT.0}&apptoken=<apptoken>";Size($QueryURL)
Hey all! I had a user point out that she had a log in date on a day she was on PTO, she definitely DID NOT log in that. So I started in the audit logs and found 152 users that had been logged into that day, under QB Internal. Does anybody know what this is? I color coded the users, some were logged into back to back.
Hello,Are there any suggestions for training (be it online or in person) where you can get some hands on experience with integrating a QuickBase app with other software applications? I constantly see references and online discussions about the concept of doing this but, I have yet to actually see anything like a practice module or something to follow along with. I see a lot of job opportunities where they want you to know how to do this stuff but, I have yet to have any experience with it. I, also, don't fully understand things like where to find the URL from the software that you want to use with REST, etc. The examples I have seen give you the exact URL for the use case but, don't explain the concept of how to get the URL. In the past, I asked a similar question and was just told things like, "learn JavaScript". That is too broad of a suggestion. I see platforms like Coursera that give you projects to complete to go with your education. It would be nice if QuickBase offered such thin
Hi Everyone, I hope you all can make it to the 2024 Year in Review Product Webinar! Join us Tuesday at 1pm EST for this session! This thread will be a placeholder for anyone who has questions post webinar. Our product and product marketing team will be here to answer any questions that do not get answered during the webinar.
I have a user whose buttons to the right of the new record are being hidden almost instantly. Toggling off the New Style the buttons are back, and the "More" menu is there, including import/export.Their view with the buttons missingThey do not have access to all of the buttons there, but they should have download, grid edit, and the 3 dot more menu that includes import/export, print, etc.My view for comparisonWhen they initially load the page the 3 horizontal dots appear for a second or so and then it is hidden.I'm under the impression its a local issue. I'm not sure if its Chrome, an extension or what. Thus far I have not been able to find a setting that is impacting this directly. They are using the old style as a work around for now. I want to identify the source so they don't have to keep hitting that toggle every time they load a table. My next step is turning off the extensions to test those, but in the mean time I thought I'd put feelers out for feedback here.Ha
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.