Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
We utilize the check icons (i.e. ), but have used every color available (red, purple, blue, cyan, green, black, yellow). We need to use additional versions/colors for a few other use cases. Has anyone modified and/or created custom versions of these icons in different colors? ------------------------------Chris Green------------------------------
I would like to embed a photo on either a Dashboard or Home page. What's the best way to go about this? I have the photo in a google drive and have the shared URL, I also created a Miscellaneous table with the photo as a File attachment. Any ideas would be appreciated. ------------------------------Julie Meeker------------------------------
Hi all, I want to create a pipeline that sends a template to be signed by our clients and the sales rep. I dont know how to populate information of my quickbase tables in the documents, not in the signer information, but in the information of the document to be signed. Does anybody did this? I need some help! Thanks!------------------------------Francisco Ojeda------------------------------
Hello, I have an app where I have two tables for Location Codes. One is a sync up with SAP for All active Location Codes and the second table (Location Code request) has a form to Change or request the creation of a new Location Code. In the Location Code request form I also have a STATUS field that tells us if the request is New, in-process or Completed. Of-course if it is completed, it would mean the New Location Code has been created in SAP with the next sync up run (which is daily) and my SAP for All active Location Codes table will now include that New Location Code record from Location Code request table. Now, I have another table called Asset forms where users can create an Asset Capitalization request and as part of that form can choose from the 'existing' (SAP for All active Location Codes) table or choose from an 'in-process' (Location Code request) list. In the in-process list, we did not want the Location Code requests that had a status of 'Completed' as thes
Hello, In simple terms, I have a code page which is triggered by a user clicking a formula url button. Once this happens, the application is updated via api's. My question is, is there anyway to utilize pipelines to automatically "click" this button (there is only 1 record on this table) or run the same formula within the formula url button to trigger the code page on a scheduled basis? This button needs to be pressed on this record since it captures some data from the record/ table it lives in. Eventually there may be one or two records more, so I would like to keep this aspect of it dynamic Thank you for your time------------------------------QuickBase Administrator2------------------------------
Not sure how to explain this, but our environment has multiple applications. I know I can show/hide them from the My Apps page, but that removes the App from both that page and the tabs across the top of the screen. Is there a way to hide the tab but keep the app listing on the My Apps page?------------------------------Ember------------------------------
I used to make custom buttons for dashboards in this way: Lets pretend I want a button to edit a record, then used NextURL to navigate somewhere after the user saves. I would make the button in any form, it would look something like this: URLRoot() & "db/bsw7f8fs5?a=er&rid=1" & "&NextURL=" & URLEncode(URLRoot() & "db/bskibtta8/tablereport?a=q&qid=8") This is a simple button to edit a record, then navigate to a table report. When you click the button, you would get something like this: https://myrealm.quickbase.com/db/bsw7f8fs5?a=er&rid=1&NextURL=https%3A%2F%2Fmyrealm.quickbase.com%2Fdb%2Fbskibtta8%2Ftablereport%3Fa%3Dq%26qid%3D8 I could simply copy/paste that URL into a dashboard button, and voila - custom button on my homepage or dashboard. However, now when I click that custom button, it seems to work for some people, but not work for others (like myself). It makes me think whatever is happening in all the magic code at the end, is
In my Asset form, I have two fields Asset Class and Eval Group 1 that are related. Both are drop down fields in the Asset form. Each Asset Class selected will drive a dropdown of a subset of values in the related field Eval Group1. That is the top line below if chosen as the Asset Class will have the rows under that show up i the drop down for Eval Group1. Computer_Equipment - Asset Class Office_Equipment - Asset Class MCE - Misc. Computer Equipment OFFC - Office Equipments SERV - Servers COPY - Copiers PC - PC, Laptop, and workstations PHON - Phone Equipments PRNT - Printers So, i have all of this set up and working fine. During testing, my analyst noticed that if she selected Computer Equipment and then correctly selected say "PC" for Eval group, she could then go back and change the Asset Class to something else and the form would allow that. How do I create a Custom Data rule at the table level to stop this from happening? I thought if I could say, if value of "As
I just saw the Release Notes for this month and the Inclusion of Fastfield. https://www.fastfieldforms.com/index.html Anybody got real world feedback on the development and how the User likes it? I have a client with a Facility Inspection Application. It runs great on the Desktop. The Mobile experience is worse than a root canal. ------------------------------Don Larson------------------------------
First I would like to note we're using new forms in case that affects any functionality. My question is we have a call center ticket table with a user list field called 'Assigned To'. Then we have a 'Reassignment Comments' field. When 'Assigned To' is changed the user is supposed to fill out the 'Reassignment Comments' field and list the reason why they're reassigning the ticket. However, user's always forget to fill it out. Is there a way to make 'Reassignment Comments' required, if 'Assigned To' has been changed?------------------------------Kaitlyn Stanley------------------------------
Hi, Apologies if this is already asked and answered but I didn't find it. I have a table called activities. Each activity in the table has a list-user field called activity team. I'd like to be able to have a report showing every user in my app and how many times they appear in the activity team field. So the output would look like user a shows up in 3 activity teams, user b shows up in 2 activity teams, user c shows up in 7 activity teams, etc. Any suggestions on how to do this? ------------------------------Lester Bird------------------------------
Looking to make a simple bar chart showing the totals of actuals and estimates. Table is attached. I just can't figure out how to do. I did have a column I deleted that was "Budget Type" that has Actual vs Estimate. I would rather not have to do that. Gotta be a way to do it with structure as is, right?------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I have used formulas in this program for a while now and have had no issue until recently.The field this formula is stored in is a text-formula type.Formula:If(//Checkmark Boxes[Billed]=true,"Billed",[Invoice Drafted]=true,"Invoice Drafted",[Approved]=true,"Approved",[Hold for Authorization]=true,"Hold for Authorization",//Reading Billing StatusBegins([Billing Status (Billing Team ONLY)],"Billed"),"Billed",Begins([Billing Status (Billing Team ONLY)],"Invoice Drafted"),"Invoice Drafted",//FormulaContains([Service Billing Adds (Memo required)],"**NOT BILLABLE (Leave Comment)**"),"NOT BILLABLE",[Project - Total Task Remaining Hours]>0 and [Project - Total Task Remaining Hours]<1.5 and [Project Type]<>"Advisory","Hold for More Time",[Billing Family - Total Over Set Days (Connection)]>0,"Approved",[Billing Family Approved Total]>500 and [Billing Family Approved Total]<1000,"Approved",[Billing Family Approved Total]>1000,"Hold for Authorization","No Rule for This")Now
Hello! In the attached screenshot I've been trying to get it such that I can either change the 'Totals' column into a column which contains the delta between the two sales year, or add a column that does that. Is there any way on a summary report to add a column that looks at the difference between two previous columns?------------------------------Blake Burns------------------------------
First time getting this error message? Is there a common reason for this that I can go look at to correct?------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
I believe this is a conceptual question, that likely ends up in app design basics. I am going to have LOTS of apps across my entire organization, a local municipality. Many reports will be based on calendar year and that's pretty easy. However, many apps, tables, reports will need to be based on Fiscal Year. I have seen in the app properties where to set the FY parameters. That's very helpful. But, the problem I am running into is how do I report on FY? The dynamic filters based on a date field can do this quickly, but only for as far back as two years. I have several years of data I will need to import for lots of items. I have a formula I can use to create an entry in a FY column. But, this field is a text field and gets treated as text, not a date. Along those lines, many records are entered and associated with a Month, not an actual date. I realize I could just use the first or last day of the month for these
edited for clarity We notice when Users insert large images into Rich Text fields in New Style Forms, the image extends beyond the edge of the Rich Text field. We would like the image to be constrained by the Rich Text field boundaries. Any ideas? ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
I have two different charts that show new data vs. completed data. It is difficult to look at these side by side because their scaling does not match due to Quickbase's autoscaling. Is there a way to override this so I can make both axis's have to same amount to compare apples to apples? Example: both axis's show 250. ------------------------------Elizabeth Schlagel------------------------------
I have an exact form and a formula URL on the record's form that displays the data on the exact form template: var text ID=ToText([Record ID#]);"https://xxxxxxx-xxxxxxxx.quickbase.com/db/xxxxxxxxx?a=dbpage&pageID=10&rid=" & $ID&"&fullver=1" For the desktop/non-mobile form users are able to save because the exact form has: <script>setTimeout(function() {this.print()},3000);</script> But this does not happen for those using the mobile app, it keeps the user in the QuickBase app and does not easily give an option to ultimately save as a PDF. 1) is there any code to force the mobile user out of the app and into their browser? or 2) Is there a rich text formula that the mobile user can click on to either save as a pdf? or 3) Is there any pipeline where the exact form is saved as a pdf in the record? Flexible for any solutions outside of the the above 3 It would be ideal for a pdf/doc to be created but worst case am open to a web browser mobile app frie
I currently have a Date and Time Field, I want to insert into a Outlook pipeline. Is there way to show only the date and time versus the date and time + 00:00 Below is the line in the inserted in body of the email and the output <p> Invoice order for {{a.event_date}} </p> Invoice order for 2024-01-18 18:00:00+00:00 ------------------------------Willis Taylor------------------------------
I feel like I am missing something obvious. I have a table of Properties. One field (numeric dropdown) states how many Drinking Wells they have on the property. One field states how many Irrigation wells they have on the property. I want a pie chart that compares the number of total drinking wells vs non drinking (irrigation wells). If I had a wells table, and each well was labeled Drinking or irrigation this would be easy. But somehow I am just not seeing how to do this in my current format. A single record may contain a number of drinking wells AND a number of irrigation wells, and I can't figure out how that record is represented on both chunks of the pie chart.------------------------------Mike Tamoush------------------------------
We want to create a report per team that tracks what work is assigned to each person. We have 12 fields on a resource tab that a person could be listed under. How can a report be set up to show how many projects for that one person, or each person on a team when there are 12 different roles they could play on a project?------------------------------Kari Lang------------------------------
I am going to TRY very hard to describe this accurately. Thanks for your patience. I have a simple cost tracking app. Three tables - Agreements/POs/Invoices. Each of those is a one to many relationship. 1 agreement has many POs, a PO has many invoices. On an Agreement record, I click "Add PO". The first field that shows on this form is Related Agreement. Love it. In the picker it shows the attachment below. When I pick the proper agreement, it shows me the Division when I want it to show me the Contract Description. Second, I would also like for Vendor to be pulled automatically and shown in what would be the next field displayed. I realize I only get to this form from a button, but I would still like to show the actual agreement and vendor, just for reference. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Dire
I have a form that I want to have different required fields based on the selection of another field. I created 4 different rules for each selection option but it's causing a problem. It appears that the rules are conflicting/overlapping. How can I remove the "otherwise" and "then" part of the form rule? I basically want the rules to run only when triggered so that each one runs independently. screenshot for references about "otherwise" and "then" ------------------------------L. Green------------------------------
I have an application that where the Users are answering questions on the mobile EOTI. I have built links in the question records for executes an API call that records the answer. I need the user to redirect back on the list of unanswered questions. The RDR works great on the desktop var text ReportLink = URLRoot() & "db/" & [_DBID_TEST_QUESTIONS] & "?a=q&qid=13&nv=1&v0="& Urlencode([Related Test]); On the mobile I am not sure where they are landing but it is not my nice orderly report. Anybody seen this behavior before and have a solution?------------------------------Don Larson------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.