Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I'm trying to make a button that will check a checkbox while I am adding a record. I made a button (formula below), but I can't use it on a add record. Is this something that is possible?var text rdr = URLRoot() & "db/" & Dbid() & "?a=dr&apptoken=[apptoken]=" & [Record ID#];var text Button = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#]& "&_fid_73=1" & "&apptoken=[apptoken]" & "&rdr=" & URLEncode($rdr);$Button------------------------------Angelina Newbern------------------------------
I am working on a document that will be printed by some of the end users. I found <div style="break-after:page"> </div> to force a page break where it is needed, but have not been able to find an inline CSS equivalent to prevent printing some of the form elements. Any suggestions to convert the following into inline CSS? @media print { .noprint { visibility: hidden; } } I'm not worried about using the noprint class, just need to find the style attribute that will not print certain form elements.------------------------------Paul Peterson-
I have a Pipeline that does a Bulk Upsert to create new records at a Parent Table. I would like the user to run this pipeline after they have completed their import of data into the Child Table. Rather than schedule the Pipeline to run unnecessarily every hour or force user to complete their import before a certain daily scheduled run, I am checking to see if a Button to trigger/run the pipeline is viable and if so how would I accomplish this.------------------------------Ruby Kapil, Windstream, Inc.------------------------------
I know the rich text fields only accept a limited set of HTML tags. I believe I saw a list of the available tags previously, but cannot find them now. Can anyone share the list of rich text fields that can be used in a rich text field?------------------------------Paul Peterson------------------------------
I have a report that displays each company employee and their tenure based on a hire date. I'd like to amend my formula to show the tenure calculated as of Dec 31st of the prior year versus it being calculated up to the current day of the year. Current Formula: var number Years = Floor(ToDays(Today() - [Original Date of Assignment])/365);var number Remainder =Rem(ToDays(Today() - [Original Date of Assignment]),365);var number Months = Floor($Remainder/30.44);var number CalcDays = Ceil(Rem($Remainder,30.44));If([Active],ToText($Years) & " Years" & " " & $Months & " Months" & " " & $CalcDays & " Days",If([Role] = "Private Market Agent", "PMA", ""))The "Tenure" displays as such in their record: Thanks for any help with this! Todd------------------------------Todd Molino------------------------------
If I want a button to open a record in edit mode, but also set fields, do I need to do this in two steps?Edit Record API (?a=API_EditRecord") followed by simply opening the record? Can this be done in one step?I feel like I have done this before but am forgetting.------------------------------Mike Tamoush------------------------------
Hello: I have a webhook that is posting to a 3rd party validation service and it's returning a response in XML. The service is also posting the response as "content", so it looks something like:content:"<?xml version="1.0" encoding="UTF-8" standalone="yes"?>Then the xml payload to follow. I need to access specific tags such as <status>Eligible</status>. What is the best way to parse an XML response and record it? The response is very long, so I don't need to record everything under content. Is there a better way to do this, or will it require some regex trickery to extract what I need?------------------------------Quincy Adam------------------------------
I have three tables:TrucksEquipmentScanned AssetsIn the trucks table, I have a summary field - Distinct Count - Scan Dates in the last 30 daysThe summary field works fine and the number is correct.I have the same field in the Equipment table, set up exactly as the trucks, the field doesn't work. Everything is zero.The scanned assets table shows a date and the info for the truck/equipment every time they are scanned. (Imported from a csv)Report links for both tables show all scans in 30 days but I need a distinct count for each table since they are tracked separately. Why would one work and the other not? Both use truck/equipment number as primary key, tables are nearly identical. Thank you------------------------------Steven Pearson------------------------------
I want to include a company logo image in notification emails. I see the insert image tool in the custom email message, but it is asking for a URL. Is there somewhere I can store the image in the app and get a URL? Also, will the person receiving the notification email need to be logged into Quickbase in order to see the image?Thank you in advance.------------------------------Paul Peterson------------------------------
I receive an email once a week with a file attached. I can choose if the file is xls or csv. The column names are an exact match to my field names so I can so a simple import (drag and drop file) to QB to upload. I am looking to automate that process. My issues:1. When using the csv, apparently there are multiple formats (UTF-8 and UTF-16). The file I receive is UTF-16, which can not be imported for a table sync, nor can be upload as an import. Essentially, QB, will not accept my csv.2. XLS can not be used for a sync table.Juiced tech has a couplet of add-ons that would allow me to do this, but getting two external add-ons to perform once simple import seems excessive.Any other ideas? Anyone run into the UTF-8/16 conflict before and have any work arounds? I could save as another file type, then upload to box to sync, but that takes longer than my current solution of simply dragging the file to import. Would love to have this last step automated.------------------------------Mike Tamous
I added one field to the form and it is little left aligned as compared to other input fields. How do I fix alignment? ------------------------------Mrunali Kadam------------------------------
I have read similar posts where the solution was due to application tokens turned on, however mine is turned off and I am still showing a blank page. When I put a button to the exact form page, without an associated Record ID, on a dashboard page, the blank template will pull up. However, the URL button I have on my form that is supposed to open the exact form with all fields populated from the associated record suddenly stopped working. Any ideas?
Hello,I am following the exact form guide on the Quickbase help page but I am running into an issue. As directed, on the word document I put all my field id#s in tildes but Quickbase is not picking them up as field ID#s but rather just text. So the output on the exact form is, "~15~" rather than the content of field 15. Has anyone else encountered this problem or has any insight into how to solve it. If I find a solution I will post it in this thread. Thanks in advance!Link to help page I have been using: Creating Exact Forms (quickbase.com)------------------------------Hank Halverson------------------------------
I'd like a button that directs a user to a report that is filtered to show records based on the record from which is was clicked.For example, the button lives on a Customers form. I click the button and it opens a report of Sales where Related Customer=[Record ID#] of the Customer I was on. Is this possible?------------------------------Raymond Sakar------------------------------
Last week I added a new field to a table form - its a URL field and the link opens a new browser tab displaying a png file located in another table in the same app. I have it selected so a button shows with the link, and its not editable (view only) for all roles.Its working fine when adding a new record, or when viewing/editing records added after I created the field. But older records are not displaying the link button.Any ideas why? Appreciate any help you can give!------------------------------Diane Sinawi------------------------------
Hello! I am a brand-new user to Quickbase in a Case Management role, and would like to start building my list of "favorite" reports. 1) Do I need to know the exact name of a report to search for it and add it to favorites? Nothing is coming up when I search "CM"2) More specifically, where can I find the CM hours report so that I can see which patients have already had their Case Management hours fulfilled for the week?Thank you!Maggie Wright------------------------------Margaret Wright------------------------------
Is it possible to add a selection to a multi select text field via a dynamic form rule? I know you can set the multi select field, but can you add a selection to what is currently selected?My use case is I have a multi select for requirements (Scope, Fall Protection Plan, Work Plan, Safety Plan, etc). I want to say, if complexity field is high, include work plan.------------------------------Mike Tamoush------------------------------
I had a quick question about leveraging quickbase to send out emails. Is there an in-built function to send out custom emails using Quickbase? I have already figured out a way to send templated emails by defining specific triggers but was struggling to find a way to send a custom email that an agent wants to send to a given email address. I was also wondering if there was a way to store these email conversations? One thing I could think of was introducing a new table to only store sent and received emails and setting up a relationship with the parent table to look up all historical conversations. Do let me know your thoughts.------------------------------Tushar Singh------------------------------
Hello,I setup a connected Table that contains decimal numbers using comma as decimal separator. The data looks like this: ID,Num_1 "1","1234,56" When I create the table the fields are created as type "text" and the number value look like in the import file (1234,56).After changing the field type to "Number - Currency" with the format "12.345.678,00" the number field will show the correct data 1.234,56 €.I then update the import file to ID,Num_1, "1","2234,56" and trigger a refresh of the connected table.After the refresh the value gets displayed as 223.456,00 €.It seems like in the update process QB does not recognize the decimal separator any more.Does anybody have an explanation or solution for this?------------------------------Martin Suske------------------------------
Yikes! Just typing that subject line has me in a tailspin...Hi everyone,I've created a few apps for managing different Microsoft, Service Now, etc. projects in our company. I've set it up so that the users can request access through QuickBase. Once the user is set up, the login info is sent to the store owner also from QuickBase. Our company is about to set up a centrally managed ID management system, which will remove the need for users to access QuickBase to place their requests, but they still want the login info emails to come from QuickBase.Management has asked me to investigate how to send the user info from the ID management system down to QuickBase and I have no idea how/where to start. I write some great apps, but when it comes to the big stuff, I have no clue. I raised a support case, but not sure if they'll be able to help me. Looking for a third-party to help us to sort through this. Any recommendations would be appreciated.Thank you,Kim---------------------------
I am attempting to create an advanced query for use in a pipeline. The desired conditions are date 1 is on or before today and date 2 is not blank. This is my first idea: {{'fid1'.LTE." & time.today & "}} AND {{'fid2'.EXE.'null'}}How close am I on this syntax?------------------------------Paul Peterson------------------------------
I built a pipeline to run daily but it did not run on it's first Saturday. Does "Daily" only mean weekdays?------------------------------Robert Kreibich------------------------------
is it possible to have calendar reports limit the hours that they show? I have a calendar report of daily appointments appear on my dashboard, but when I refresh the screen, it automatically defaults to showing 12 midnight and I'd like it to default to showing business hours.
If you’ve been enjoying Kiko’s series on “Journey of a new builder” blog series, I want to invite you to follow me, Esther, as I embark on a path towards Pipelines Certification. Why follow me? Prior to joining as an employee in January 2022, I knew nothing about Quickbase. I had very little coding experience - unless you want to count CSS and HTML on Myspace and a few rich-text boxes. That’s right, you read that correctly, “Myspace”. Six weeks after going through the University courses and plenty of hands-on practice, I was able to pass the builder certification and build my own custom application with multiple many-to-many relationships. Now I’m ready for the next challenge! Get me automated with Pipelines Gartner’s 2022 top four predictions for digital infrastructure boils down to this equation: Organizations who are actively investing in workflow transformation understand they’re playing the long game and investing in their future. To automate workflows among Q
Two roles exactly the same access to table and add ability but one role can see the add a record from the drop down and the other cannot. I am pulling my hair out to understand why this is. See the screenshots of the 2 roles: ------------------------------George Bramhall------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.