Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Will a "button" created in a formula - rich text field work while in Grid Edit?------------------------------Paul Peterson------------------------------
Hello! I currently have two tables. One is Team Members and one is Team. I have linked all of the team members to their respective teams. I created a report link within the relationship and I am able to view a report of what team members are a part of each team. However, I am wanting to have a "Team Members" field within the Teams table. Is there a way to list out each team member on the Teams table without using a report link? I'd ideally like for the team members to be a user field within the teams table so that I can use this for setting up rules. Thanks in advance!------------------------------Blake------------------------------
I'm having trouble with a formula query. I can't get the output to match what I expect. Right now, all I want is the field to give a list of all my records that have a User Input Date on or before the User Input Date in that record. I hope to use method eventually to identify duplicate records, but right now even this simple query is not working right. Something is messed up. Can you help me find it?I have [User Input Date] with field ID 18[Record ID#] (the output currently) has field ID 3I created a Date Formula field called [TodaysTheDay] where the equation is Today()I created a Text Formula field called [TempDateCompare] where the formula is:If([User Input Date]<Today(),"User Input Date IS before today","")Today is May 4th and my app and environment is set to use DD-MM-YYYYThe problem query field is now called problemQueryDate and is set as a Formula-Text field. The formula is:var text queryOne = "{'18'.BF.'04-05-2022'}";var text queryTwo = "{'18'.BF.'"&Today()&"'}";var t
Hello! Does anyone know how to create a line graph that shows how many records are in a certain status each day, over time? I don't know how to take a snapshot of each day and plot that in quickbase...Thank you!I'm thinking it would look like this:TIA again!------------------------------Amber Gartner------------------------------
Can anyone help me figure out how to query to find all the records that have a certain date field that's in the same month (and year)? This is what we have, and it's correct for April, but then it's doing a backwards running total, so March is including April and March. Feb is including Feb, March and April. Thank you! var text query ="{48.OAF.'"&FirstDayOfMonth( [date field] )&"'} OR {48.OAB.'"&LastDayOfMonth ( [date field] )&"'} "; Size(GetRecords($query)) BTW - I tried using "AND" instead of "OR," but that returned a number of 1 or 0 usually, when it should be more like 10-30.Thanks again!------------------------------Amber Gartner------------------------------
If I change the trigger field on a current active pipeline, will it mess up current data?------------------------------BuildPro------------------------------
Hello,Is it possible to restrict the leads being viewed by our sales reps to only leads that where they are assigned as lead owner? Right now they can see all other leads for all other reps. Thanks!------------------------------Delia V.------------------------------
I've got a nice Rich Text button and am trying to vertically align it. This isn't working:"<a style=\"text-decoration:none; background: #4589f7; border-radius: 10px; color:#ffffff; display: inline-block; padding: 8x 20 px; width:100px; height: 18px; text-align: center; vertical-align: middle; text-shadow:none; \"Anyone know how to vertically align in a rich text formula button? ------------------------------Raymond Sakar------------------------------
I need to see when a field [Projected Start Date] has been modified. I would like for the row(s) on my report to be highlighted when the field has changed. Is this possible.------------------------------BuildPro------------------------------
I am trying to set up a system that will have Vietnamese language in some of the forms. When I use the phrase Tên hội for "Assembly Name," it shows up on the form as "Tên h i" and the phrase "Số sê-ri lắp ráp" for Assembly Serial Number shows up as "S sê-ri l p ráp"Is there a way to turn on support for other languages? I don't think it's a browser-based issue if you can read it in this post (have to see what happens when I hit "Post," I guess!).------------------------------Edward Hefter www.Sutubra.com------------------------------
I created a new report. When I click "Grid Edit," instead of being the same report with the same columns in the same order, I'm taken to a completely different report. Any ideas why?Thank you!!------------------------------Amber Gartner------------------------------
Is it true that if I hide (no view) a field from certain roles, e.g. pay rate for employees, that anywhere that the field is used (e.g. a formula field) is also not viewable to those roles or viewable to those roles minus the amount of the hidden field?------------------------------George Bramhall------------------------------
Hi,I am trying to set up an open notification that will use the email address from a lookup field. I have a relationship set up and one of the fields is their supervisor's email address. When I try to set up the notification it doesn't give me an option to choose that field. Is there a way for this to be done?Thank you------------------------------Fatima Khan------------------------------
Additional security token? Can JWT token be used with REST API in Quickbase?This was a questions asked to me and I have no idea how to answer it. So hoping you all can help.------------------------------NOEL HODGES------------------------------
We have certain tasks that get created when new employees are hired. Most have due dates that are calculated a few days after the start date, but we want to add tasks that will be due on September 1 or March 1 based on the start date (so if the Person is hired and task is created in September, October, November, December, January, or February the task will be due March 1. If it is a March, April, May, June, July, or August hire will have a due date of September 1). How would I write my formula to say if this is the start date, then this is the due date? Thank you!------------------------------Xenia Watterson------------------------------
Hello all, I am looking for a formula which will help me determine 3rd working day of a month taking into account week-ends if any and list of public holidays. I have list of public holiday dates which can be checked. As an example: For the month of May'22, the 3rd working day is 4th May. If I have to add a holiday on 3rd May, the 3rd working day should be 5th instead of 4th. Looking forward to hearing from you.RegardsPostMC------------------------------MC Admin------------------------------
Hi, This is our scenario, a Customer has Displays, and a Display has Display Zones.We create projects for a customer, and have a many to many relationship to link a Project to multiple Display Zones from displays owned by the customer. We want to be able to have a list pop up of all the available display zones and select the ones we want on the project.I have it mostly working. I created a formula URL button to add a record to a User Work Table with the user, record ID of the project, and customer number. It then redirects to a grid edit report built over a Zone work table.A pipeline triggers when the User record is added. It adds all the display zones for that customer, with record IDs, and the three fields from the first table to the Zone work table. The user is already in the grid edit report and needs to keep refreshing until the data is there, which isn't ideal. I couldn't find a way for the pipeline to redirect to the report after it finished l
Hello,I am trying to create this kind of report:Where each record will have a Forecasted to close date (or month) field as well as an Actual Closed Date field. Therefore, the Actual Closed are not a subset of Forecasted to Close. I need to summarize all records that were forecasted to close in January, Feb, etc. and then also summarize all those that actually closed in January, Feb, etc. Can anyone help me figure out how to do this? And then (BONUS!) is it possible to get a running total of just the Actual Closed? (ie I wouldn't want to summarize each column)??Thank you in advance!!------------------------------Amber Gartner------------------------------
I have a report that filters on specific fields, so that when the record is ready to go to the next phase of processing, it shows up on this report. I am having issues with records that don't meet the requirements, but are still showing up. Below is a screen shot of my filter.So if a record has a job number, is not 100% billed out, but is 100% complete and has contract terms of A. 100%, then it should appear on my report. However I have records that are 100% complete and 100% billed out showing up.Please help!Thank you,Brandy------------------------------Brandy Nunes------------------------------
The title says it all.I have an APP that manages prospective and ongoing projects most of which have a dozen or so PDFs generated from other companies/clients and currently these go into a google drive automatically upon receipt and are sorted from there to the appropriate project. It would be much easier (and stop people from not adding them to the APP if they were automatically uploaded to the Documents table of the APP.What is the easiest method to achieve this?------------------------------Nicholas Geer------------------------------
Hi, I've created this table report. One person can vote multiple times and current report shows all votes submitted by each person. Need to update it to show only most recent vote per voting member (highlighted one). @Mark Shnier (YQC) Please advise if this can be achieved or would like to know if you have any other ideas. thank you! ------------------------------Mrunali Kadam------------------------------
Hello Everyone, Is it possible to add a clickable link(href) in the Quickbase form text item?------------------------------Hema Rajendran------------------------------
Hi,I'm trying to connect QuickBase Pipelines and Microsoft SharePoint. So, my use case is---I'll be sending some set of values from QuickBase upon a condition, the data should be sent to SharePoint in which I should place a Spreadsheet with formulas. So, now the data which I send from QuickBase should travel to the Spreadsheet and give me the final calculated value( should send that back to QuickBase Table) and don't mine if a new item is created in the SharePoint folder.Can we do this!!!!!!!------------------------------Adabala Srinadh------------------------------
Is anyone else suddenly having issues adding columns to the old style of report? I just get it spinning trying to load results. This only happens when clicking the arrow on the column header and saying add column, vs actually adding it to the report. I also cant click the header and sort the column, if it is the default report. Only if it is list all, or some other actual report.Maybe only with firefox?Anyone else have this?------------------------------Mike Tamoush------------------------------
I am setting up a digital version of a form that is currently being filled out on paper. However, the client still wants a user to be able to download and print the paper version and print it to be able to fill out manually. Is there a way to store that pdf version in the database somewhere and connect to the digital form I am creating?------------------------------Chris Swirtz------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.