Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello AEC Network Qrew! Thank you to all who were able to attend Tuesday’s AEC meeting. Here’s a recap of our meeting: o Kaity Strong, Solutions Consultant, finished up part 2 of her “AI in the Construction Industry” series where she focused on how to use Lucid Chart to build tables for apps, and leverage Quickbase’s AI smart builder to build an application and Pipelines. She offered a lot of great tips to on how doing this vs. starting from scratch makes it easier to prop up the structure of your apps and customize as needed. o There were a lot of interest and engaging questions around the AI Smart builder from the audience! o Be sure to check out the recording of our meeting here. Passcode: wmka%N#2 o We are taking a summer break in July. Our next AEC meeting is on August 20th 2024! o If you are interested in sharing your use case with our group, be sure to reach out to me and I’ll be happy to follow up. Thank you and have a
I have a two part question here, either would work:1.) I built an app with a daily inspection checklist for a variety of different equipment, where I put all equipment checklists in one form and made formulas to only show and require the specified machine’s checklist when selected from an equipment list at the top. It works well on the web based Quickbase, but when I load on the Quickbase app for a phone/tablet it shows all machines and checklists. Is there a workaround? 2.) If not possible my other thought was use different forms for each equipment, but is that possible within one table? I was trying to build different action buttons that each went to a different machine checklist form but was having issues. Any thoughts? Thank you, any help would be greatly appreciated.
I have a "Daily Inspections" form that is mainly for use on the Quickbase app for tablets. It has a dropdown list of equipment, and will display and require the Pass/Fail inspection items for the specified equipment when selected. My issue is that I have for each equipment a "Pass All Checks" checkbox, that when checked is supposed to change all items to "Pass". When it is checked, it is usually only passing the first item and leaving the rest blank, and then have to be manually filled in. A second issue is that a comments box at the bottom is supposed to be required upon any item being marked as "Fail", but that is not happening either. It all seems to work on the desktop version however. Any insight? Thank you.
Has anyone dealt with QuickBooks Desktop Error C 343? I'm encountering this error when trying to launch the application. I've tried updating QuickBooks and checking my system files, but nothing seems to work. Any advice or detailed steps on how to fix this issue would be greatly appreciated!
Hi All,Can you please help me with a function/code to count the number of specific characters in a stringI would like to find the number of semicolon (;) in the string "hi;how;are;you;"thanksPushpakumar------------------------------Pushpakumar Gnanadurai------------------------------
Y'all have been so helpful! I'm hoping I can figure this one out!I need to create a summary report that shows these totals in an easy report. I can't seem to figure out how to only have current MTD or YTD, just group by Month or Year, which isn't what I need. I can create a KPI widget for everything, but is there a way to show the KPI numbers in a chart that can be exported for our company analyst group?I'm hoping there's a relatively easy way to do this! Thanks!
Validation error: Incorrect template "{{a.wo_id}}". ValueError: invalid literal for int() with base 10: 'wo_id'I have a pretty simple Pipeline set up that looks at a connected field for two fields both text fields (WOID# and Alert#). Then looks at another table, not connected, for matching WOID# and updates the Alert# on that table. They are both text fields, the values clearly match. But I keep getting the above error. Any suggestions?
Wondering how to rename an existing Form?Could someone provide the steps if possible?
Hello everyone! I hope you all enjoyed your weekend. We're looking forward to our first virtual meetup tomorrow (6/18) from 1-2PM EST. If you have yet to register and are able to attend, please register here! Here is a light agenda for the conversation:- Introduction to Women's Qrew leaders- Purpose Statement- Hear from Heather Karas about her experience using Quickbase- Call for presenters- Set meeting cadenceWe're looking forward to hearing from YOU tomorrow, so come prepared for an interactive session :) If anyone has any questions, please feel free to email me at tluccio@quickbase.com.
I'm experiencing QuickBooks Error 185 whenever I try to update my bank feeds. It seems to be related to bank connection and verification issues. Despite entering my bank login credentials correctly, the error persists. I've tried refreshing the connection and ensuring my login details are accurate, but nothing seems to work.Has anyone else encountered this problem? If so, could you share any effective troubleshooting steps or solutions?
I have a need to 'journal' within a record.Within a record there is a <journal entry> field which always defaults on display to blank (ready for a new journal entry by a user).A user places some text in the <journal entry> field, then clicks save.The system takes the journal entry, stamps it with a date and the users name, and appends it to the <journal> field. Then clears out the entry.The journal field is a read only text field with the latest entry at the top. Much like an email chain, looking like this:Mary Smith on 1/4/2024: YesJohn Smith on 1/2/2024: Con you get me the report?I got it working 90% using pipelines. But I have two issues: I click save and the record is not refreshed, so I have to refresh it manually, that is a bad user experience, I'd like some advice on if I can use a pipeline to force a refresh/redraw, and 2), the system enters a blank line after every update. I am using {{CLEAR}} to clear the journal entry field, which works great, but after add
Is there a simple way to move a section in a form up or down? I thought dragging it would work like the fields. thanks
I currently have this If([Tour - Salesroom]= " Solmar-New", [Sales Manager]= "Mark Torontow",[Sale - Purchase Price]*ToNumber([Sales Manager Point])/100 first I am getting a yellow notice at end of 100 thought I needed ) but still yellow but I want to add more to this statement. basically need to sayIf (Tour-Salesroom]= "Solmar-New" then pick Mark jones name in Sales Manger field (frop down list) and pick 4% in sale point field (drop down list or if salesroom is VIP then pick James Dean in sales manager and pick 1.8% ins salepoint field. I donn't know what all the "fuctions do in writing a formula.thanks inadvance
Is there a way to send an email notification to an EOTI user?The scenario is an EOTI user submits a request (which includes their email address) and I want to send them a notification with a copy of the information they have submitted. However, when I look at the options in the notification To: field, it doesn't appear that I can select the email field.I also wanted to include buttons in the email that would allow them to submit updated information without actually ever getting into the app (for privacy reasons), which I understand is possible by having the button in the email prepopulated with data from the original record?Thanks for any light you can shed on this for me.
QuickBooks File Doctor won't open despite numerous attempts. No error messages, it simply won't launch. How can I resolve this issue and get QuickBooks File Doctor to open properly?
In my table I have three fields that are Text (Multiple Choice):Type of LeaveSemester of LeaveStatus of Leave When I try to create a Kanban Report, I only see two of the three fields under Card Groups > Based on drop-down field as options (Type and Semester, not Status). I'm lost as to how to get Status of Leave to be an option to choose in Card Groups. FYI: The actual choices displayed in these Text-Multiple Choice fields are different, but the three fields are otherwise have duplicate settings.What am I doing wrong and how can I fix it so I can have Status be the card group??
My customer would like to focus the information given to City Council to just the last entered month, but also wants the prior year(s) same month as well. Here is how the chart currently looks in Excel. I can easily accomplish this using dynamic or standard filters. The challenge is, he wants this to be a rolling month. So, he really wants it to be the last/newest month entered. We obviously don't want to go update the filter every month to only show the last entry. I can't work out the filter, or maybe a query, to make this happen. ------------------------------Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)IT Director City of New Braunfels------------------------------
Hi There,I currently have a url button that populates a certain field with the user that last modified the record. I need some help to change it from the user the last modified the record to the current user that pushes the button.is there anyway to modify the below for the above requirement?var text URL = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Record ID#]& "&_fid_30=" & URLEncode([Last Modified By]);"javascript:" &"$.get('" & $URL & "',function(){" &"location.reload(true);" &"});"& "void(0);"
I am trying to get the Quickbase app to load on our Samsung tablets that we have at our manufacturing plant, however whenever I try to log in with the app on our company's realm I get various error messages. One of the tablets has a message ending in "net::ERR_ADDRESS_UNREACHABLE", and the other has one ending in "net::ERR_TOO_MANY_REDIRECTS". If you would like me to send a screenshot I can do that as well.Any information would be greatly appreciated, thank you!
Hi all,I am trying to allow site managers to enter information for multiple employees (name, hours worked, hourly rate) and have this calculate an average rate for the site. I do not have access to employee information so I cannot create a separate "employees" table - this information would need to be entered by each manager. I am using the site # to pull in information such as the benefits %, which will be read-only and used for calculations. I also want managers to only see information for their own site(s). So far I created a grid edit report that has the correct fields and my calculations are working, but the issue I'm running into is that if I want to add my report to a form I have to create a relationship, and in so doing I am forced to link to existing data that is limiting how many entries one manager can make. I would like to be able to add my grid edit report to my form and not have to link it to the larger data environment, so the manager can put as many entries as
I am hoping to find a way in QuickBase pipelines without using Juiced to retrieve a results after a customer signs an envelope in Docusign. I have different custom fields ranging from checkboxes to radio buttons. Alternatively, is there a way to call this information with Docusign API? Or a webhook? Where I can retrieve the listed custom fields? I tried already doing what was suggested in the channel but nothing comes up under document_fields after I lookup and find the Envelope: Any assistance or advice would be so beyond appreciated thank you!
I'm trying to send a request to the fedex api for checking package status. I have everything working up to the step where the actual request is being made and it appears the headers are not being constructed properly by the pipeline channel:Here, I'm just using the example, but instead of headers like:X-One:OneX-Two:TwoI'm getting this weird structure where it's only passing the names and values as arrays? This keeps getting rejected by the fedex api stating that the token is missing. I'm sending the headers like this, per the instructions beneath the headers section, but I get the same malformed result in the output:Has anyone else run into this or knows what the problem is here? I've been stuck on this for hours.
Hi all.Am trying to create a formula URL field that creates a link that will be used in an external website so users can download an attached PDF.I have marked the actual attachment field so it can be viewed without login.Current Formula : "ourrealm.quickbase.com/db/relevantinfohere/a/r"&[Record ID]&"/e277/v0"But on click, it just reloads our current dashboard. Any help as to where I am going wrong will be appreciated.
I am struggling infinitely with what I feel like aught to be so simple. It may involve pipelines, which I haven't broken into yet.I want to log changes when a field changes (assigned staff member). But first off - you can't save changes in a User field. Second -- I've noticed when you log edits, the field then displays on forms as the entire string of changes..... so I've often thought, if logging is important AND displaying on a report (or filtering to charts) cleanly is needed, then it's probably best to make a surrogate field. So here I am trying to make two fields -- 1) Current Staff Assignment, and 2) Staff Assignment History. The former triggers a change/logged edit in the latter. But I have no idea how to go about doing this. I was going to do it with Form Rules, but for multiple reasons (chiefly, that I'm using multiple forms depending on staff/use), I want this to trigger at a more global level. How can I achieve this?
Hello,I'm wanting to add or know how /where the options that drop down in the "Based On" field for Card Groups come from?Thank YouShirlee------------------------------Shirlee Roche------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.