Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Is there a way to rearrange the Apps on the dashboard ribbon? I'd like the most used apps to appear first (on the left side) on the MY APP ribbon/dashboard.------------------------------Bruce Kasen------------------------------
Hi, I need a formula field that will list some Years if the corresponding Year checkbox is checked.I'm not sure if this screenshot size is ok or not - it looks super tiny when pasting it.In the field "Funding Years", if the corresponding Year has a checkbox: First year Ask is checked, then List the First Year in the Funding Years. If ANY combination of those "Year ask" checkboxes are checked, then I want to list that Year in the "funding years".I've tried all the formulas I can try, I keep getting a mismatch of boolean and number errors, or all of the years populate.My formula right now is:var bool one = [First Year Ask] = true;var bool two = [Second Year Ask] = true;var bool three = [Third Year Ask] = true;var bool four = [Fourth Year Ask] = true;If($one or $two or $three or $four,List(", ", ToText([Year 1]), ToText([Year 2]), ToText([Year 3]),ToText([Year 4])))I tried putting "or" in there, but it doesn't seem to take it.
Hello, I have a parent table called projects and a field called "status." The status field updates based on if the project is on track and can change from on-time to late. I want to generate an e-mail notification when the formula field changes the status to late. Is that possible? I've tried to use the modified action but it only seems to work when someone manually changes the field vs a formula handling it.
Hello, in the documentation for the RESTful API, it states "Update can use the key field on the table, or any other supported unique field". Does anyone know what the "other supported unique field" parameters would be?Instead of using the key field, I would like to use a different unique field I have called "ShiftId", to update existing records. When utilizing this field it does not update based on that field. It just errors with; "Adding non-unique value for field with ID \"69\"."I cannot find any documentation to figure out what would make it a supported unique field.Any help is greatly appreciated.Thank you!
Hello AEC Network Qrew! After taking a summer break in July, the AEC Customer Network is back to meet some new faces and share some wonderful updates for this industry focused group. Agenda for Tuesday 8/20/24: Rob Salaj, Customer Advisory Director, will present the roadmap for upcoming construction-focused apps in the Quickbase exchange and outline his Quickbase vision for the architecture, engineering, and construction vertical. We’ll also introduce you to new faces from Quickbase who will be valuable resources to our growing network group. Click here to register and join the AEC Meeting
Hello Mobile Workflow Customer Network Qrew! After taking a summer break in July, the Mobile Workflow Customer Network group is back in action this August. Agenda for Wednesday 8/21/24 12pm EST: Jenny Gomez, Tech Support Engineer, will be joining us to review and answer FastField’s FAQs and offer tips on how you can get ahead of any potential data collection and reporting challenges in the field. We’ll also have a quick product update from our mobile product team to share with you all! Click here to register for the Mobile Workflow Customer Network meeting
My assigned task is to create a field in a table that shows a unique number for each record created but isn't the Record # ID field (as this field number is unique to the table) and we need a number that is unique to each task but associated with a single initiative. So the sequential number will be associated with a unique initiative name and if the user selects a different initiative name then the sequential number will start at 1.
I am trying to write a report formula that is triggered off a checkbox and two different dates that I would typically write an IF AND formula. Anyone know how to make this work? It is giving me an 'expecting ,' error. The Cybersecurity field is a checkbox.The Engagement Begins is a date field.The Cybersecurity Discovery Engagement Ends is a date field.The logic should read if the Cybersecurity checkbox is checked AND the Engagement Begins field is blank, then the field should read "Upcoming", but if the Cybersecurity checkbox is checked AND the Engagement Begins field is not blank, and the Cybersecurity Discovery Engagement Ends field is blank, then the field should read "Assigned", otherwise show nothing.
I have asked about this before and at the time the integration did not have much to offer. But can have Quickbase integrate to Fastfield as a lookup? We want to do inspection forms in Fastfield and have Quickbase feed into Fastfield with account names. It would be great if the completed form can somehow feed back into Quickbase.
Howdy y'all.We use Quickbase for an HRIS. Within the HRIS, there's an employees table that contains fields for the hire date, termination date, and status.An example employee could have a hire date of 08/01/2020, a termination date of 08/01/2023, and a status of 'Inactive'.I've been asked by HR to calculate turnover. The formula they provided requires me to first calculate average daily active employees for a given time frame.The way I see it, if I just had that one example employee, that report would look something like this:Date# of active employees07/30/2023107/31/2023108/01/2023008/01/20230 Average daily active employees report would look at each date and count the number of employees whose hire date was on or before that date, and their termination date is on or after that date or null, and their status on that date was active. In this example, the average daily active employees for the given time frame is 0.5 (2 divided by 4).I would then need to create a summary report
The business is wanting a list of all the fields on the form as well as the help text. If there is an easier way to do either please let me know. The form is large and I do not want to type them out one by one. We are using the new form
Hello,I'm currently working on a project where many tables have relationships and require automation features. For instance, if a user selects an option from a lookup field, [Field X], in Table X, then in doing so, [Field Y] will increment in another separate table, Table Y.My design right now is built on a set of reference tables that can be utilized in an operations table. My goal is to "trigger" events such as the one described above to reduce clutter in the operations table. I can provide screenshots and table data/field info if the structure of my app is not sufficiently described. All of the data are just filler to work on functionality.Many thanks,Gabe
I created a new role and gave a user access to test the role. She can't see two fields on the form. When I test the role as the role I can see the two fields. When I test it as the User I can not. Things I have done. Had her clear cache, reboot browser, computer. Opened up the role completely for full access no restrictions, gave her a new user with a new email address. and still the role I can see the fields but under her user name I can not. I am going live with this database next week and QB tech I don't think the rep starts until noon Est and I need help now. Wth - I have tried everything.
I requested a feature:Request | Feedback (quickbase.com) - here's the ticket if you'd like to thumbs up and follow.The request is to have an option to require a section in the new forms, instead of applying "required" to each field. If we can require the whole section, that might make things simple.
I am trying to make a summary table where it shows revenue per month for each customer at a company. I want to add so in between each month, there is a change of revenue displayed. How can I do this. I have tried a report link for previous months and that did not end up working.
Hello, Currently I utilize an audit log table which when viewing the form you see many sections which are divided by tables. Within each section, I have at least 3 fields:[field_name old], [field_name new], [field_name updated].Now one section (table) may have 8 fields that I want to track, which then requires me to create 24 fields. This is not practical, but it does work.My question. Is there a way to create an audit log with only a handful of fields:[field name], [table name], [old value], [new value], [updated value].Then have a pipeline which triggers on specified fields when modified, and create a record for each* field modified. So if I am trying to track 3 fields, and someone modifies those 3 fields. A pipeline is triggered and 3 records are created on this new simplified audit log.Hope my vision makes sense. I've been told, and often say myself, if you can say it out loud, it can be done in Quickbase. This one though is a doozy.Any suggestions?
Hi! I'm trying to add a column in a summary report that will show the total count of persons (in percentage) who are tagged as "Qualified Leads" from Text-Multiple Choices Field and those who are tagged as "Attended" in another Text-Multiple Choices Field.Field 1: Qualified Leads(field name) = "Qualified Leads" Field 2: Status of Orientation(field name) = "Attended"After having the total for each field, I need to divide both totals to have a percentage.Total count of "Qualified Leads" / Total count of "Attended".Hope you can help me huhu. Thanks!
Hello,My user wants to duplicate a record, I see the option to duplicate a record on my end as an Admin, but that option is not available to my user. I'm trying to look into the role settings but do not see anything that prevents the user from duplicating a record. Am I looking in the wrong place?
When i download a report as a csv, if there is a number field it will dissappear the trailing zeros. So for example:5000.10 downloads in the csv as 5000.1.This seems to be due to the fact that it marks the column as type 'General' in Excel. When a column is that type, it deletes trailing zeros.I have found that if I make it a currency in Quickbase, or text (include alpha), the csv will select type text or currency (currency keeps the trailing 0, but of course has the dollar sign - this may be a work around, I haven't tried).If the excel type is selected as 'number' it also keeps the trailing zero, but I cannot figure out anyway for the csv export to label numbers, as numbers (they get labeled as general).Has anyone figured out a trick to download a csv, and keep trailing zeros?
I'm trying to create an inventory database with my Users as a parent table and my Computers as the child table. Computers need to be assigned to users. I can go to the computer table and easily assign to a user, but I want to be able to go to the user table form and assign an existing computer.This is a Quality Of Life request, to be able to open the form view of the user and then assign existing computers from the computer table and other equipment from subsequent tables.Thanks.
Is it possible to User Global application variables in Pipelines? if so what is the syntax to use it? I assume it would be some kind of Jinja?Would I be able to loop and append data to it? then clear it out later in the pipeline?
Hi there, deploy question here. I have a production version and a development version of an app. I have added a new table to the development app and created fields and forms. Is it possible to copy the single new table from development app to production app? Is there a better way to deploy changes to a prod environment?Thanks,Brian
Hi,I have developed a project management application in Quickbase for my company. As our company continues to grow, more business units are being created, making it essential to integrate them into the application. This growth has highlighted the need to standardize our database.I am seeking guidance on Quickbase best practices for database administration. Any advice or resources would be greatly appreciated.Thank you.
I have set up a scenario where I have a master "Project" record with multiple "Task" records as children. We are using the "Copy master & detail records" button to create a copy of both parent and children records:"javascript:void(copyMasterDetailButtonHandler('&relfids=114&recurse=false&copyFid=6&destrid=0&sourcerid=" & [Record ID#] & "', 'btcc8tmst'))"In the Task/child record, there is a required user field called "Requested by" in which the person who creates the record becomes the default value. However, when using the Copy button to create new task records, this field remains blank. Noting that this field in blank in the original task records being copied. Why doesn't this field get updated with name of the user who creates the tasks via the button?
I have an app with multiple tables for equipment inspections, work orders, and some others. My equipment inspection form includes a variety of multiple choice questions (with Pass or Fail as the options for most), and a "Result" field at the end that displays as Pass if all checks pass, or Fail if any of the checks fail. My goal is to automatically generate a work order (which is another form in the Work Order table that can also be created on its own) in the event that the Result is a Fail when the Daily Inspection is saved. Any thoughts on this? Thank you!
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.