Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Can Reminder emails or Subscription emails be sent to non-users of an app? I'm trying to send these to an email distribution list, and I'm sort of recalling that this may not be possible. Can someone please confirm?Is there a way to have a Reminder or Subscription email sent to a non-user via a pipeline?Thank you!------------------------------VW------------------------------
We are using a conference platform for our virtual event. In past years we have had to import all attendees into Quickbase. The platform now integrates with Zapier which we could use to have registered attendees automatically imported into Quickbase. The issue is that the platform only collects the full name, and our database has a First Name and Last Name field. Although we have a formula field combining these values, it doesn't appear as a option when I try to complete an import.How can I import a full name field and have it populate the First and Last name fields?Full Name into First Name and Last Name------------------------------Renee Williams------------------------------
Hello I need some help to create a formula to auto sum labor time with labor dollars.This is what I have:ToHours([Repair Time.])*[Labor] But it is not working on all entries. Please advise.------------------------------Denise Keck------------------------------
I have a pipeline where the first step searches for a record in a parent table. If no match is found, it creates the parent record. If a match is found, it skips creating the parent record and moves on to add the child record. This works great when used in Edit mode from a single record, but causes problems when someone tries to enter multiple records using Grid Edit mode. Because the pipelines run virtually simultaneously, I have seen cases where duplicate parent records are created. I can mitigate this by adding a unique field to detect duplicate records, but when this occurs the pipeline for that record will stop and the child record will not be created.What is the magic method to ensure data integrity when adding records through pipelines while using Grid Edit mode?------------------------------Brian Petzold------------------------------
I have file attachments in an application (around 6000) that I need to download from the application and provide to the customer. Is there a good way to do this without going to each record / field one by one?
I am trying to use the following formula, but no matter what my Departure and Return dates are, the formula always returns the first value (ACTIVE). What am I missing here?Case(true, ([Departure Date]<=Today() and [Return Date]>=Today()), "ACTIVE", ([Departure Date]<Today() and [Return Date]<Today()), "PENDING", [Return Date]<Today(), "INACTIVE")Thanks in advance for the help!------------------------------Brian Cloud------------------------------
I have a form that has the section in a Hardware App.Under the section Acknowledgement of Equipment Receipt, when the Tickets tab is selected (the default) the error message with a 'spinning circle' says, 'Sorry... error retreving data'.If I chose the other tabs, data loads. I just noticed this a couple days ago. Any ideas?------------------------------Bob T.------------------------------
Hello everyone, thanks in advance for the help! I am trying to build a bar graph that does the following function as part of our system for better resource planning for our designers time.X Axis: Week #'s for the next 8 weeksY Axis: Total Estimated Hours for that weekSeries: The designer nameGoal Line of 30 hours a week. The intent is so that we can see workload over the next 8 weeks to determine if we are over or under allocated our resources to projects. If you have a better idea, I am all ears but this is what we came up with!For the X axis. I do not have a field to give me this. I have a Start Date and a Due Date for each task. My thought was that what I need to do is get to my next week (so Sunday or Monday I guess) and somehow that becomes Week 1 through that Friday Date (or Saturday). Increment by 1 to get to the next week. Or if at all possible we could have a date range print like 1/2-1/6 and the next bar be 1/
Hello quickbase community! I have a question to develop. I have 2 tables: 1.Reservations 2.Commissions I need that when a record in the Reservations table changes to status = sold, a new record is generated in the Commissions table with various information about the reservations. I understand that I must use pipelines to achieve this but I'm not sure.Thanks. Regards, Herberth Solano V. ------------------------------Herberth Solano------------------------------
Does anyone know the hex color for the native save buttons? The inspect element shows them as Vibrant Success, but this is now blue so I am not sure how they are getting the green. I am trying to match the hex color, but is wondering is someone knows the exact hex code.------------------------------Mike Tamoush------------------------------
Formula - Text Code:If(Trim([Gate 5 - Results Readout - Governance Status])<>"",[Gate 5 - Results Readout - Governance Status],Trim([Gov Status Summary Gate 4])<>"Pending","Gate 4 Approved",Trim([Gate 3 - Final Business Case Approval - Governance Status])<>"",[Gate 3 - Final Business Case Approval - Governance Status],Trim([Gate 2 - Customer / Frontline - Governance Status])<>"Not Yet Reviewed (Gate 2)",[Gate 2 - Customer / Frontline - Governance Status],Trim([Gate 1 - Size Dev Impacts - Governance Status])<>"Submitted/Not Yet Review (Gate 1)",[Gate 1 - Size Dev Impacts - Governance Status],Trim([Gate 0 - Approval to Begin - Governance Status])<>"",[Gate 0 - Approval to Begin - Governance Status],"Submitted, Not Yet Reviewed (Gate 0)")Issue:Returning nothing. I figured at minimum it should return the last text of "Submitted, Not Yet Reviewed (Gate 0)". But, it's not. The fields in brackets are multiple choice fields. What am I
I am trying to make an amount paid field autofill based on another filed if a I select a certain status. If that status is not chosen, I want the ability to fill that field in manual.Example,If "paid" then autofill AMOUNT PAID from Amount billed field (means record is paid in full). I did this and that works fine. But if I chose a status other than "paid" I want to be able to manually enter an amount in the AMOUNT PAID field as it may not be paid in full or not yet paid but I need to change the status to indicate that I am working on that record so do not want a paid amount in that filed yet.------------------------------Frank Popoli Jr------------------------------
I need to send a subscription to individuals who are not QB users but are 'assigned' records in my app. I have been unable to find a way to do this without creating individual reports and subscriptions for each of them because 1) they aren't users and 2) their information isn't being entered consistently in the records (ex: sometimes a middle initial, sometimes not). I don't want to make them official users because they aren't expected to use the app itself. Are there any other options to achieve this more dynamically?------------------------------Rachel Miller------------------------------
HiI would like to modify the date picker of a date field that it shows e.g. only dates in the future to be selectable, make only Sundays selectable, etc. In an old app that I didn't use a while I used the IOL-technology that was presented by Dan. In a JS-function I could for example set Monday to be the first day with the following line:$("#_fid_140").datepicker("option", { firstDay: 1});However this is not possible anymore. What options would I have these days to achieve this? Thanks in advance for pointing a way.Marco------------------------------Marco Diefenbacher------------------------------
Hello! I've created an EOTI form, so that the public is able to submit questions or comments to our office. After someone hits submit, I'd like them to be redirected to a "thank you page". I've been reading up on past discussion on this topic, and have it figured it out 90% of the way. I came across a code provided by Dan Ladner, that is working well but it's redirecting me to an error page. The code provided by Dan Ladner: var text rdrURL = "www.redirectPage.com"; "<a class='SaveBeforeNavigating' href='" & $rdrURL & "'>Submit</a>" I've updated the URL "www.redirectpage.com" to the thank you page I've created within our website. While testing this, I have been redirected to another page but it's an error page. I think the reason I'm getting redirected to an error page is because somehow extra letters and words are being added to the URL once hitting submit. Please see snapshot, at the end of the webpage URL I've added, ">Submit</a>'>But
I am creating a audit log and want to log the records when deleted by any one through pipeline. But in the user field its picking the pipeline owner name not logged in user.help required------------------------------Ashutosh Kumar------------------------------
Hello, I'm having trouble finding a solution, hoping the experts can help! I have a report with the total row showing, its working fine.Is there a place to change a report to say TOTAL instead of TOT?Thanks! Bridget------------------------------Bridget Lambert------------------------------
Help lol!!! Im new to formulas and im trying to get my report to only show projects with certian task open but only if other task are closed.EXP:Show all projects that have install task open but only if the permit task is closed------------------------------Stephanie Delahunty------------------------------
I have a bit of a structural issue in my app I need to fix.We developed a CRM / Purchasing system with tables as follows: Opportunities: To Track the sales potential of a new client opportunity Orders: To track the order value once approved Invoices: To track each individual invoice as we partial invoice on progress in our industry Later we realized we need a Proposals Table to track the proposals we send to our clients. The structure of my app today is:Opportunities < OrdersOrders < InvoicesOpportunities < Proposals20/20 hindsight I have realized this creates some issues and the flow should be:Opportunities < ProposalsProposals < OrdersOrders < InvoicesI have a lot of data in each of these tables, lots of reports, etc. It is all very very important.How would I go about making this structural change without things blowing up on me? Any suggestions on how to start? Physically creating the relationships is fine, I just want to ensur
I have 7 pipelines that all do the same thing but connect to separate end points. These separate pipelines insert data into a single QB app.They are all set to run at different times within the same hour.Question: Is it possible to string these together so one automatically runs after the other?StartPipeline 1 runs,pipeline 2 runs,pipeline 3 runs, pipeline 4 runs, pipeline 5 runs,pipeline 6 runs,pipeline 7 runs,FinishThanks------------------------------Steve Laurel------------------------------
I have a role that has access to only one table. When logged-in as this role, I'm getting this error when accessing this table:"The report is unavailable, because a field for sorting can't be shown."I have given field-level access to every field in every column as well as every sorting field and still get the same result. Does the role also need access to tables referenced in relationship fields?------------------------------Matt Makris------------------------------
Hi everyone,I don't know if this is possible in Quickbase at all - but I figured if anyone would know, someone on here does.I need to build a form where there's something like a repeating section of the form based on the # of communities you need to report on; and then when you press submit it creates multiple records.One way I see building something like this is to have an upper 'header' section where the user says the # of communities they are reporting on:"How many communities are you reporting on?" ___Based on their answer, a second form is then loaded multiple times with the remaining questions they need to complete. I'm wondering if this is possible using conditional formatting?------Another possible way to build this would be:1) Complete a header section and the '1st' community2) Have 'submit' button options at the bottom - one that reads: "Submit and Close" which submits the form and closes the form completely; the other button being "Submit and Enter another community" -
Is there any way to have a button (specifically on the new dashboard) navigate to a certain record, but also specify the key field?My use case is I have a table where the user is the key field. This is a user focus table (made famous by YourQuickBase Coach).I want a button on my home page to take me to a form and record on that table, which would require a url that auto fills in the persons email address at a certain point. I don't think it is possible, but thought I would post just in case someone has done something like this.------------------------------Mike Tamoush------------------------------
Hmmm. I'm not sure that's quite where I'm trying to go with the form; Our staff needs to answer two questions for communities that they work within in a particular day. So, some days, they may have 10 communities (or 5 or 30, depends on the day) and 23 people they spoke with; Our leadership team has to report total #'s of connections for each community. I'm trying to find a way to make this process as simple as possible.The first thought was, through conditional formatting, to have them say # of communities they were reporting on, and have the 'form' sort of automatically repeat below the 'header' section of the form that specified # of times.However, the other thought I had was to just create a 'Save and submit another community' button; and somehow code that button to load a fresh version of the form but with the 'header' section already populated with the previous record's information so they don't have to re-enter it.I'm thinking this second option with the
Is there a sneaky way to make a dynamic filter so that when the user selection an option, it shows all the records that dont match that option?For example,Multiple Choice Field has choices: Red, Orange, Yellow, GreenUser dynamically filters a report using 'Red' and it shows all the records where it is NOT red.Any way to pull this off?------------------------------Mike Tamoush------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.