Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I just create a basic new form. I have a user field that is set as requried and has a default value. When trying to create a record, it won't save and gives a restricted field error. The field is not restricted. Any ideas what might be the problem.------------------------------Carol Mcconnell------------------------------
Is anyone else having issues with printing/saving reports to .pdf? Each time I select my Adobe .pdf printer as an option, the browser completely shuts down.------------------------------Ember------------------------------
Here is a report formula that returns a rolling 3 month average. FID 7 is [Bill Creation Date], FID 9 is a field I am using to filter records, and FID 18 is the currency field that is being averaged. If you want to do 6 months average, just change the -2's to -6's for the month string. var text QUERY = "{7.OAF.'" & ToDate( //create 2-digit monthIf(ToNumber(Month([Bill Creation Date]))=2,"12",If(ToNumber(Month([Bill Creation Date]))=1,"11",If(ToNumber(Month([Bill Creation Date]))<10,"0" & ToText(Month([Bill Creation Date])-2),ToText(Month([Bill Creation Date])-2)))) & // first day"/01/" & //create 4-digit yearIf(ToNumber(Month([Bill Creation Date]))<=2,ToText(Year([Bill Creation Date])-1),ToText(Year([Bill Creation Date])))) & "'}AND{7.OBF.'" & LastDayOfMonth([Bill Creation Date]) & "'}AND{9.CT.'TEXT_STRING_FILTER'}"; SumValues(GetRecords($QUERY),18)/Size(GetRecords($QUERY)) Hope you find this useful. P.S. @Sharon Faust thanks for sharing
Hi all... I have a field that grabs data from another field (quite lengthy as other field is car types). I wish to make this field mandatory but due to the number of choices in the other field I cant seem to make this field require input. Any suggestions appreciated, images attached.------------------------------damien page------------------------------
I am looking to utilize pipelines to pull from a formula field and input a date into a reference field. Essentially I have a date/time field, this is coerced into a date field, and I want that date field to feed into my reference field. This should be simple but I continue to get the following error. Validation error: Incorrect template "{{a.packed_date}}". ValueError: invalid literal for int() with base 10: 'packed_date' Input (Mapping) production_date_mto_reference:"{{a.packed_date}}" I have built a similar pipeline without error but this one is not working. Any help would be appreciated. ------------------------------Michael Pelzer------------------------------
Hej everyone!I'm trying to set up a pipeline that captures a value at 5pm.The one with the value is set to a Numeric Fomula: ToNumber(SumValues(GetRecords("{1211.TV.'"&[Adviser_7]&"'}AND{2723.LTE.1}AND{2716.EX.1}","_MyApp_ID_"), 2731)) The other field is an everyday blank Numeric field.I can write numbers between each other, but as soon as I try to write the value from the formula above to the latter, I get this error: Validation error: Incorrect template "{{a.total_adviser7}}". ValueError: invalid literal for int() with base 10: 'total_adviser7' I've tried these expressions: {{a.total_adviser7 | int }} {{a.total_adviser7 | float }} {% set stringNumber = a.total_adviser7 %} {% set integerNumber = stringNumber | int %} {{ integerNumber }} But alas, none of them worked. Any kind of guidance with this, would be immensely aprecciated. Cheers,------------------------------Lordsman Burgos------------------------------
Discussions Hi QB Community! I'm looking for some help with a formula. I'm building an employee onboarding workflow in Quickbase. There are multiple programs that will use the app and each program has its own Tasks records and its own Team Members (team members are QB users). Team Members are assigned to a Program and to a Role. Each Task is also assigned to a Program and a Role and that's how a person (QB user) is tied to a task. An example of a role is "Hiring Manager" or "Program Trainer". In the Tasks table, there is a multi-select field called 'Send Notification To' and the values are the different roles. When a task is completed, the users assigned to the roles selected should receive a notification. I'm trying to creating a user-list field that I can use in the notification that will display only the users that align with the selections in the 'Send Notification To' field. This is the formula that I've created but it only displays the user from the first selection
I'm trying to find a formula to color a record row in a report that if the date in my date/time field, registration_completion, is within the last 24 hours, color it yellow. This doesn't work so I know I'm missing something. If(ToHours([registration_completion]=Hours(-24), "#00FF00") Any ideas appreciated. Thanks. ------------------------------Dawn Rene------------------------------
Just wanted to throw this out there in case anyone else has experienced this? When adding a field into the "New Forms", the popup windows doesn't always seem to work, sometimes does and sometimes takes forever. I'll try a different browser to see if it's consistent or not there. I'm using Chrome now but will try it in Edge next.------------------------------Glenn.------------------------------
I have a field in child table (patients) that pulls the client name from parent table (clients). However I want to only pull clients from the parent table that are active. Right now it just pulls every client in the client table into the dropdown. ------------------------------Rebecca Knecht, MS, ACSM-CEP------------------------------
I feel like I'm missing something easy here.... In a form, when using a dropdown selector for records from any table, I can limit the choices to be based on filters in any report, among other easy methods. However, in a report or grid edit report, when selecting a record in grid edit, I can't find a method to limit that selection to certain criteria, based on that specific report. Can this be done? ------------------------------Joe Hargrave------------------------------
Hi all, I'm quite new to both QuickBase and power automate, and my current task is to use power automate to upload data to QuickBase. Currently we have excel documents in SharePoint, that have standardized tables in them. Ideally, we click an automate function in SharePoint, and it finds a table name in that document, finds the matching table in a QuickBase app, and uploads the data (there will be shared column names), and does this for the several tables we have in each excel document. I'm reading lots of documentation and getting my head around it a bit - looks like some combination of list rows present in table (for excel) and insertandorupdate records (for quickbase), but any advice would be appreciated.------------------------------Thomas Otten------------------------------
Is there a way to audit/view pipelines and see which table they trigger on in an app? I am getting the 90 limit pipeline error, but from what I am seeing, in the Connection Central, I can only see all the pipelines connected to an app, but not which table they trigger on. (there are only 43 total pipelines on this app, so I need to figure out where it thinks there are 90 pipelines on a specific table.)------------------------------Kaitlyn Stanley------------------------------
Team, I had this situation when I was working long in Gantt Plugin making many changes to my plan. After some time my Quickbase app was logged out (as I was not doing updates there in app, but only in Plugin). Unfortunately, even if I logged in before hitting Save in Gantt Plugin, after saving Gantt Plugin I see saving for 10 minutes and not progress. Is there an option to make sure that when I use Gantt Plugin, my quickbase connection is not lost and I am not logout from my app? As now I will need to re-do all my work :( ------------------------------Adam Krzyzanek------------------------------
1) Is there special requirement for Formula Button to enable GenCopyRecords with New Form? Previously I used below formula, but with New Form it just open previous records. URLRoot() & "db/" & [_DBID_INITIATIVE] & "?a=GenCopyRecord&dfid=13&rid="&[Record ID#] When dfid=13 refers to Legacy Form it works as expected, but when to new it just open already created record. 2) Also I do not see options option to "Copy this Record"------------------------------Adam Krzyzanek------------------------------
Hello, I am trying to build a support platform and was wondering if it was possible to create a notification on a Parent table when a record is added on a Child Table. For example, someone puts in a support ticket (new record on the Parent table) and a support member can enter a Reply (new record on the Child table). My hope is that the notification would let the person who created the support ticket on the Parent table know that someone has replied to them.------------------------------Cassandra Friend------------------------------
Hello, Is it possible or does anyone know of a way to create a dropdown of email address, where when a non-users fills out the form, a notification will be sent to the email they selected from the dropdown? This would be used as a type of automatic confirmation email for specific non-users when they fill out a form. I am worried about errors when typing out email addresses, so would like them to choose from a dropdown or list. For the notification, I am putting the permission type as Open and then the Text-Multiple Choice field into Notify whom but I receive an error saying that: 'The Field' is neither a User field nor an Email address field. These are the only field types accepted for this type of Notification.Does anyone know a way to accomplish this? ------------------------------Cassandra Friend------------------------------
Hi everyone, I have a formula field (see code below) that gets the current date and time. Then formats it to a certain way. The issue I'm having is that this formula field updates the content of the field outside of Edit>Save Record operations. Ex. 1) If I go a table and view all the records. The formula field updates everytime I refresh the page.2) If I go to edit a record, then discard any changes. The formula field updates. PS. If there is a better way to format the date, please let me know! //Intended Time Format 12/21/2021 17:00:19 //Get time var number numHour = Hour(ToTimeOfDay(Now())); var number numMin = Minute(ToTimeOfDay(Now())); var number numSec = Second(ToTimeOfDay(Now())); //convert to String var text getHour = If(ToNumber($numHour) < 10, ToText("0"&$numHour), ToText($numHour)); var text getMin = If(ToNumber($numMin) < 10, ToText("0"&$numMin), ToText($numMin)); var text getSec = If(ToNumber($numSec) < 10, ToText("0"&$numSec), ToText($numSec
I want to delete a single condition from a list of three set up for a form rule. I can see that each condition should have a menu that offers a 'remove' option, but I cannot find a way to adjust the screen so that I can see the menu for the condition I want to remove - it's off the right-hand edge of the screen and seemingly inaccessible. Anyone have any suggestions?------------------------------Jeremy Anson------------------------------
Good afternoon, I currently have a formula date named "Sanitary Survey Due" based on a different field: WeekdayAdd([Last Hazard Survey:], 1305) I also need this formula to have it so the date that is displayed for Sanitary Survey Due be ONLY the year, and not a date, but I don't know how to do this. ------------------------------Newman, Savi------------------------------
Me again...: ) I have a formula field that combines the selections in 2 different fields. The result of which is copied to another field when the form/record is saved. (This is to create a relationship filed to another table.) - This step works as expected. I have a checkbox that looks to see if there is a record in the related table for the value in the relationship field. Unchecked, no record. Checked, record. - This step works as expected. I have a pipeline that is set that when a record is created, if the box is unchecked, then create a new record in the related table using the relationship field as the primary key. No other fields from the parent table are copied. - This step appears to start too "early" as the resulting created records do not have the correct relationship field. Scenario - user selects create new record and must select a Property and then select a Year. The formula field on the form is a simple concatenation ([Unit - Related Pr
Is it possible to format a Form template such that there's a URL embedded on every single form as a universal part of the template? (I don't care if it's a button, but I do care that I can format it for ease of looking at it). For now, I created a backend table for "Buttons", but have to manually input them for each of our forms. It seems like if you do a button through Fields, you're going to have to then manually update that Field across every form in the table, but if I try to edit the Forms templates using the Forms elements, you're left with using the Text option with HTML, and that's limited. TIA!!------------------------------Christine Kirk------------------------------
Hi Qrew! I'm trying out the new forms in a Request table that is a child of the Accounts table (one Account can have many Requests). In my first section I utilize a lookup field to show the Account #, name, and phone number. I want to insert a report from the Request table that would dynamically filter on the Account # and show any Requests that have previously been created for that Account #. I have a table report already created in Requests that lists the requests, but I can't figure out how to dynamically filter the report for display. Any suggestions on how this could be done? ------------------------------Doug Crandall------------------------------
I was wondering if it was possible to have vertically stacked fields that correlate to the same row in a form. I want to prevent too much horizontal space when filling a form. The last column has 3 elements for example in the image below that need to be vertical rather than horizontal. ------------------------------Bob Jones------------------------------
Hello everyone! Is it possible to create a drop down list where the choices are pulled from 2 different tables? My situation is this: We are a custom sign manufacturer, so our projects have Customers (ie: "Bill To"), and Locations (ie: where the sign is being installed). Customers can have many contacts, and Locations have their own many contacts. For a specific project, I have it set up where we can choose the customer and then the contact and location. However, for the Location Contact, I want to be able to choose from both the Customer Contacts & the Location Contacts. I hope that made sense - thanks in advance for the help!------------------------------Allison Watson------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.