Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Ok I have 1 more issue with creating an overtime rule in the timecard system, this morning I was able to get a 40-hour rule working to move hours from regular Earnings after 40 hours to Regular over time. But I need to make it more complicated as I have 4 Pay types employees can choose from when putting in their times for the day. Below is an example of time and pay types for days of the week for totals. Monday – 10 Hours Regular Pay Tuesday – 10 Hours Regular Pay Wednesday – 10 Hours Regular Pay Thursday – 10 Hours Training Pay Friday – 15 Hours Training Pay Saturday – 5 Hours Regular Pay Total – 60 Hours Totals For each Pay Bucket Reg Earnings = 30 Hours Training Pay = 10 Hours Training Over Time = 15 Reg Over Time = 5 Right now, I have the rollover working if I just do Regular earnings using the following setup. Field 1 - [Regular Earnings before 40 hour Cap] If([Pay Type]="Regular Earnings", [Payroll Hours],0) + If([Pay Type]="Training Pay", [Payroll Hours],0) + If([Pay Typ
We've noticed some unexpected behaviour with report filters this week and wondered if others had experienced the same (perhaps as a result of changes made in the last QB update).When adding filters to a report to find data quality issues (i.e. hoping that the report returned no records), we found that while the text above the report reported '0 records', the screen populated after a short pause with all of the records in the table. When we downloaded the report, there were no records in the csv file, only field headings. This has happened more than once with different reports. In this case the count of records was correct and the screen display incorrect.Earlier today we added filters to a report that had listed '347 records' when unfiltered. The report correctly listed '81 records' after we applied the filters. When we removed the filters the report loaded with '347 records' in the text above the report, but this quickly changed to '81 records'. Downloading the data confirmed that the
Hi all,Can I automate the conversion of .xlsx to .csv through a pipeline somehow? I'm not looking for a 3rd party product, I'm trying to determine how to make the conversion myself. Our clients are able to upload any variety of excel formats as an attached file. When the file is already in a .csv format, I have a pipeline that runs and imports that file. However, I am now working on the next step in the Automation Evoluton and I need to figure out how to convert an .xlsx file to a .csv file after it has already been attached as a file by our client.My current process is to manually download the file, convert the file to .csv, then replace the client's file with my converted file. Then my pipeline can go on it's merry way. If someone could just point me in a direction, I could run with it. thanks!------------------------------Sherrie Drummond------------------------------
When you click on the eyeball on a report link to view a record, Quickbase adds some magic code (that seems to always be a little different) to the end of the URL. It appears this magic code allows for the 'Return' and 'Next'/'Previous' buttons that are on the upper right of the record.Is there any specific logic to that magic code? Can it be replicated so I can include something on my URL and have that return button appear, and also specify what it thinks is the 'return'?------------------------------Mike Tamoush------------------------------
I have a webhook set to trigger when a field is modified. It triggers fine when the field is modified within a form; when I update a record in a Grid Edit report, the webhook doesn't trigger. Do webhooks not trigger for grid edit actions?------------------------------Raymond Sakar------------------------------
I need to monitor a folder in an SFTP folder, and import the file into a (non-connected) Quickbase table once it arrives. Then need to move the file to another folder indicating it was processed.The documentation of the Pipelines CSV Handler mentions an action step using an HTTP request to obtain CSV data. Is it possible to retrieve the CSV data from an SFTP server instead (which requires authentication of course)?------------------------------Joe AcunzoQuickbase Solution ProviderSoftTechExpertsjoe.acunzo@SoftTechExperts.com203-481-1222 ext. 316------------------------------
I usually 'dynamically' filter my report links by getting creative with formula fields in both the record, and the source table, and matching them up.I'm stuck on one that perhaps isn't possible, but there seems to always be a way in QB.My source table has a bunch of records each with a date associated. The record I am on, has a date as well. I want a report link that shows me a summary by month, of all related records in the source table that are on or before that month.So for example, if the current record date is during December 2021, I want a report link of records from the source with dates from Dec 2021 and before.Thoughts? I've convinced myself it's not possible, but, am I wrong...?? If the 'non exact match' function worked in reverse I could do it, but thats not the case.------------------------------Mike Tamoush------------------------------
Hey everyone, hoping somebody can help me with a Formstack issue. I can't seem to get the tablerow function working properly. I currently have it set up like this: Area Qty Item(s) Price {tablerow from=$pull_list_items item=_lineitem} {$_lineitem.area} {$_ lineitem.quantity_proposed} {$_ lineitem.description} {$_ lineitem.total_item_price_qbmerge} {/tablerow} But, I keep getting this error:Error merging document (word/document.xml): Syntax error in template "string:{foreach from=$pull_list_itemsitem=_lineitem}" missing 'item' attributeI've also tried replacing instances of _lineitem with _pull_list_item but got the same error message. Does anybody see what I'm doing wrong? I'm trying to import rows from a table called Pull List Items, single records are called Pull List Item. Also, on a related note, does anyone know if it's pos
Let's say I have a Summary table that totals all the records in a table where [Status]="Open". These are then grouped in various ways so I have subtotals for the various kinds of records that are open. So far, so good.However, let's say my boss asks me: what were the open totals yesterday? Or the day before? What have the totals been like over time? The Summary table only tells me what they are right now but it doesn't track history, so far as I know. And with the way my data is structured, I don't have a good way of calculating what the open totals would have been because I don't have "opened on"/"closed on" dates to rely on...the only thing that's tracked is the current Status, which is either open or closed. So far I've just been manually keeping track of these totals in another table, where each row/record is a day and each column/field is some specific subtotal. But it seems like Quick Base should have a way of automatically logging this somehow. How can I do t
Even a few years into Developing, I still sometimes can't visual how to summarize my data in reports. Can I accomplish the following with a Summary Report, or do I need a summary table?I have a table of Monthly Financial Reports. Each month for each project a report is created. The fields on these reports include:RevenueProjected CostsProjected Gross MarginProject GM %Date of reportI want to create a summary report that looks as follows, but just cant seem to figure it out. Can't sort out what my summary fields are, etc to make it appear in this format. I do not think I will need to take advantage of the summary report formulas as there will only be one per month so I don't need to worry about recreating the GM% or anything (ill eventually filter by project number, this will be used in a report link): Jan &nbs
I have a Project Table (ex project 1, 2, 3) and I also have a products table.I want to bulk import products into my products table. Each product has an associated project (1, 2, 3). How can I upload the CSV into my products table and link the project at the same time? My relationship is working and I can select the appropriate project. However I'm hoping that I can avoid having to individually select each project after uploading and automate that task. Please let me know if this doesn't make sense. Any insight would be very much appreciated.------------------------------Annie Ryden------------------------------
I have a task management app where tasks have estimated effort in hours. I would like to produce a burn rate chart like what is found in the link below. I can get the effort on the Y axis but I can't figure out how to get the past 10 days in the X axis. Any idea how I can get the X axis to display the count of hours each day for the past 10 days?Burndown and Burn Rate Report - Azure DevOps Server Microsoft remove preview Burndown and Burn Rate Report - Azure DevOps Server Azure DevOps Server 2020 | Azure DevOps Server 2019 | TFS 2018 - TFS 2013 Azure DevOps Server was previously named Visual Studio Team Foundation Server. After a team has worked on one or more iterations, also known as sprints, you can determine the rate of team progress by reviewing the Burndown and Burn Rate report. View this on Microsoft > ------------------------------Justin Foster------------------------------
Good morning,I am working on a time card system and have everything working for totals but i am needing to do a formula / rule for over time carry over. So like any time card anything over 40 hours would go to over time. What i am looking to do is create a formula to move any hours from the pay type Regular Earnings over the 40 hours to the OverTime pay type totals field. ------------------------------Matthew Jones------------------------------
Hello, I have to create a date formula that is 15 business days before a date field.So if the user puts 9/20/2022 in a date field, my formula should return 9/9/2022. That would be 15 business days before.------------------------------NOEL HODGES------------------------------
Dear community members,I am a rookie to the QuickBase reporting function and want to know if my vision of some reports could be done. It is the beginning of the year, and my company starts to calculate the sales commission rate for the sales reps. I created a sales commission amount for each order, however, some orders have more than one sales rep. Thus, the commission amount of the order has to be split into 2+ amounts sometimes for the main sales rep and secondary sales rep(s) (list of users).Is there a grouping method that can allow me to group the amount of sales commission for the same sales rep, when either the sales rep is the main sales rep or a secondary sales rep?I also thought about creating a commission table and did it, but still cannot solve the problem.Please advise.Thanks,Davy------------------------------Davy Ou------------------------------
I am trying to add a report formula to get all records based on 2 different fields within the same table. The first field type of a text lookup field, it displays a list of operating facilities. Once I have the correct operating facility, I then want to get a list of records from a multi-select field, both are in the same table.For example:Get all records for X operating facility Then list all records where status =SecuredPendingOnboardingProceedRepeatI have separate reports created for each operating facility, I prefer to have all my records related to each facility listed in separate report......Any ideas of how to write this out?------------------------------Kelly Lyons------------------------------
I've got an application up that is managing the process flow for one of 6 products. When you edit a record, obviously you see the form for the table.However, I need to be able to create 5 more different forms, and route the 'edit' to that form, based on what value is in the 'product' field.I started to use Form Rules, but it's a nightmare trying to hide everything and show everything for all 7 roles.How can I click on a record in a report and be transported to the correct form, based on the Product field?
I'm doing some testing on an app and noticed functionality based on APIs/webhooks was completing its task well before the pipeline was triggered. The pipeline trigger was a field on a form, so when I saved the form both the API/webhook and the pipeline should start. Why does it take longer for the pipeline to start? I'm asking because I'm thinking of deploying a process whereby this order matters. If the were reversed, and the pipeline fired first, the webhook wouldn't run. Will it always be the case that pipelines will be slightly slower to trigger and run than APIs and webhooks?Thanks,------------------------------Daniel Johnson------------------------------
Is there a trick to forcing a connected table to run outside of its hourly schedule or being manually pushed? ------------------------------Raymond Sakar------------------------------
Hello,This is the first time I have done this and I want to make sure I do it correctly. Please advise.thank you------------------------------BuildPro------------------------------
How would I back up all the pdf’s in Quick Base? I have Juiced produce a proposal pdf that we send to customers. I would like to back up all the pdf files, not the link. Thank you.Best regards,Kyle McAfeeOperations ManagerMobile 973-229-9099Supor Heavy Haul, LLC12600 Deerfield ParkwayAlpharetta, GA 30009
I only want to display in the report the last entry:[MAY-09-13 Toni R] Internal meetings held on Monday, May 6th and Thursday, May 9th to review the customer requirements. Sales will provide the required follow-up information. Michael B will be managing this project and will reach out to the team if there are any additional questions as the project moves forward. [MAY-02-13 Toni R] Customer has provided traffic routing information. Meeting scheduled for Monday, May 6th to review with internal project team.
A few weeks ago someone posted some instructions regarding using <table> tags to create side by side sections. They also posted a zoom link with instructions, which I followed successfully. However, one thing does not work for me and I am wondering if anyone else ran into this, and is expected, or if I am doing something wrong.If I choose to have the labels above the fields (versus to the left), my side by side sections do not work. In the video instructions it worked fine, so I am wondering if something changed or if I am doing something wrong. I have:<table>Section HeadingFields</table><table> (same row)Section HeadingFields</table>Works great but only with labels on left?------------------------------Mike Tamoush------------------------------
I am looking to create a totals field for pay types in a time card system. I have created the time keeping report for the week for employees to put in their daily times. I am needing to take the times and total them in field below for the pay type they selected for each day. You can see in the screen shot each day has a set amount of fields for the time tracking. I need to associate the pay type to the Payroll hours and place the totals for each pay type in the lower total fields as a total for the week. ------------------------------Matthew Jones------------------------------
Hello I am new to Quickbase and I am looking to add a completion date field to my form. This completion date would trigger based on when the user modifies a record. The user would go into the entry, change the status field (multi-choice select) to complete, and then when that user saves the record... it would mark the completion date. Can this be done?------------------------------Daniel Sim------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.