Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Anyone else seeing this? twitchyReportSlider YouTube remove preview twitchyReportSlider Quickbase Twitchy Report Slider View this on YouTube > ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
I have two tables: Extracts and Vendors with a relationship that allows me to select a vendor for each extract (field Vendor Name). I have been asked to modify this so that up to three vendors can be selected for each extract record and I'm not sure how to make this work. I made copies of each of the Vendor fields I needed to replicate but when I select a vendor name for the first one, the fields for vendor 2 and vendor 3 are automatically being populated with the information for vendor 1. except for the actual vendor name. I also tried creating the fields for vendor 2 and vendor 3 individually but if I do that, I don't have the ability to add all of them as look up fields in my relationship because I can only have 10 and I would end up with 18 - 6 fields for each vendor.I've attached a doc showing my table relationship and a screenshot of the form showing what I am trying to accomplish. I want to be able to select a new vendor name for each one and have their r
Does anyone know if the new dashboards working on mobile is on the QB roadmap?@Evan Martinez------------------------------Michael Tamoush------------------------------
I currently have an App set up with the tables of Programs, Departments, and Positions where each Program has many Departments and each Department has many Programs. Furthermore, each Program added will have the same Departments and Programs attached. What I am looking to to either have the Related Departments and Positions be automatically created when the Program is created. Or, at leas a button that will cause that to happen once a Program is added.*Note - Currently the Positions table is only related to the Departments table which is of course related to the Programs table.------------------------------Chris Swirtz------------------------------
Hi All,I've got a table that's used as a scheduler so I know who is available and when. The assignments table is related to that table, but the parent table is the schedule table because one person's schedule could have multiple assignments in one day. However, I was hoping to cut down on having to have that report open when assigning work, so I was wondering if there is a way to display the schedule report on the assignments form to have it show everyone's schedule for today. In other words, I want to open the assignment form and see every possible person and their schedule, regardless of whether it's related to that record or not. I guess this would be like a hybrid of a dashboard/homepage and a form. Is this possible? In that same vein, I'd also like to see the current queue of assignments for everyone so I can gauge when someone will be ready for their next assignment.Thanks,------------------------------Daniel Johnson------------------------------
Is it possible to manually Trigger a Pipeline with a Rich Text Formula Field Button or some other method besides going into pipelines and clicking run? I have a Pipeline that checks the status in a Sharepoint List that I can schedule but I don't want it to run everyday if there are no open projects going on at the time. I do have it filtered so that it checks the status in QB before it looks at Sharepoint so it would technically not use run quotas if there are not open projects. I also might need it to run more often than scheduled and have another user run it.------------------------------Thanks for the help!Bert------------------------------
Anyone else having issues with pipelines triggering today?------------------------------Quickbase Pipelines------------------------------
I know how to create a new field that appears as a button on the page, and opens a pop up window. What I seek help in defining is the actual formula to open an external web page - Origin-Based and Destination-Based Sales Tax Rate - TaxJarThe purpose is purely to provided users with an external reference when adding a new Customer, so they can populate the tax rate that is applicable for the state in which the customer resides and the type of purchase (services, software, hardware, other).It does not need to integrate data or return anything at this point. I just want to open a new window with the website in it.Thanks!------------------------------Wade Myers------------------------------
I have a stacked bar chart that I'm currently using to both convey the overall completion status as well as the Status of 5 'project' phases (Prelim Activity, Prelim Design, Final Design, Bidding, Construction). It is a pretty functional chart that is used as a quick reference & has effective 'drill' down charts & reports, depending on the hierarchy at hand (Parent/child hierarchy....Portfolios containing projects, projects containing job files, job files containing scope of work items)Anyways, the main issue I'm having is with the X -axis labeling. The only each my peers/clients have with the chart is that the x-axis bar shows project completion 0% to 500% complete. If I try to re-scale to where each 'phase' is 25% of the project, then I loose the ability to be able to 'hover' over a bar & at a glance see that (example) 'Lakeview Ave' is at 40% completion of 'Final Design'. Is there a way to turn off the bottom X axis scale bar within a stacked bar chart in QB? Also,
We are auditing data that is on the internet. Our records contain data that is available on websites we subscribe to. The data is provided to us and we are to compare it to the data that is on the website. It would be helpful if we could see the web page that we are auditing on a tab in our form so it would be next to our data. The perfect option would be similar to the Web Page Widget for Quickbase pages. Each record would have its own unique URL to view. Is there a way to make this work with a Formula Rich Text Field? Thanks in advance for any help.
We have a URL button that generates PDF statements. With hundreds of customers that we run statements for each month, we are looking for a way to automate this URL button. Ive seen many asks in this nature over the last couple of years in discussions, has anyone come up with a solution. We cant schedule based on a date as that we dont always have data ready at the same time each month. Looking to automate on demand if that makes sense.------------------------------Michael Knecht------------------------------
We are expanding in a way that makes me need to restructure my app, so that as it grows it makes sense. The best example of what I need to do is with an employees table. I have an employees Table in App A. It has many relationships, both in App A and some cross app relationships (to App AB and AC).I am going to be creating a number of other Apps for other sister companies. They will share a few things, such as employees. Everything else will be separate.I would like to make a Global App, with the Employees table in it (and a few other global items). Then I would like to use table syncs to get the employees to each 'cluster' of apps (each sister company will be using a cluster of apps for themselves). I have chosen to sync, so that I don't end up with 15+ apps all related to each other in some way. However, I am open to suggestions on this.This leads me to my question. Ideally, I would move the Employee table to a global app, then in the original table A, convert the employee table to a
I am needing help in finding a formula for a Formula-Date field to show the last Friday of the Current Month by default when adding a record. I appreciate any help with this!------------------------------Tanya Hammil------------------------------
So I'm trying to setup a system that gets me a file of a set of entries from one table. I need it as a .xlsx, but I can convert the file from a .csv easy enough. I also need to mark all entries that are exported as exported. I'm hoping to get do everything from a single click, up to the export anyway (the file conversion can be done manually).So I'm currently looking at using a URL button to launch a code page. I'm using a report to pass the fields/data to be used and exported. I've managed to get the URL button to work. But I'm struggling with setting up the code page, mostly since I don't have much experience with Javascript. This has been enough to get the button to function for the download, but I'm having a hard time figuring out the next steps. I've got this far mostly by taking a large number of examples from others on here and playing around a bunch.I'm assuming I'll have to use the DoQueryCount and EditRecord APIs in a loop of sorts to update each record. I've got a simple che
Hello,My company communicates through Microsoft Teams and was curious if I can embed the calendar in there. Can anyone help me?------------------------------Anthony Wong------------------------------
I used to have a refresh button that when clicked will save the record and then open the record in edit mode. This button was using javascript below."<a class='Vibrant Success' onclick=$('#RedirectURL').val(document.location.href.replace(/&rl=[a-z0-9]*/,''));$('[name=rl]').val('');$('#saveButton').trigger('click'); href='#'>Refresh</a>"An alternative is to use belowvar text rid = If([Record ID#]>0, ToText([Record ID#]), "%%rid%%");var text url = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $rid;"<a class=\"Vibrant Primary SaveBeforeNavigating\" data-replaceRid=\"true\" href=\"" & $url & "\">Refresh</a>"But, the issue is when you are editing a child record that is embedded in the parent and do not make any changes to the parent record the browser displays a pop up that "your changes may not be saved". Is there any alternatives to prevent the browser from displaying the popup and automatically save and open the record in edit mode
Why am I getting this error with the following code? <qdbapi> <action>API_EditRecord</action> <errcode>102</errcode> <errtext>Invalid request - we cannot understand the URL you specified.</errtext> </qdbapi>URLRoot() & "db/" &"db/" & Dbid() & "?act=API_EditRecord"& "&rid=" & [Record ID#]& "&_fid_1021=1"& "&rdr="& URLEncode(URLRoot() & "db/" & Dbid() &"?a=dr&rid=" & [Record ID#]);------------------------------George Bramhall------------------------------
Hi everyone,I'm relatively new to Quickbase and I was trying to figure out how to set up a notification based on a user's last login date. Basically I want a notification to go to the employee when they haven't logged in to a particular app for ~80 days.Thank you!------------------------------Drew Harms------------------------------
I have a scheduled Power BI refresh from one of the QB reports, it has been working well for many months, but starting today, it keeps giving me this message: Expression.Error: The field 'sortBy' of the record wasn't found How do I solve this?Thank you!------------------------------xiaonan tang------------------------------
My experiences with the Quickbase Care team have been less than stellar. One of the most recent cases took more than a week to get a reply from the person "working" the case. Three of the last four support cases have not been resolved without issue. Is there anyone I can contact to address issues with the individuals working the support cases?@Evan Martinez------------------------------Paul Peterson------------------------------
Hello,I've made a field called CALL BUTTON (Showing as Called) as a formula - URLThis button is intended to add a note to a notes field called "Call Log". The note will be timestamped and label it as: "[Timestamp, User] Call made"Can someone support me with the appropriate input? Thank You ------------------------------Anthony Wong------------------------------
I have an application that is tracking regulatory approvals for several of our products. An approval can be applied to several products within the same family. Currently, multiple records have to be created manually with the same information and file attachment but a different product name. I am trying to automate this so that the user will be able to select multiple product names from a multi-select field and with the corresponding information and attachment and multiple records get created for each one of the products selected. I understand this is possible but how do I do this where I can get the document attached as well?Aprreicate any help!------------------------------Russel Ndip------------------------------
Hi,I have a report link on a parent table. When the user clicks on a specific record of the report, I would like to open a specific child table's form depending on whether a checkbox field of the parent table is checked or not. In other words I would like to display different child forms depending on the value of a parent table field. Is there a way to achieve that? I know it is possible to set form rules, but that is not my goal, as each form that I created has competing form rules with the others.Thanks.------------------------------Eleonora Ruffini------------------------------
Hello!I created a formula URL button that saves the record, but after saving, it displays the "User Not Found" Message. How can I show the record in view mode after it has been saved?This is the submit button code:var text Save = URLRoot() & "db/" & Dbid() & "?act=API_AddRecord&rid=" & [Record ID#]; var text Display = URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]; $Save & "&rdr=" & URLEncode($Display) ------------------------------Hakim S------------------------------
My app has several URL fields to enable the viewer or participant to link directly to sites within our enterprise. The project managers will be cut/pasting long URL strings into these fields so that stakeholders can directly link to those sites. We can easily ENTER a short URL (rare) and we can easily cut/paste a long URL into these fields. Problem: The link is not clickable. The only way we can get it to work is to <Right Click>, Choose "Select All", <Right Click>, "Goto ComplexURLString.com. Taking 4 clicks to get to the link does not meet the User expectations. How do we make the link clickable directly? ------------------------------Annetta Coleman------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.