Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I want to add a check box, that when checked, it duplicates certain fields under the same section heading. And I want to be able to do this multiple times. I attached an example of what I'm trying to accomplish. ------------------------------Nichole Stebane------------------------------
How can I add a form to a home page?------------------------------Lori Pelzel------------------------------
I have an existing formula field which produces a number of text values based on different criteria. I am now creating a new formula field that looks at the first field to produce a reduced set of values.The problem I have encountered is that two of the values in the first formula field contain an ampersand - & - and my new formula field does not seem to see those values, and so is ignoring them when producing the output values.eg.ThisThatThis & ThatMy formula If([ex field] = "This", "One", [ex field] = "That", "Two", [ex field] = "This & That", "Three")However my output gives me a "One" and a "Two" but for the values that should be "Three" it just shows as "<empty>"Do I need to somehow escape the ampersand to make it find them in my other field? I have tried different ways I could think of:If([ex field] = "This \& That", "Three")If([ex field] = "This && That", "Three")If([ex field] = "This &amp; That", "Three")Is there something else I nee
I've read many posts regarding approval but I am yet to find an easy enough solution that will work for me. I am building a pre-travel request platform and the approval process is this: A Travel Officer submits a pre-approval request. The request is then routed to the following specified employees. Project/Line Manager (if specified, if not then 1st approver would be #2) Head of Unit Travel Desk Officer Finance Officer Final Approver At any step: The approver's response (Approve, Deny or Reject) should be recorded along with the date and time. the approver should be able to leave notes via a comment box. the approver should be able to reject the request to a previous step. Approvers should be able to record their responses by clicking a button in the notification email. I believe I build it out using a combination of ideas (buttons, pipelines, etc) found in various posts but I am hoping there is an integration, addon or extension out there that can simplify this build.-------
Hi, very beginner here, I'm struggling with the instructions for creating exact form , I'm at step 14, I saved a basically empty exact form and I just want to add a print button to a form I have as a proof of concept before adding variables to the exact form. But I can't seem to find what step 14 is talking about. Any help is very appreciated. ------------------------------Ayoub Salhi------------------------------
Hello - Is it at all possible to copy a form from one table to another? Thank you!------------------------------VW------------------------------
I'm trying to create a an exact form that I can use to customize printing my invoice, I follow the instructions in this article https://helpv2.quickbase.com/hc/en-us/articles/4570390477588-Creating-Exact-Forms-Step 11 - I click Sign in and I'm getting this error. Please help...thanksWord 2016 (32 bit) ------------------------------Ayoub Salhi------------------------------
I'm working on a formula for the following: If Booking Agent is Kelly [text field], then Kelly's Split [percentage] is 75% and YTC's Split [percentage field] is 25%. So, I'm trying to get the percentage fields to prepopulate when Kelly is the Booking Agent. Is that possible? Thanks in advance for the help!------------------------------Khalid Daoud------------------------------
I have a picture in a file attachment field, and I am trying to combine it with a caption, but center the text under the photo. I can get a thumbnail of the photo and append text to it (with a line break), but am not sure how I would center. Is it possible?------------------------------Mike Tamoush------------------------------
Hello, I've been racking my brain on why I'm able to search and select values for the "address-field type: city" in the dynamic filter in one app vs. the other. All the field settings are the same on both of the apps. What am I missing? Any suggestions/ideas would be much appreciated! ------------------------------Dee Tamang------------------------------
Where does the Report Link come from? How can I tie Number to Number? ------------------------------Sarah Burres------------------------------
Anybody have experience connecting to a Quickbase app from SAS.I am using a PROC HTTP function following the SAS and Quickbase API documentation.However, my API connection is timing out. I am getting the following errors.Is something I need to check for on the Quickbase side?ERROR: Error connecting to 104.18.101.99:443. (The connection has timed out.)ERROR: Error connecting to 104.18.100.99:443. (The connection has timed out.)ERROR: Unable to establish connection to mycompany.quickbase.com.ERROR: Unable to connect to Web server.Here is my sas code with user token masked.proc httpurl=%NRSTR("https://mycompany.quickbase.com/db/mytableid?a=API_DoQuery&query={6.EX.'01-26-2022'}&usertoken=xxxxxxxxxxxxxxxxxxxxxxxxxx")headerout=headersout=responseHTTP_TOKENAUTH;run;------------------------------George Romanowski------------------------------
Hi! An old company I worked for used Quickbase years ago and I'm trying to replicate something they did with documents. Can someone help me achieve the need below? Process need: When we upload files to our Documents table, we want a YELLOW status to appear. When they are reviewed, we'd like to approve (GREEN) or reject (RED) them. If the doc is not uploaded, we'd like to see a GRAY status box. My start: Created the following fields: "Document Name" Multiple Choice (Ex. "Permit" could be selected here) "Approved" Checkbox "Rejected" Checkbox Created the following fields for EACH document listed in the multiple choice field: Ex. "Permit: Uploaded" Formula - Date:ToDate([Date Created]) Ex. "Permit: Status" Formula - Rich Text:If(IsNull([Permit: Uploaded]), "<div align=\"center\"><img src=\"https://images.quickbase.com/si/16/226-rect_gray.png\"></div>", If(([Approved] = false and [Rejected] = false), "<div align=\"center\"><img src
Hi there! I am trying to find a way to generate up to 12 records in pipeline depending what checkbox is checked. I am wondering if there is a way to loop the pipeline?------------------------------Olena Bilinska------------------------------
We have a table for training materials. I need to be able to have a record in the table and have it associated to other "related" records within the same table. I.E. We may have a record that is video training and have another record that is written user guides but both are on the same topic. We would like to connect the records as "related training" so the user can view an embedded table of all the associated training material. I have created a relationship where the table is joined to itself and there is the embedded table, but I cannot figure out how to select multiple records to add as related training. ------------------------------Stephanie Meyer------------------------------
I'm trying to create a copy button to copy a record in a table. The table is not showing in the APP MANAGEMENT - Copy Master & Detail records (choose table) field? Please advise. Thank you.------------------------------BuildPro------------------------------
I have a button that sets a checkbox and a timestamp and I would like to redirect back to the report. I have added the native return to where you cam from but I get an error. Here is my formula: URLRoot() & "db/" & Dbid() &"?a=API_EditRecord" &"&rid=" & [Record ID#] &"&_fid_34=" & true &"&_fid_35=" & Now()&"&z=" & Rurl() Here is the error: <qdbapi> <action>API_EditRecord</action> <errcode>0</errcode> <errtext>No error</errtext> <rid>3028</rid> <num_fields_changed>1</num_fields_changed> <update_id>1678144272405</update_id> </qdbapi> When I put in the statement to redirect to the saved record, it works. It is setting the fields so the edit is working. How can you redirect back to the report that the button was clicked from?------------------------------Julie Meeker------------------------------
Can someone help point me in the direction of doing the project condition field? Is this an image or a formula? Looking to set this up to add the health of a project into a report and the only instructions I could find was around color coding the field. Thank you! ------------------------------VW------------------------------
Good afternoon, I'm looking to setup my QuickBase app in a way that I can counter how much time each organization is spending to manage each record added in my table. Let's say that I have 3 organizations and 3 people are working on an issue/record like so: Organization (1-3)/user John Maria Ana - A record is added to a table by John from organization "1" with the issue: Package arrived to the wrong destination. John's record creation has the time stamp 01.03.2023 10:00 AM - Maria from organization 2 is accessing the record and asks for additional details from John. Maria's request inside the record has a time stamp 01.03.2023 10:10 AM and the request is sent back to John, organization 1. - John from organization 1 replies with the details at 01.03.2023 10:40 AM - Maria is adding additional details to the record and forwards the issue to Ana from organization 3, at 01.03.2023 10:50 AM - Ana from organization 3 is requesting additional detail
Hi everyone, I'm having fun incorporating the Gantt Plugin into an existing app however have a question around the date formatting. Does anyone know if there is a way to show Monday as the first day of the week in the date picker instead of Sunday and also whether the date can be formatted as DD/MM/YYYY instead of MM/DD/YYYY. This is confusing for us poor NZers who are not used to this format!------------------------------Elise Salt------------------------------
Hello All, I have a combined text summary field that seems to only sort by record ID. I thought that combined text summary sorted alpha? I have a put a number in front of the text field but its not changing. Example 17, GPI-BIL 7, BIL-GPI Help!------------------------------Sam Rettig------------------------------
Please help me make this work...thx If([BUDGET.030123]=true,[Job - Copy of Related Projects - Window Wrap-0 Sides]=true,([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.65),[Job - Copy of Related Projects - Window Wrap-3 Sides]=true,([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*0.85),[Job - Copy of Related Projects - Window Wrap-4 Sides]=true,([Related Priced Spec2 - Related MPS2 - Corner Bead1-1/4X9' Metal/Box $]*1), [Job - Copy of Related Projects - Window Wrap-0 Sides]=true,([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*0.65),[Job - Copy of Related Projects - Window Wrap-3 Sides]=true,([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*0.85),[Job - Copy of Related Projects - Window Wrap-4 Sides]=true,([Related Priced Spec2 - MPS - ID-Corner Bead1-1/4X9' Metal/Box $]*1) ) ------------------------------BuildPro------------------------------
Help! I'm trying to retrieve the last comment on a table, but I am ending up with the one above the last one. Any help would be greatly appreciated! Example of field (comments): [MAR-03-23 11:21 AM Crystal] Updated Screener [MAR-03-23 11:22 AM Crystal] .[MAR-03-23 1:35 PM Nicole ] confirmed approval, MILITARY LEASE - used LES for POI[MAR-04-23 12:45 PM Megan Botti] Added MID + Concession Expected: [MAR-04-23 12:45 PM Megan Botti] Added MID + Concession) but it is returning the one aove it Returned: [MAR-03-23 1:35 PM Nicole ] confirmed approval, MILITARY LEASE - used LES for POI FORMULA If(Trim([Comments])<>"", "[" & Right(NotRight([Comments],"["),"["))------------------------------Stephanie Bouldin------------------------------
I ran into an issue with our Work Order calendar report showing the appointments at the top rather than in their respective time slot. I did some research and realized the issue is stemming from me trying to utilize two fields – one to track date and one to track time of day. I need to use a date/time field specifically that holds both. If I were to use a formula-date/time field to combine existing data, how would this formula look? My fields are "Work Order Date" and "Start Time".------------------------------Jillian P------------------------------
Use Case: I have a "Project" Parent Table with an associated "Intake Worklists" Child Table. The child table is populated with n number of Product Team Records (currently 7 Product Teams) via a pipeline. Each Product Team goes to the child table to self identify if they are impacted by the Project and several other Product Team specific responses related to the Project. I have summary fields in the table relationship that bring individual Product Team values back to the parent table to indicate each Product Team that is impacted. I want to be able to populate a single Formula Multi-Select Field with the Product Teams that are impacted. I have tested that the summary field for each Product Team is bringing back a value of "1" if the Product Team is impacted by the Project. I am struggling with the formula to populate the formula multi-select (text) field. If and Case conditions do not seem suitable. Please help? ---------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.