Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, I am using the existing Quickbase channel for our employee credit card reconciliation. We currently have a table which imports data from our credit card banking system, including merchant data. This table gets passed into employee user dashboards where each employee must reconcile their own expenses each week. Once reconciled, these expenses are exported into our Quickbooks expenses.A huge existing pain point for accounting is the fact that they have to manually enter hundreds of merchant names each month, due to the fact that the Quickbase channel in the pipeline has no place to pass the merchant name in for import. Am I missing this, or is this just something that is not possible?If I could solve this, it would alleviate a huge nuisance for our internal accountants.
Happy First of July, AEC Qrew! I have a question for you to answer:What construction stories that involve Quickbase are you interested in hearing about? Specifically, are there current workflow or operational challenges you are looking to solve that you would like to learn how others have solved for with Quickbase? Let's start a discussion and share your thoughts below!
Is there a way to set up a way to calculate the time based upon the address inputted. There is a process in place that calculates time for locations INSIDE the United States. Is there a way to do this outside the US, besides hardcoding each location?
Am hoping to use html to make my report live on a web page. I current have the tables running fine. Just need the record to be available in the report.
I have an app with a URL to a form to generate a new record when submitted. I would like to generate a QR code that when I use iPhone camera to open the QR code the user can fill it out and submit. When I create the QR code and use the iPhone camera it opens a different form in the app. Is there a setting in QB that controls the form that opens?Brian
Hello, I am trying to pull information in from an employee table to auto fill on my form once the employee name is selected.I have successfully pulled in the employee number, employee name, email, phone number, manager ID, and second line manager ID with my first relationship. I am needing to pull additional information back from the table once this information prefills. Specifically, once the manager ID and Second line manager ID prefill, I need it to loop back to the employee table and use those IDs to look up the phone numbers for the manager IDs. (Essentially the phones numbers are only listed by employee, so I would need to take the manager and 2nd manager ID from the first relationship and pull in their phones numbers based on the Employee ID on the employee table) Every time I try to add another relationship to take the Manager ID and look up the phone number, my data pulls back empty. If I delete the secondary relationship, my manager IDs pull bac
I have a report that displays time entries. The report is first grouped/sorted by Customer Name, then grouped/sorted by Project Name. After the end of each Project certain fields are totaled, however, if a Customer has multiple projects, there isn't a similar row of "totals" for the Customer.Example:Customer A Project A Entry 1 Cost $100 Entry 2 Cost $200 Tot Cost $300Customer B Project B Entry 3 Cost $500 Entry 4 Cost $200 Tot Cost $700 Project C Entry 5 Cost $300 Entry 6 Cost $500 Tot Cost $800Tot Cost $15,000 (this is the line that is missing)Customer C Project D Entry 7 Cost $400
I have a notification created and below the designer area of that email there is the "Data Form" field. The dropdown displays other forms in my table, but not a New Version Form. How do I get my new version form to display?
The intake process must include related records attached onto the new record. However qb doesnt not let you create child records without first saving the parent. I was thinking maybe to use an embedded subform on a different step in the process, the step format does not save each page as you go so it still with not let me add a related record. What can I do?
Hello, I have a summary report shown below, 1 of 9 that I'm building. Each of these summary reports takes a particular set of Statuses and totals them. Each total OR column headers will need to be colorized (red, yellow or green) and placed on our Homepage Dash. These status totals are not related to any dates or timelines. They are used for showing the total $ amount of insurance policies that were entered for the previous month, current month and next month by status. For example, the report above shows policies from the previous month. It would be amazing if I could make the Status and Annual TP column header red, given these totals represent policies that were Declined, Surrendered, Withdrawn etc. My next report would then be colorized yellow for policies that have a different set of statuses, then green column headers for policies for example that have been paid. Hope this makes sense! I'm open to any suggestions. Thanks for any help!
I am trying to create a multi select field that looks at a report from another table not just one field. We have to be able to add the field while ADDING a record so adding a child record is not possible.
I need to edit a figure that is in a Column that is "not editable" for some reason. The pop up stating "____ is a Summary Field. Summary Fields are not editable." Can anyone help?
Hi, I need a report formula that will change the header/column name to whatever year is "Year 1" based on a date (a start date, let's say).How do you do that?
Hello Everyone, I have come across an issue with the new form which I am not sure how to solve. We currently have a relationship set up between 2 tables which allows for a user to select the county they live in by inputting the zip code and state, which then shows a drop-down of the counties they could live in. This works correctly on the old forms as looks like this: The field settings are setup as such: I am now transitioning over to the new form and it will not allow me to do the same thing it shows on the form: Even when i do as it tells me to and change the zip code it will not allow for the drop down. I cannot figure out what to do, please help. ------------------------------Benjamin Brooks------------------------------
I followed Kirk Trachy's steps in the YouTube Video "Embedding OneDrive Files in Quickbase". Clicked on the preview in the Pages folder, the data was there... copied the preview URL, then placed that into a Web Widgit... and nothing! Why can I see the data in the Pages Preview, but not on the dashboard??
The roles in Quickbase that we have set up don't allow our users to see the Users table to see if the user is registered or not by the status field. Since this is a pre-existing table it doesn't seem possible to create a relationship between the Users table and our Employees table. Is there a Query that I could use to get the status of an employee to distinguish if they are Registered, Unregistered, Unverified, Deactivated, or Denied in another table?
Here is a high-level overview of my tables along with the related fields:Schools (school name, etc.)Class Types (school name, class name, age range, etc.)Available Seats (school name, class name, start date, cost, etc.)Then I have:Parents (parent name, etc.)Children (parent name, child name, child age, etc.)For each parent, I would like for them to be able to select each of their children, enter some search parameters (date, time, etc.) and only see the available seats for that particular child based on those user-selected filters. Once they select one of the rendered results, I would like for them to be able to book that seat, move to the next child, and then have a total cost of all seats selected. I hope this makes sense.
I am creating a time tracking application. Need to allow for entering actual hours and for the use of a clock in/out option. Here is the set up:Time Entries - table to track/enter specific work tasks performed for each Project. Time worked can either be entered directly into an Hours Worked (numeric field) or it will calculate Total Time (duration summary field).Time In/Out - table to clock in/out for a specific Time Entry. All in/out entries are summarized into the Total Time field in Time Entries.My Time Time Entries table has a field Hours Billed which displays either the Hours Worked or the Total Time. All these fields are visible on the Time Entries form but since they are of different types, they display differently.Example, if the time entry is for 30 min the:Hours Worked (numeric) displays as 0.50Total Time (duration) displays as 0:30Hours Billed (numeric) displays as 0.50How can I get Hours Worked and Hours Billed to display like Total Time?
I'm making a request to the Quickbase JSON API and getting the results to use in the next Pipeline step. I can see the field type is "timestamp" and the value is an iso date timestamp, such as "2022-10-12T17:26:42Z". I cannot seem to format this into a readable date/time string to send in an email, or use in another step.There are no Jinja filters that seem to work, as the Quickbase flavor of Jinja is so limited.I cannot us strftime because it's not a date, but a text string. There are other platforms and documentation for Jinja that refer to a filter such as: iso8601_to_time. For example: (this would be great in QB Pipelines!) {{ iso_date|iso8601_to_time|datetimeformat('%a, %B %d') }} Any ideas? Thanks!------------------------------Joel Hickok------------------------------
I'm encountering QuickBooks Error 1903 during the installation process. This error message indicates an internal issue that prevents QuickBooks from installing correctly. What steps can I take to resolve this issue? Any detailed guidance would be greatly appreciated!
Good afternoon all -Found what I think might be a bug to bring to your attention. I create a new Grid Edit report, and specify specific report columns. Upon the initial save of the report and viewing, it shows exactly the columns I specified. However, if I ever click the save button at the top of that report, it appears to reset my column specifications and show all columns. The settings of the report still show it configured for my specific columns, but no amount of tinkering can resolve this in my efforts.EDIT: Images are kind of out of order. Image #1 is the report config. Image #3 is the initial column headers, matching the config. Image #2 is the column headers after clicking save a single time.------------------------------Josh Payette------------------------------
I have a URL Formula button on a record form, whose purpose is to prompt user for text input, update a text field with that input, and change status of record to "Done".I used the "Prompt for Input and Refresh" example in the code pages samples: https://resources.quickbase.com/db/bq8mgh24g?a=dr&rid=10414After clicking the button, the field value updates, but the rather than display the record refreshed, I get an error: 404 Error, Page Unrecognized.So the first part of fetch code is executing correctly, but it seems the redirect is what is failing. Any help would be appreciated! Here's my button code:var text urlToExecute = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=MYAPPTOIKEN&rid=" & [Record ID#] & "&_fid_26="; URLRoot() & "db/" & AppID() & "?a=dbpage&pageid=5" // Open code page 5 & "&url=" & URLEncode($urlToExecute) // Pass the URL to executeHere's the script and form portion of my code page 5:&
In one app I checked to view a table report in the New Style (beta). Now every report I view in any of the many apps I manage defaults to the New Style. I do not like this new style as all of the dynamic filters disappear from all of the existing reports. How do I change the default back to the "old" style. I have been fielding questions from customers today for they too are asking how to switch their default back. Not very friendly.------------------------------Suzy Kania------------------------------
Hey, looking for a qualified candidate for hire. Job specifications are as follows: Quickbase Developer / Infrastructure Development Responsible for the development, deployment, and support of applications within a Quick Base environment. Manage advanced technical support for Quick Base applications and data sets utilizing Quick Base development, Clover ETL, API integration, SQL, JavaScript, php web services, and AHK automation. Architect for application development teams, feature enhancements, strategic initiatives, design and planning, prioritization, and on-boarding activities across the engineering organization. Beneficial Skills to Have: Quick Base Development (Expert Certification) Programming Languages: Javascript, HTML, PHP, Python, API Integrations, CSS, Auto Hot Key (AHK) Troubleshooting experience: Web services (xml, json, error codes) Clover ETL or comparable ETL Software experience Data Analytics – Tableau, Excel, Macros (VBA), Advanced Formulas Da
I have a parent table (Botruns) that has many children (Line items). The line items could either be processed or not processed and the data for that resides in the line item record in the child table. These line items have an identifier SvcOrderLine# which need not be unique. I know how to summarize the distinct SvcOrderLines in the parent table. But how do I summarize the reasons the distinct lines were not processed when those reasons are captured on the line item record? I was able to create a 'combined text' summary field in the Parent table for 'Reason not processed' but how do I count them now?- Deepa------------------------------Deepa Deepa------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.