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 working on "performance management" app and have a form that captures "staff member" along with the staff member's "manager" in separate fields on a "phone call" form. Next, we are capturing how many "errors" the staff member made on a phone call, thus I created SIX multiple-choice fields (error 1, error 2, etc.) to capture each error. I am stuck trying to associate "staff member" and "manager" to each error committed. We need to be able to summary report out on all errors, errors by staff member, and errors linked each manager. I'm trying to link/copy the value of the staff member and manager captured 1x per form to each error made captured in error 1, error 2, etc. A colleague suggested looking at the "bucket" channel in pipelines, but I am new to pipelines and cannot figure out how to make it do what I need. Bulk Record Set also doesn't seem to do the trick. Am I on the right track looking at pipelines or is there another solution I am not seeing Thanks for any guidance!
We have a EOTI app "Procurement Portal" and a seperate app "Procurement Manager" and use a pipeline to copy some data from the second app to the first however pipelines doesn't allow the the copying of attachments from the Manager to the Portal.Is it possible to have a Button in the Portal app that downloads a related attachment in the Manager app?------------------------------Tim Egerton------------------------------
How do I create the following?[INT PAINT COMPLETE] checkboxNew field =The TIME OF DAY that [INT PAINT COMPLETE] was "checked"------------------------------BuildPro------------------------------
New Report Style - Awful "New report style" limits visibility of columns. Too much white space. Awful on "new dashboards"! Need a setting on application to default to "old style". New report style expands columns to the point that many report columns can not be seen on on "new dashboard" reports. And, even if report is re-set to "old style", it does not default when viewing report again.And...have lost the "scroll bar" to move thru the report on new dashboard?------------------------------BuildPro------------------------------
Pipeline (1)Relationship: Jobs Table to Master Job Budget TableFrom "Jobs Table" [Job Number]Creates record in "Master Job Budget Table" [Job Number]reference proxyPipeline (2) to do the following?Relationship: Master Job Budget Table to Jobs Table"Master Job Budget Table" [Job Number]reference proxyto populate back to "Jobs Table"------------------------------BuildPro------------------------------
I have a Formula-Text field that has a Time field inserted into it. The field itself is set to display a 24-hour format, but when put into the formula via the ToText() function, I get the standard format. So the way I see it, I have two options:1. Write a subformula like Right("00" & Hour(), 2) & ":" & Right("00" & Minute(), 2)or 2. Use a function that's not listed to preserve the format. Is there one available, or should I just go with writing out the function?------------------------------Benjamin Golden------------------------------
This is more of an Excel rather than Quickbase question.I want to update a Multi-select Text Field for hundreds of Quickbase records from 8 .csv files The .csv files contain just two columns, Customer ID (key field) and Group, like the examples below.flooring.csvCust ID GroupA123 FlooringB123 FlooringC123 Flooringroofing.csvCust ID GroupA123 RoofingB123 RoofingC123 Roofingcarpeting.csvCust ID GroupA123 CarpetingB123 CarpetingC123 CarpetingIs there a way for Excel (or an Excel add-on) to Merge data from two or more .csv files so that I end up with the example below that I can then import into the Multi-s
I'm pretty new to Quickbase, and trying to figure out how to manage a simple approval flow. Requests will need to be routed to multiple users for review and approval (with possible additional input/questions prior to giving their approval). I'm in the early stages of working out exactly how this will all work, but was wondering if there's a way to set specific fields/columns so that they can only be edited by the user named in a different field. For example - if I select the names of Approver 1 and Approver 2 (depending on approval type, etc), and have two fields/columns called 'Approver 1 Approval' and 'Approver 2 Approval' (or similar), is there a way to have the 'Approver 1 Approval' column restricted so that the only person who can edit that field is the person named in the 'Approver 1' column?Also, if anyone can point me in the direction of a tutorial/guide that addresses a similar process, I'd be very grateful. So far I've had no luck finding what I'm looking for, desp
I am creating a changelog that multiple tables use. I would like it to report which field was changed, the old value and the new value. If multiple records were changed, multiple changelog records would be created – one for each field modified in the trigger step.Question: Is there a way to generate a list of modified fields then create an 'create record' loop that creates a changlog record for each modified field? Thank you!------------------------------Matt Makris------------------------------
I need to be able to see which resources were active at any given time. I have both a date hired and date termed, but I think I need a "query date" for something like this to work? For example, if 50 employees were active between Jan 1, 2020 - May 5, 2020, I need the report to show me those 50 employees. Is this possible?------------------------------Ariel Combs------------------------------
Can I use formula queries to find out the highest record ID in another table?------------------------------Raymond Sakar------------------------------
I know there is a app level setting for the currency symbol, but is it possible to change the symbol based on a country that is selected from a drop down?------------------------------Paul Peterson------------------------------
I'm trying to find trends in patient encounters by providers. For example if a service provider is seeing 15 people a day on average, but then his average has dropped to perhaps 10 a day, that is a significant piece of data. Since a provider may be sick or have the day off, an occasional lower number isn't significant. I have been following Adrian Lloyd along with Thomas Leverone's moving average piece Quickbase Analytics: Using Moving Averages to Identify Trends.Here is a sample of what we have generated for Encounters. The sites relate to the providers so I can drill-down to providers with a daily or weekly average. It seems to be a bit complex task, but I'm thinking that Adrian ( YouTube https://youtu.be/9ZFc9kKdUC4 ) and Thomas's articles are the way to go.Any suggestions welcome. I intend to delve into more the rest of the week. I am working with copy data, though it is current data, that has been imported by BOX and/or Pipelines. Quickbase remove preview Quickbase A
Okay, I have a question on QB tables with statistics and use of possibly moving averages. However I keep coming into the Community portal through my builder account, at least I think I am. After I post I will know for sure because I don't have an avatar on my builder account.I would rather have my post be on my work account as it goes to my regular email with replies that I see all the time and not another address that I just check occasionally.------------------------------Bob Thomas------------------------------
Hello,I currently have 2 fields: Screenshot Link 1 - File attachment fieldScreenshot 1 Preview - Rich Text formula field ("<img src=\"" & URLRoot() & "up/" & Dbid () & "/a/r" & [Record ID#] & "/e43/v0\" />")My issue occurs after someone updates the [Screenshot Link 1] field. When this happens, the [Screenshot 1 Preview] continues to show the original photo and not the updated one. Any ideas or recommendations are happily welcomed. I assume it has to do with the cache, but haven't a clue how to fix it.Thank you------------------------------Shane Miller------------------------------
I have run into this error a number of times. When I am trying to import an Excel file into QB, I receive this error.Object Reference Not Set to Instance of an ObjectI am referencing an Excel file that has been saved and in the correct file path that I provided to Quickbase.This problem seems to occur in files that I am importing that are small, so my solution to this has been to include irrelevant data in the Excel file and then leave the data out of the import.Any ideas why this would be happening and does anyone have a more elegant solution to solving this problem?
Hello,Does anyone use one of the pipeline channels to manage investor relations? We have an investor app built out, but we need some additional capabilities and wanted to see if anyone uses anything currently that connects well. Some of the additional capabilities are below: Investors are able to upload their documents (i.e. subscription docs, signed member agreements, etc.) Distribution payments are tracked and recorded. Distribution payments can be set up as direct deposit by investor There are many more, but just trying to find something that can be used in the pipelines if possible.------------------------------Ashley J.------------------------------
I have three tables across 2 Apps: App 1 - Table A (Customers) - Parent to Table B (App 1) App 1 - Table B (RelatedGroups) - Union Table - (between A & C) App 2 - Table C (Groups) - Parent to Table B (App 1) App 1 -Table A (Customers) is the Parent Table to Table B (RelatedGroups) – -Table B (RelatedGroups) are Groups that have been confirmed/validated (Related Groups) to have a relationship with Table A (customer). App 2 - Table C (Groups) – this table holds a list of Group records – *A Customer record may be related to multiple Groups AND a Group record may belong to multiple Customers (thus union table B). On a Customer record form, I have 2 views that display Groups. 1st View) Relationships (confirmed/validated) -between Table A (Customers) and Table B (RelatedGroups) - I considered the relationships in this view as "confirmed/validated". 2nd View) This view is based on a [Report Link Field] - displaying possible relationships - between Table A (App 1) and Tab
Quickbooks pipelines - Adding Project to Invoice
On a form in the app I am working on I have a cancel checkbox that when clicked displays a warning message and then provides a Cancel button. Currently I have that same Cancel button showing on a report on a homepage so a user can cancel a request direct from there but clicking the button from the homepage won't cause that warning message to come up. Any thoughts on a solution for this?------------------------------Chris Swirtz------------------------------
Hi everyone,Right now we use a 3rd party expense management platform which costs us money annually plus we have to manually enter some of that data into Quick Base. I would love to add an expense management app into our realm which would be easy to do. however, does anyone know of any way or add-ons to allow for importing of credit card transactions into quick base? For some users losing that functionality will cost them A LOT of time so it would be great to do it. Similar to how a banking program can authorize a card login and import your transactions.Thanks!------------------------------Ivan Weiss------------------------------
In the app I am currently working on there are several sections where a user may select yes or no from a drop-down and if yes is selected, another section appears with data entry fields to be filled out. My client would like it so that if a user were to go back and change a yes to a no, that it would not only hide that section again but also clear any data entered in those fields. I am fairly certain I can do this with form rules, however, I wondered this could also be achieved via Pipelines?Which do you think would be cleaner?------------------------------Chris Swirtz------------------------------
I have a report that allows each user to review their time entries and adjust them for the previous week. The report is filtered by owned records equaling the user who is logged in.I would like to automatically send out this report every Sunday to each user so they only see their personal time records for the past week.I cannot seem to grasp how this is done. If I send out this report to everyone, won't it simply send out admin time records since the admin is the owner of the subscription when the report is generated?The only way I can see to do this is a separate subscription for each user; I was hoping for a easier solution.And as always, I spend time reviewing the knowledge base for answers, but it is hard to know what key words will provide a solution, so if someone knows where this has already been addressed, let me know the link.Thanks,------------------------------Ray MossEssence QB AdminEssence Cabinets Inc.Edmonton, AB, CAN------------------------------
I have a formula checkbox and I want to write a formula that checks the box when the date/time in field X has passed. Can someone help me parse out this formula? Thanks in advance.------------------------------SLMPAC Development------------------------------
I have a need to set an alert/reminder/email (something) 30 minutes after the time a new record was created. Is that possible?Scenario:A record is created. If a checkbox isn't checked within 30 minutes of the time stamp, then I need some sort of alert.------------------------------Tony Miller------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.