Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi all,Very beginner database manager here, so bear with me as I try to speak database language.... especially when I try to keep my terms straight when dealing with child/parent table to table relationships that are specifically related to real human children/parent data sets.It seems I use Quickbase a little differently than lots of folks - to manage a youth program's participants.The challenge I'm having is in integrating two different child tables into a single parent table. Basically, I have two participant-generated datasets that I import into separate similar tables: I want to cherry pick a few lines of data from each and auto-populate into a pre-existing single parent table. I can only figure out how to make it work the other direction - for data from the parent table to be a lookup field in the child table. Here's the frame of reference for my workflow: I work with human kids, and initially create a very basic master "kid profile." After I create a "kid profile" I receive sep
I have a form that has a save & continue button on it, one of QB's newer-ish feature releases, but this form contains a grid edit report of child records, and when I make edits to those child records, the changes don't get saved when clicking that save & continue button, only if I use the default save button. Is there a way to edit the below code to save the changes to those child records too? "<a style='position: absolute; right: 7.5%;' class='Vibrant Primary SaveBeforeNavigating' data-replaceRid=true href='" & $url & "'>Save & Keep Working</a>"------------------------------Harrison Smith------------------------------
In one of my forms, when a user clicks into one specific field the "manage passwords" pops up. It doesn't happen to any of the other fields and I cannot see anything different about this form or the field, when compared to similar ones built in our other apps. Anyone aware of a possible cause/solution? Thanks in advance!------------------------------Laurie Myers------------------------------
Hi,I am new to this. How do i create a button on a form called Archive so that when pressed, it will check a hidden archive checkbox then return to table home page.------------------------------Shelly Ann Aiken------------------------------
Hi!I have a pipeline that creates an invoice in QuickBooks Online and then passes back the QuickBooks Online invoice number and date to Quickbase. I would love to also pass back the link to the invoice in QuickBooks Online as well but haven't been able to figure it out. Has anyone else had success doing this?Thanks!------------------------------Scott Cote------------------------------
Hi,Is there anyway to validate an address against an external API such as "Addressr", Addressr API Documentation (addressr-addressr-default) | RapidAPIThanks.------------------------------Chris Foley------------------------------
Hi,I have a tough situation that I am desperately trying to wrap my head around. I have two tables: A technician table (One) to a Measure table (Many). So 1 Technician can have many measures. I have a report from the measure table where I can see that a technician, in this example Aaron with many Time_iM_SnapshotTI (a date / time field). I need to count how many snapshots happen per Time_iM_SnapshotTI date for that technician. For example Aaron Smith will have 2 Time_iM_SnapshotTI for 9/3/2021 and 9/7/2021 respectively. How do i go about summarizing based on that fields date and technician?Thank you so very much in advance, you all blow my mind in terms of expertise and wisdom!------------------------------Lija Harris------------------------------
I have a Formula query that is giving me the error message "Expecting Number."I expect that the field (159) is a number in my table. The record ID (108) should also be a number?Commented out on the attachment is the formula that I had copied out of the help areato start with. As I add "s" to the end of GetFieldValue or GetRecord - the errors change butdo not resolve my issue.Is there a Formula Query "guru" who can enlighten me on what I'm overlooking?Thanks,------------------------------Chad KragnessTimber Technologies, LLCYear 1 user (creator)------------------------------
Hi,I'm trying to think of an efficient way for our revenue team to request approval for payments. Right now I have it setup where we get payment on a well, the revenue team goes to that well, hits a button to request approval. A customized form opens for them to input the details of that payment in the notes field and in a revenue field, then they hit save and close, and an email is supposed to be sent to the approver. Once it's approved, an email is sent to the requester notifying them of the approval or denial. We have a "Wells" table where we track all of the wells, and all of the above is done on that well record. This is kind of becoming cumbersome because we get payments every month on the same wells. I'm wondering if there are any examples out there I can see, or if this would be more efficient to have it on it's own table? Any advice is appreciated!------------------------------Renee Hansen------------------------------
Is anyone aware of method for non-admin to manually refresh a connected (gmail) table?I have a gmail connected table with minimum refresh time (one hour). Sometimes we are aware of an email from customer but have to wait up to an hour to sync to table before we can work on it - difficult to explain to a customer.The 'Refresh Data' button seems to only appear for admin, hoping there is a URL to trigger a refresh.Cheers,Anthony.
I have created a dashboard in the new Dashboard pages. I have several charts on the dashboard and I would like the filter for the charts to default to the date range of the previous month. The filters go blank every time you go back into the home page and do not keep the filters. I can't build it into the report because I want them to be able to select a date range as well, but for it to default to the prior month. Has anyone found a work around for this issue?------------------------------Amber Goodman------------------------------
I currently have a pipeline that creates a record and populates a certain field. I have a dynamic form rule that says that when that field is populated, change the value of another field to match that field. When my pipeline runs and creates the record, the dynamic form rule is not triggering. I have tried adding another pipeline to run to update the record but that doesn't trigger the dynamic form rule either. If I go into the record and click edit then save then the form rule triggers. So my question is how do I get my pipeline to trigger a dynamic form rule? Creating a record and updating a record is not working. Thanks for the help!------------------------------Amber Goodman------------------------------
Hello - hoping someone can provide some assistance. I'm trying to create a formula field that gives a Yes/No output based on the answer of two other fields. If [daytime]=no AND [evening]=no, then my [formula field]=noHowever, if [daytime]=yes OR [evening]=yes, then my [formula field]=yesDoes anyone have any ideas? Thank you in advance!------------------------------Gabriella Tremoglie------------------------------
How do i get spell check on a rich text field?
I currently use the send to QuickBase feature to send emails from outlook directly to QuickBase, however if the body of the email contains jpeg images, not attachments but images that have been copied and pasted into the email body, the rich text field will not show those images.Any ideas on ways around this, other than the user having to save the email outside of outlook and upload?Thanks,Carol------------------------------Carol Mcconnell------------------------------
Hi Everyone,First let me put everyone who is reading this into context, currently in the company I am working for, there is an Excel document in order to know how many people is currently working in an specific location, however, this is a lot of information that is hard to arrange and process manually in an Excel document, this information contains some basic information of the people working in different locations, including, full names, gender, job role, company the worker belongs to etc... This information is provided DAILY by several of our contractors that are currently working in these specific (and by the way) REMOTE locations, so yes it is a lot of data, one contractor can have up to 300 people working in one of our locations, so creating an attendance list to check if the person is working in the location or not is "NOT AN OPTION" so here is where I need your help builders, what would you do in this case, this is what I figured out.Create an standard Excel Template for
I have a pipeline that takes several date fields and writes them out to text fields in another table, with {{datefield|date_dmy}} used to format the date. It works when all the date fields contain a date, but fails when any of the fields are empty, producing an error 'Validation error: Incorrect template'. Has anyone else had the same issue and/or know how to workaround this without adding in conditions to check for fields being blank (as this isn't a feasible solution) or creating formula fields in the table to format the dates as strings? Thanks.------------------------------Jeremy Anson------------------------------
I have a button that takes users to a grid edit report. Is there anyway to redirect them after they save? I tried &rdr and &NextURL. Rdr does as expected - redirects before the users have a chance to do anything. Next seems to do nothing? Perhaps it is only designed to work with the add record API? Any good workarounds?var text Words = "Button Text";var text Next = URLRoot() & "db/" & "bpxsuegfm?a=dbpage&pageID=4";var text URL = URLRoot() & "db/br5abyum7?a=q&qid=10&nv=2&v0=" & [Record ID#] & "&v1=" & [Related SRM Project] & "&NextURL=" & URLEncode($Next);"<a class='OpenAsPopup' data-height=850 data-width=800 href=" & $URL & ">" & $Words & "</a>"------------------------------Mike Tamoush------------------------------
Help! I have a formula number field that I went to use display Text and a Number. The formula I'm trying to make work is.If([3PWMA]=0,ToText("No Usage"),(([Availabile]/[3PWMA])*20))Is this formula doable?------------------------------John Romano------------------------------
How do you check if a text data field only contains a number or is just numeric.I have an address field that I need to perform an If statement such as:If property address is numeric then set "Y" else set "N"------------------------------George Romanowski------------------------------
Hello,I am building the CRM aspects of my application and I am looking to do several charts that compare this year compared to last year by date. So for example I will have a line graph with two running lines by month (Jan, Feb, Mar, etc.) They are cumulative sales year to date compared to last year to date. Same for opportunities, etc. How many we have won to date vs last year.I am not quite sure how to get this represented. I saw some posts when searching about a waterfall chart. But I dont think I can compare to last year that way...Attached is a sample of what I am trying to replicate. I manually do this in powerpoint charts from data coming out of my existing CRM
Hi everyone,I had created a complicated snapshot table linked to my invoices table to generate a cumulative line chart showing sales YTD compared to last year. It works, although not perfect.With the new formula queries I am thinking this would now be simpler in a much easier and faster way with less moving parts. I have had several quick base updates break my original concept (including recently with the move to pipelines) so rebuilding in query functions seems like a good idea.Just not sure where to start here.... Has anyone had any success in doing anything like this that might shed some light on it? Here is the workflow for where the data comes from:Our invoices table is attached to a project. When a client approves a project our team creates records on the invoices table to "forecast" when we will bill. Ultimately once they invoice the client (in Quick Books) we enter the invoice # and date on the base record. That is how we kno
Hi,We have a sales summary table that has a sales total per week. [Week Ending], FID 6 and [Sales Total], FID7.We would like to do a week on week sales comparison using a Formula Query (if that is possible)We have tried various formula queries with this one being the "best" so far.var text LASTWEEK = "{6.BF.'"& [Week Ending] &"'}";var text THISWEEK = "{6.AF.'"& [Week Ending] &"'}";GetRecords($THISWEEK,7)-GetRecords($LASTWEEK,7)However we are getting the following error;"The types of the arguments or the number of arguments supplied do not meet the requirements of the function GetRecords.The function GetRecords can be used with the following arguments:GetRecords (Text q).GetRecords (Text q, Text t)."Any suggestions would be greatly appreciated.Tim------------------------------Tim Egerton------------------------------
Is it possible to setup some kind of rule where a particular field that was used in one record, that after clicking save and next, the field would auto-populate the field selection from the previous record?------------------------------Lance Cowley------------------------------
I must be missing a basic concept with Pipelines.My goal is to Search (retrieve) records from a table. Then for each record, do three steps in sequence.1. Update a record 2. Call an API Webhook #1. (API_RunImport#ID=10)3. Call an API Webhook #2. (API_RunImport#ID=11)The search work fine and returns 5 records ( I set that as a limit for testing).But then it gets into the For Each loop and does that first Update step #1 5 times in a row, and then starts into the API calls.How do I get it to do the three steps in that sequence.ie update record with Search results #1.call Webhookcall webhook.Then update records with Search Result #2.call Webhookcall webhook.etc for 5 loops. ------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.