Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Greetings, There is Table A (parent table) and Table B (child table). Both tables are children of parent Table X. I need a button or link on a report from Table B. The button should open a record on Table A that I classified as "active" on Table X by a summary field. Is there any way to do this? Alternatively, I need to create a way to relate all records from Table B to a specific record ("active") from Table A. The "active" record will change as the status of that record progresses. Any tips or advice would be appreciated. Thanks------------------------------Ethan Brunhofer------------------------------
I'm new to Quickbase and I'm exploring the possibility of moving a report out of excel into Quickbase that leverages a relatively large table to generate five simple pivot tables based on selections made across 15 or so splicers like the examples below. I'm starting to think it won't be possible due to the limitation of 5 dynamic filters in Quickbase. Has anyone done anything similar to this or have a recommendation on a different approach? ------------------------------Jeremy Shearouse------------------------------
HI,I'm using the 'Vibrant Success' button in my text formula fields (as per the Magic Buttons Sample App), and absolutely love them.However, I'd really like to use a different colour in some instances for contrast.For example, the dark blue with white text 'submit a question' button on this forum would go down a treat!Can this be done without resorting to image onload techniques?David----Example of the kind of formula text field I'm talking about from the 'Magic Buttons' app.If([Checkbox] = false, "<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=d9eascudwjxs2sesxkjccwgtq9r&_fid_101=1&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) & "'>4B. Check a checkbox then display record</a>", "<a class='Vibrant Success' href='" & Dbid() & "?a=API_EditRecord&rid=" & [Record ID#] & "&apptoken=d9eas
I want to have my timeline report to always have the date span "Starting Date: and Ending Date: to be dynamic. A week prior to the current day and two months out from the current day. Do I have any options for editing this starting and ending date? This is for a time off chart where past time off does not need to be seen.------------------------------Brian Crowther------------------------------
I looked on here for a solution to a grid edit problem and didn't see anyone with a solution so I thought I would share a solution I find useful. I have a form with an embedded report I want to be editable using Grid Edit. The embedded report has two fields which are a conditional pair, meaning Users select an option in the first column to filter options in the second. The problem happens when a User selects the second column drop down list and there are more than 1000 results, the <Browse Choices> option appears instead of a nice list. When the User clicks <Browse Choices> the pop up window uses the default report and conditional filters are lost. While this in itself is a bug, we need a solution today. So after some thought here is our solution. On the second conditional table add a formula field with a data type that matches whatever the data type is for the matching field used in the conditional relationship (the second column). In the formula field apply fi
Test: I couldn't post to the community, so this is a test. Seems I found an issue. I had a less than symbol " < " in the Subject and when I hit post the page threw an error. I submitted a Quickbase Support ticket. Then I tried it with another test and it failed again. ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Hi, Wondering if there is a way to show both the date created and date closed for the same record on a bar chart? In the excel example there were 50 "requests" each with 2 data points, Date Opened and Date Closed. Thanks for the help!------------------------------Christine White------------------------------
Hi there, I was wondering if anyone knew of a way to use audit logs to overwrite records. Is this possible using the record_edit functionality? I have struggled to find documentation. Thanks!------------------------------Colin Fox------------------------------
Ignore.
I have a grid edit report where data is filled out, I want a field that sequentially increments from 1 to number to rows data is selected. Similar to auto numbering but within grid edit mode. ------------------------------JAW WA------------------------------
Question:How to detect how my application are connected to remove this relationship?I am on Business contract so does not have access to "Performance insights" functionality available only for Enterprise. Background:I have my Production environment, which I Copy to first develop in it before I move it to production. I spot that during copy of application Table Import still is linked to production app. I already removed all Table Imports but still when going into "Show app statistics" it shows me "Est. memory incl. dependent apps" together with my 2 copied apps. ------------------------------Adam Krzyzanek------------------------------
Does anyone know of a way to edit a form created in the old form bulder to the new format? Or import the old form into the new format? ------------------------------Jenifer Kerr------------------------------
I am looking for a way to view, in table format, all Parent records AND any related Child records. I understand that some of the data displayed will be repetitive, but that is okay. If I create the new "table view" from the Child, then only those Parents will show where there is a connection. And my only option from the Parent side, is to create Summary fields, but I don't want a summary, I want to see all the records. Part of this effort is to see which Parents don't have certain Children. I think I could create a report or table that would just display this information, but I'd like to see it in relation to all the Children records. My work around for now has been to export the entire Parent table and Child table into Excel and manually match Parents up with Children so that I can see all the relationships and even those without a relationship. Just seeking a more automated or programable option as manually is not a quick process.------------------------
Greetings, all - I'm in search of a way to track and notify users when a the data in a field changes. As an example, I'd like to send an automated notification when the name of a project is changed. In the notification, it would include the original project name along with the new one. Any ideas on how to most easily do this? Thanks!Colin------------------------------COLIN KELLY------------------------------
I'm having difficulty figuring out how to add a line item to an existing QuickBooks Online Invoice using Pipelines. If I choose the action "update invoice" and put in the info for the line item, it over-writes all of the existing line item data, leaving me with just the one line I was trying to add.Is appending a line item to an existing invoice possible without have to resend all of the line items data again? Thanks in advance!Mark------------------------------Mark Corcoran------------------------------
Hi everyone! Does anyone know how to add multiple lines to a Quickbooks invoice via a pipeline? Is that possible? For example, I have a Job record in Base that generates a Books invoice via a pipeline. The Base record has multiple child records that I need to be able to insert as multiple line items in the Books invoice. Thank you! #quickbooks #Pipelines #channels------------------------------Elena Larrabee------------------------------
Hi, We have a contact table that includes a reports to field. I have been asked to create a report that also includes the subordinates in addition to direct reports. Trying to think of the best way to do this and wondered if I could use an advanced query in the report filter? Thanks for your help manager-supervisor-subordinates------------------------------Christine White------------------------------
I have a pipeline working that creates and updates Sharepoint Items. However, no matter what I try, I cannot get it to populate the Sharepoint "Assigned To" Field. Even when I try to use Static Text, it does not update. I have double-checked the Sharepoint API settings as best as I can and there seems to be nothing there prohibiting API updates. I have tried various Jinja syntaxes and nothing takes.------------------------------Nick Charalambousnick@em-dev.co.ukLondon, UK------------------------------
Is it possible to use table contents as source for multi-select dropdown field in different table? For example, I have a Locations table and a Categories table in my app. In the Locations form, I want users to have the ability to add multiple categories from the Categories table (specifically a list of values from the Category Name field in the Categories table) to the Location record. The goal is more about defining categories than it is relating records. Is this possible? ------------------------------Matt Makris------------------------------
I cannot edit a Pipeline while it is running, when I do it stops. Users are unable to do work because the Pipeline is stopped. I cannot edit the Pipeline. Do I make two Pipelines and keep them aligned by changing both the same? Do I copy the Pipeline each time I make changes and then after making changes to the copy, stop the old Pipeline and then start the new Pipeline? Do I wait until everyone has gone home and make changes after hours? Do I export the yaml into another Pipeline, make changes to the temp Pipeline and then export - Import back into the old Pipeline? Hmmmm------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Hello, I've currently got a pipeline that is triggering based on a Checkbox - Formula Field. The formula returns true if a file is uploaded. The first time that I trigger this, it works as expected, and my pipeline then processes, and deletes the attachment (Via an API call). The problem, is that the 2nd time I try to upload a file to the same file attachment field, the pipeline not be called again. I've even added a field to update at the end of the pipeline so that the record is saved again. I know that in general you should avoid using Formula Fields to process this flow, but I'm a bit at a loss how else I could detect if a file is uploaded or not (more than once, at least). ------------------------------Jake Mauk------------------------------
My approach to what I need to do may be flawed as I'm new to Quickbase but I'm trying to figure out how to use the results of one report as the filter criteria for a separate report. For example, in report 1 I'm pulling a list of case #'s based on certain filter criteria. Report 1 comes back with the case #'s I need including ID Numbers associated with each case. What I'd like to do now is pull another report (Report 2) which is filtered to the ID Numbers that were brought back in the first report. Any suggestions would be appreciated.------------------------------Jeremy Shearouse------------------------------
What is the API limit for an Enterprise? How many calls can we make in a day or in any time period? What happens if I exceed my API limit?------------------------------Praharsha K------------------------------
Good morning , I currently have a Resource Check In Date - Date field Resource Check In Time - Time of day Resource Check Out Date - Date Resource Check Out Time - Time of day Total Hrs - Duration field ([Resource Check In Time]-[Resource Check Out Time]) Currently the results duration times are incorrect. How do i have it calculate the total hrs, and also anytime there is a checkin after midnight the results are a negative number. Also the results should roung to the nearest minute. The results are showing 8 decimal points (20.3333333333333 hours). Hopefully someone can help me. ------------------------------Dell Delemar------------------------------
Hi everyone, thanks in advance for the help. I have a "Team Members" Table which is a table of all of my employees. It is a one to many relationship with a "Compensation" table where I enter all of the compensation for each employee. On the Team Members table there is a report called "Payroll Sheet" that will be used for bi-weekly payroll. It prints out the team members name, annual salary, bi-weekly salary, which is used for payroll entry. Currently, I am taking the largest salary for each team member on that sheet. However, two of the owners have decided to reduce their salary. So now I do not need the highest salary but I need the most recent (effective date salary). But I cannot just take the highest effective date as it needs to be before the payroll date. This way if we decide to give someone a raise in a month we can enter it now but it will not populate on the report until after that payroll date. So my thoughts are to create a formula checkbox o
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.