Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Has anyone implemented a lot of formula queries (100+) in their app?I have only implemented about 20, and I love them, but am afraid of performance issues. I am wondering if anyone has used a lot - if so how many, are they on large tables, and are you having any performance issues?I could make 1000 to help me if I wasn't worried about performance, but I don't have any concept of what is 'a lot' of formula queries.Is 50 a lot? is 500 not very many? Are they expecting users to have 1000 formula queries or 20?------------------------------Mike Tamoush------------------------------
In updating a date field with a pipeline, under certain conditions I want to set the date field to null. What do I insert to in the update schema to achieve this. I can't save the pipeline buy just leaving it blank.------------------------------George Bramhall------------------------------
Is there a way to embed grid edit reports onto a Dashboard page? Use Case: Project Managers would like to have a dashboard page, filtered by their impacted projects that displays 3 side by side grid edit reports to quickly Edit Decisions, Risks and Actions, which when saved would immediately recalculate dashboard gauges. Considerations: Opening a table report and editing from there within the dashboard is very clunky and only one table at a time. I recognize I could easily build a form that would enable embedded child tables, but then lose the ability to filter the parent table records. What am I missing?------------------------------Annetta Coleman------------------------------
Good morning,I have a dashboard that we use to take a screen shot to send out updates. Suddenly, one of my reports does not fit, as the columns are wider. I read someone else's post about dragging the column width. This works in the actual report, but they are still too big on the dashboard version. I saved the report, then deleted and added it back to the dashboard, but it doesn't stick. Any suggestions?Thank you,Kim------------------------------Kim------------------------------
Hello,I am creating a new app for managing travel expenses. I have a tasks table in my main ERP system that my users use. Can I create a formula rich text button in my travel expense app using formula url's to create a task in another app? I have done it within the same app many times but when I try to do it, it is not recognizing the table (presumably since it is in a different app)------------------------------Ivan Weiss------------------------------
Hi Guys,I need your help and inputs given the following:BACKGROUND:Our QuickBase app is designed to send out mails to users when a user needs to 'Approve' a certain record in one of the tables.The goal is to enable users to 'Approve' from email (whether the user is initially logged-in or not before clicking the 'Approve' button). To do this, we created a 'Rich Text' field named [Approve for Email] which is then used in a table's 'Notifications' Below is how the formula [Approve for Email] looks like: "https://<domain>.quickbase.com/db/<DB_ID>" & "?a=API_EditRecord" & "&apptoken=<APPTOKEN>&rid=" & [Record ID#] & "&_fid_13=Yes" & "&_fid_262=Approved" & "&rdr=" & URLEncode("https://<domain>.quickbase.com/db/<DB_ID>?a=dbpage&pageID=35") The [Approve for Email] field behaves as follows when used in 'Notification' mails: A user clicking on the [Approve for Email] is able to 'Approve' if he/she is logged-in
Is quickbase shady as hell?I had a 2 year contract I need to renew, and they are quoting double and triple the pricing. I had a quote 9 months ago and their new quote is TRIPLE the price. Are other people running into this? The costs could sink most businesses if they suddenly have to triple their budget for Quickbase.If anyone has someone I can contact about this, please let me know.Thx.------------------------------Mike Tamoush------------------------------
Hi Everyone,I've voting summary table which saves the votes submitted by users. One person can vote multiple times and the most recent vote is considered as the final vote (highlighted one).I've other table which has the complete static members list so need to show the vote status "Approved/Not Approved" on this report so that we can identify members who have not voted and also can see the final vote of members who have voted. I created formula query but its only identifying if member voted or not voted. I'm not sure how to update it to pull the most recent vote and the exact vote status. Or if there is any other way.Thank you in advance!------------------------------Mrunali Kadam------------------------------
Is there a way to create/add a button (in a form) that lets the user to directly download a certain report without being directed to the report itself? As of now i've made a button that directs me to the report so i can manually export the report. But what I want is to make the button directly download the report. Is this possible?
We utilize dashboard filters extensively. Hoping this community can help with the following Use Case.Situation: Apply Dashboard filters which affects an embedded report properly. If the embedded table report is opened it loses the filters and produces all of the records (as if no filters were applied). Note: Drill into embedded pie, bar and gauge charts works fine and retains the filtered contents.How do we make the dashboard filters persistent to apply the filter(s) to the embedded table report when opened?Thanks in advance for your help!------------------------------Annetta Coleman------------------------------
This is to calculate a bonus for our technicians based on how many hours they bill. Some technicians get an additional bonus for hours worked on refrigeration equipment and some don't. I'm getting a type mismatch from my IF statement, so I added a tonumber but am still getting the same error. Any ideas?I've tested the parts of my formula separately and they work as far as I can tell, it's just the IF statement that's giving me grief.SumValues(GetRecords($myquery,[_DBID_QSALESHISTORY]),23)+[Hours Adjustment]+If([Refrigeration Rate]="",(tonumber(SumValues(GetRecords($aquery,[_DBID_QSALESHISTORY]),23)+[Refrigeration Hours Adjustment])))------------------------------Anne Martin------------------------------
Hello!Was hoping I can get help with this problem.I'm using a query formula to get a list of emails from another unrelated table and it works just fine, however, it gives me duplicates which i'd like to get rid of somehow. Has anyone dealt with this issue before?example textlist:brucewayne@email.com ; theflash@email.com ; brucewayne@email. com ; brucewayne@email. com ; theflash@email.com; theflash@email.com ; superman@email.comdesired outcome:brucewayne@email.com ; theflash@email.com ; superman@email.comI can either make a new field to get the desired outcome or perhaps there's a way for me to stop duplicates on the query formula?
I am sure there is an easy answer to this, but I can't figure it out since the new reports have been released. None of my table reports will allow me to add a column while I am on the table? Is there somewhere in the app I need to allow or enable this? I am an Admin, so I have access to every setting. report etc in our app.Thanks in advance!------------------------------Kelly Lyons------------------------------
How To: Resize Dashboard Web Page Widgets to Content?This application demonstrates how to adjust the height of a Web Page Widget on the dashboard so that is displays without a vertical scrollbar.Resize Dashboard Web Page Widgets to Content?https://haversineconsulting.quickbase.com/db/bncwhskymPastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=617Notes:(1) The three code pages being displayed on the dashboard are the following:https://haversineconsulting.quickbase.com/db/bncwhskym?a=dbpage&pagename=page1.htmlhttps://haversineconsulting.quickbase.com/db/bncwhskym?a=dbpage&pagename=page2.htmlhttps://haversineconsulting.quickbase.com/db/bncwhskym?a=dbpage&pagename=page3.html(2) QuickBase limits the vertical size of the <iframe> and containing <div> of the Web Page Widget to 400px. By placing this script at the bottom of the Web Page Widget you can dynamically adjust the height of the <iframe> and containing <di
Please disregard
I have created a summary table of providers and the number of encounters (routine short patient visits). This table is setup weekly for the past 14 weeks. What I want to do is to compare the last few weeks to the current week & take an average and put in a new field, such as 3 Month Moving Average. I know the formula previous two months encounters + current month encounters and all divided by three. What I'm trying to do is to get a formula to add the three months of encounters for each provider. But the data is setup by grouping and crosstabs, so their aren't actual field data, since the data is crunched by the grouping & crosstabs. I am thinking doing a query is the way to go? The Encounter date is updated by BOX at regular intervals or manually. The provider and encounter date with other fields are added as one record. So if Provider Jeff Smith has 7 encounters today, then Sep 9, 2022 shows up 7 times with the provider name Jeff Smith.------------------------------
Hello, I was hoping to use a formula-Rich Text field as a label for my form so I can show/hide it with form rules. I tried using this formula: var text Label = "User Info";"<span style=font-size: 18pt>" & $Label & "</span>"However, the size stays the same. ------------------------------frnmj------------------------------
I am getting duplicate results in a Formula - Multi-select Text field. It looks like this:My formula and settings look like this: Can anyone tell me how to eliminate the duplicate Air District results within each record? For example, for Customer #106, I only need it to show "South Coast" once, not three times. I know it's doing this because that Customer has 3 records in the Facilities table and they are all in South Coast. I am really new at this so I couldn't make sense of the answer in a similar post. Thanks!------------------------------Jennifer Colomb------------------------------
I am trying to right a formula that will compare two Date/Time fields and set the text formula fields value based on the two values. For example, if the first Date/Time field is set to "05-17-2022 12:00 AM" and the second Date/Time field is set to 05-17-2022 12:30 AM, I want the Formula Text field label to be set to "On time". The rule for this value would be 30 minutes before and 30 minutes after the first Date/Time field. If the second Date/Time field is outside of 30 minutes after the first Date/Time field, or more than 1/2 hour after, label should be "Late".Thanks------------------------------Brian Dunk------------------------------
I may have just discovered a bug? Anyone run across this?I used $NextURL all the time for custom buttons. The button works perfectly in a form. Put that same button on a report, and the Next URL does not work. Anyone run across this and have a solution?------------------------------Mike Tamoush------------------------------
Hello!I have the following fields in my report:"Date Manager Entered""Last Day"I'd like to create a formula that does the following:1. See if there is a date entered in "Date Manager Entered"2. If there is a date in "Date Manager Entered" to calculate if "Date Manager Entered" - "Last Day" <5 days3. If that calculation is <5, display "No". If it's >5, display "Yes"I was thinking of using: If(Is Not Null[Date Manager Entered], If(ToDays([Date Manager Entered]-[Last Day])<5,"No","Yes"),"") but I'm pretty sure I'm not joining these correctly.Can you please help me determine what the proper formula should be? Also, please advise what sort of text type it should be.Thank you!
Hello everyone! I have made custom HTML/CSS pages for our team to clock in and out. The HTML page is their home page. I currently have it set up so that they can see an iframe with a report of any active time sheets, which they can then click and edit. The issue I have is that, of course, clicking on a record in the iframe report just opens the record form within the iframe, then clicking the home icon in the QB UI within the iframe takes them back to their home HTML page within the iframe, leading to an infinite mirrored effect... I tried about everything I could think of to make the record open in the parent window, but I finally figured out that I would have to change the html of the iframe itself. The only idea I've come up with is to make the records in the iframe report un-clickable within QB settings, and then create a button next to it that will simply take them directly to the same report. But, that seems very clunky to me, and I don't know how to disable/hide the button
I used this article to figure out how to color code specific fields. However, in my table report, I also have row-level color coding. My hope was that the row-level color coding would apply first, then the field-level color coding would overrule for the specific fields in question.It appears this is the case, but unfortunately the field-level coloring doesn't color the entire cell background. Instead it only colors the background directly behind the text (similar to if you selected the text via drag selection). In other words, it's acting more like a text highlight then a true 'background' color. Is there any way to get the field-level color coding to cover the entire cell? In the above example, this would mean that entire column would be blue, and you wouldn't see any of the green or purple from the row-level color coding.
Hello,I need more than 100 dropdown choices for a field which in turn sets a filter for a dashboard.Is there a way around this QBase constraint?Thanks!Rick------------------------------Rick Satenstein------------------------------
It's been several years since we created a connected table with Google Drive and are looking to start one again. The problem is, the folder I added to my Quickbase Sync folder in Google Drive isn't showing up as an option when creating a table. Only the folders I created three years ago there. What am I doing wrong?------------------------------Steven Pearson------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.