Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello team, based on a "Report Link" field I have added chart to my record form that prefilters the information shown in the chart below based on the opened record. However, I would also like to limit the displayed x-axis values (calendar weeks) based on the start date that is mentioned in the particularly opened record on top. Does anyone of you know how this can be realized?
While I appreciate where this is, there are some glaring issues with the implementation that leave this feature being not able to be used in a manner all IT best practices would recommend. Examples1) Not being able to select what is promoted or not or selectively undoing a change. While I understand the possible technical issues, having an all or nothing approach is not always appropriate.2) Having to have all your tables in production. If you want to create a new table and reference values from that table for a drop down in an existing table, you have to promote the table first before you can do that. So basically you have to create all your tables, promote them, and then go and work on any other changes. Hope you have a solid plan because if you need more changes...A sandbox should be self contained and if you have to search into production in order to use it, then it isn't a true sandbox.Are there other gotchas I should be aware of? I was planning
I am trying to publish the changes from a sandbox environment to live environment. But after I click on the "Review and Publish" button, it displays an error message. See attached.What am I doing wrong?This is very important for us and we are doing this after hours after 11 PM. This situation is not good for us. Please help.I tried searching on google and bing. There are not even any articles talking about this situation.#sandbox
In my app, there is a relationship between two tables, call them Table A and B. In table A, there is a column called batch date. For this field, we would like to create a new field based off of it called initial batch date in the same table. This would essentially be the first value that was inputted in the batch date field (that field has end users inputting a value often). From the research I have done, the best way to preserve original values is using a snapshot field. From what I understand all I have to do is add a lookup field to the child table, then create a new field for a snapshot that effectively references this lookup field. The problem is in this relationship, table A is the parent and table B is the child. How would I create a snapshot field for table A in this situation? So far I added the lookup field in table B, then I created the snapshot there, and then added it as a summary field in table A to reference the original snapshot. This did not seem to give the desired re
Is there any way to translate this logic into a QuickBase formula? I'm relatively new to QuickBase so I'm still learning its capabilities, forgive me if some or all of this is outside of the realm of what QuickBase can do. This feels like a complex one, but I'm hoping it's not as complex as I think it is. Here is my logic broken down:We would only be testing for active clients. We have a client-tier text field that tells us if a client is active.ANDWe would be testing for clients where no files are uploaded in their "Files" form. Is there a formula I can use to test for empty "Files" forms in an active clients page? I know you can test for empty fields in QuickBase - is there a way to test for empty/missing forms?ORWe would only be testing for active clients. We have a client-tier text field that tells us if a client is active.ANDWe would be testing for cases where there may be files uploaded, but none are marked as Consent Docs. We currently utilize a check-bo
I have what started as being a very simple form to get approvals on procedures.There are 2 static approvers (radio buttons - Approved/Rejected/Not Applicable). Then I have a multi-select box with 4 names in it for regional managers. You can select 1-4 names, and those names and radio buttons will become visible so they can approve or reject the new procedure.If I set the status to "Pending Approval" and submit, then an email goes to each of the 2-6 approvers. The email is a standard notification and provides the link for them to go in and approve or reject the procedure. This part is working.This is my challenge - What I want next is once all the selected/visible approvers select "Approved", another notification is sent to say the ticket is approved so the 2 static users who are responsible for the procedure know they can go into the ticket to review. Outside of setting up a notification for every combination of the 4 approvers, is there an easier way to say when "selected/visible
I have a project management app with a main project table and a tasks table which have a one to many relationship.My desire is to have the tasks table prefill 3 records once a new project is opened. Every project is required to have these tasks assigned so automating this step will streamline the overall flowExample:Step 1: New project is open and saved.Step 2: Task table populatesRecord #1 Field: Task Name: Value= "Documentation"Record #2 Field: Task Name: Value= "Client call"Record #3 Field: Task Name: Value= "Workflow"
Starting a new series on sharing some knowledge.We have a simple app where we ask users to do production entries from shop floor daily in date , capturing it in [Production Date]We only wanted backdated entries for 1 day , so if today is 21 February 2025, entry for 20 Feb 2025 is allowed. Here's how we achieved it. Below is a Formula Field called Validations. var date decide = If(IsNull([Record ID#]),Today(),ToDate([Date Created]));var number daydiff= ($decide-[Production Date])/Days(1);If($daydiff<0,"You cannot do entry for future",$daydiff>1,"You cannot do entry for past","OK")We then went to Settings->Advance Settings-> Custom Rules - Turn ONIf([Validation]<>"OK",[Validation])
Is it possible in quickbase to have a field display date/time like this - 02/20/2025 10:24:53 AM? The closes I can get is 2/20/2025 10:24 and it cuts off the seconds and AM/PM.
Hello, I'm trying to create a pipeline in a help ticket app that only creates a new ticket record when a new email comes through the outlook mailbox. The problem I'm running into is it creates a new ticket for every reply. I only want the ticket to reflect the original email request so we can manage the app better. I've tried filtering by subject line containing "RE:" or "FW:" and it doesn't work. Any help is greatly appreciated!Andrew
I am trying to build a formula and it's coming out with the wrong numbers.I am trying to replicate an excel spreadsheet. The formula they have is Total for this 8111.59I have a numerical field called Purchase Price: example ($22,556.03)I have a numerical currency field called Closing cost : ($1950)I have a currency formula field called Closing Cost – 400/2 ([Closing Cost]-400): ($750)This is the field I am having trouble with field Closing -400/2-IVAClosing Cost -400/2/1.16 ( this number should be 667.10) it comes out at 4843.75Last field is Currency formula[Purchase Price]*0.33+[Closing Cost minus 400/2]-[Closing -400/2-IVA] This field should have a sum of 8111.59It would be nice if I could do this all in one formula field but I am not great at formulas so I thought breaking it down step by step would work – so that the person using it in reports would be able to see step by step I am lost and I am hoping someone can help methanks a bunch - hope that made sense&
I have a report and I want to shorten the name of the field for that report but it does not give me access. All my other reports have it but not this particular one. I am not ready to change the field name just yetIt is a legacy report thanks
I have a text string that contains data similar to the following:Company Name 1 | P25021201 - 4341297 | stp01YWTFMSXKS5f6u2z | $1200.00 | Company Name 2 | P25021201 - 4341112 | stp01RFEQRMDTC5f6u0l | $2400.00 | WalletI need to extract the data that starts with "stp" and return it in the following format: stpxxxx1, stpxxxxx (i.e. stp01YWTFMSXKS5f6u2z, stp01RFEQRMDTC5f6u0lThe problem is the number of "stp" strings in the text is unknown. Does QB support a looping mechanism? If yes, I could simply find the 1st stp string, remove it from the text string and keep looping until no more stp strings are found.Any help with this is greatly appreciated as it is causing an issue with a production app.
I have two fields date/time I want to calculate extract hours the between those dates. Can someone guide me here ------------------------------manohar vankireddy------------------------------
Does anyone know of a way to see document history and to access at least some of the previously generated documents with the new Quickbase document generator (a.k.a Document Templates)?
Loving the new Document creation feature, but now I want to expand upon it and save the generated PDF to a file attachment field on the form. The feature just makes an API call and the PDF is returned in the response, so we should be able to build a Pipeline to iterate through the JSON response and save the PDF. I've been trying to set this up for a few days, but to no avail.Has anyone done this yet?
I have a Formula - Rich Text field that is converting a Currency field "ToText". The value was Rounding the "cents" up to the nearest dollar value which I have solved for. However, now I can't get 0s after the decimal to display. I tried applying Abs (absolute value) but that didn't resolve the issue. Below is my formula...HELP!If(ToText([COR Amount])<>"", "$"&ToFormattedText(Round([COR Amount],0.01),"comma_dot"))------------------------------Ashley Solomon------------------------------
Hello, Each client within my app has a form/page with centralized information. On this form, there are many sections, including a section for files. Based on our company policy each active client needs to have a consent document signed for us to offer services. We want to be able to flag for our staff if a client form is missing a consent document. I figure I can use the IsNull formula, but I'm not completely sure how to leverage it.We have a checkbox formula set up to indicate whether an uploaded file is categorized as a consent document. Is there some way I could use this checkbox field with the IsNull formula to indicate if a client is missing their consent document?Any other ideas on how to gather this information? Thank you in advance!Abby :)
I've got a Pipeline that links to my Google calendar. Everything works fine, but I'm losing the currency format on a field. Is there a way to fix this?------------------------------Bethany Hudson------------------------------
Hello, is it possible to convert a date field and a TimeOfday field to a date/time field ?
I am trying to create a form rule that will show a report when a checkbox is selected in the form. Issue is that when I am creating the rule, I do not have any reports to select from (it's blank dropdown) even though none of my forms are hidden. Attached is screenshot of form ruleCan anyone help me?
Hello, First, thank you in advance for any thoughts and suggestions you might offer here. I would like a report for the average hours worked per technician per week. They record the total time on site in each dated work order record. Thus far, I have created a summary report that summarizes the work time order time by average and it is grouped by week and by the assigned technician in the record. However, this field is a multi-select and there are some records with multiple values as some work orders have multiple assigned technicians. The resulting summary report displays each assignment as a value, meaning the assigned technician(s) rather than searching and filtering for each individual technician, and then averaging each of their hours. I am not sure how best to resolve. I really appreciate your input.
Hello! We use quickbase to track legal agreements we issue. We have a field "Type of Agreement" that we populate with the agreement we issued. We would like to track how many hours we spend overall and have determined how long each type of agreement takes. I need a formula to take the Type of Agreement field and read it and know if its (ex.) MNDA it should show 3.75 hours. Can someone help?
We have had a widget on our dashboard to display our company calendar for the last 6+ months and all of the sudden last week it stopped working and just displays "Unable to display widget". I haven't made any changes to the table or report. Has anyone experienced this bug or found a solution to this in the past? I have already tried changing every setting I can think of within the report itself, the dashboards, deleted the widget and added it back, and cant find anything that works.Thanks for the help!
Hi,on chart we have two plots which are in same range. because of that data labels are showing only for one plot. We want to show data labels for two charts. How can we show them.Regards,Ravi Siddana
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.