Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
If I have a form that I am having a user fill out, what is the best way to copy that data (or specific fields) from that form to a new table?The form is for an approval and could be an "update" or a "new process" that needs to be approved. I'd like to copy all the requested updates to one table and the new requests to a separate table. Ideally, I'd like to send updates over from the main form as well (pending to approved/rejected, date modified, etc). I believe I could use a pipeline. Is that my best bet? and if so, is anyone aware of any decent posts that would provide a little guidance?
Hey all,As the title says, I'm trying to replicate the format of what is returned from a pipeline search in text fields inside Base. Here's the scenario:I'm making invoices in QBO via a pipeline, but all of the information for the line items is on the same record as the header spread out over different fields. QBO requires I pass lines as a list, which is normally done via searching through the line items, but that's not possible in this case. I have anywhere from 5-10 fields on the invoice in Base that need to each become a different line item in QBO, so how do I make fields to mimic that list output to pass over?
I want to "lock" the data in a section of a form, but have the ability for one role to override the lock. If the Manufacturing Start date/time field is empty, I would allow editing: OR if the QA Manufacturing Start Comments field is not empty, I would allow editing in the sectionI have in the expression builder:IsNull([Manufacturing Start]) OR Not ISNull([QA Manufacturing Start Comments])Then:Make editable: SectionBut I am getting an error on the "OR". It says that there are extra characters beyond the end of the formula.What do I need to do to fix the formula?Thanks!Becky
There is an embedded report on the form. After clicking on the CheckBox, the form focus is jumping to the embedded report.
I am not able to use any of the build in fields in my pipeline. They are available in the widget but not available as fields that I can update. Thanks
I have a few field names that I need to change and know the changes will update in most parts of Quickbase. But, I also know that things like field names in relationships will not update. Will changing a field name have any adverse impact on a pipeline?------------------------------Paul Peterson------------------------------
I am trying to create a new process for tracking manual revisions in our training curricula that we've built into our project manager app.Each change may affect multiple curricula, and multiple lessons within it. I would like to be able to add a change, select the curricula it applies to from a dropdown, and then have another dropdown of lessons from the curricula. I have the relationships set up the way I want it now, but I can only select one curricula and one lesson to relate to each change record.I've seen the many to many option of having a table in the middle, but I'm struggling to figure out how to apply that to my scenario. I remember an Empower session that related multiple work equipment to one work order using a multi select and a Pipeline to relate that to an Equipment table but I can't remember how it was done in the end. I'd love any ideas!
On any given table, when searching for records by separating values with " OR ", I'm hitting a limit of 50 results. I cannot find anything in personal settings or admin settings that addresses this limitation. I also don't see any discussions or references to this in documentation. My org does have a developer that seems to not have the limitation, but neither of us is able to identify any applicable role permissions or settings that could be causing the issue. Has anyone experienced this?
I want to split up our expenses into different categories and have fields on the PROJECT page that shows the updated amount(s) when a new expense is created.Example of categories:FUEL - $100.00LODGING - $100.00These amounts would update to a field with the same category names on the PROJECT page.Then if another $50.00 of FUEL was recorded, I would want to add that to already existing $100.What would be the best way to do this?Thanks!
Okay so I have a parent table, call it Daily Reports. I have another table called Purchase Orders.Users populate purchase orders as they go.I've built a bullpen type report within Daily Reports to show all purchase orders that aren't linked to a daily report. I want a button on the purchase order level to say "Link to Current Daily Report Record". That would run an API Edit and update the related Daily Report to the record I'm currently on.I cannot figure this out, or if its possible, to reference the current record a user is on IF the button is in a child table that's not currently linked.
I want to do a couple of things:I want to auto number our projects - is there a way to do so?I also want to create a field for a project name that is a combination of 4 other fields and autofills in - how can I do this?Thanks!
Hi QB community,Has anybody created a Page using the Pages option? I am trying to create a page using a code but for some reason it is not working. I am referencing the field ID but my page does not link to the code for the link ID. I just copied a little bit of the code below to see if someone can help. I tried ~45~, ~[45], '_FID_45', ~Contact~ and neither have work. Any thoughts?<p class=MsoNormal Style='line-height:normal'><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>'_FID_18'<br>~[45]<br>~Broker/Source/Vendor~</Span></p>
I am trying to investigate if there is a way to use a pipeline to remove file attachments? I am automating a process to incorporate data into our system using CSV uploads. The issue is that I would like to keep some of the information from the upload available (e.g. the Requestor, Date Uploaded, File Name) but I don't want to actually archive the file on QuickBase due to space limitations. Is there a way to just delete the file itself without deleting the entire record? You can of course click into the file and manually delete it (see below), but I want this to be automated as I won't be doing the uploads myself. The field type is "file attachment" and it appears to be stored as a URL/Link. It does not behave like other fields in the pipeline and I have not found a way to override it yet. Thanks! ------------------------------Kevin Gardner------------------------------
I have been using QB for nearly 20 years. It's a great product, so much better than salesforce. However, I am finally beginning to understand why it's not doing as well as SF. Their atrocious communication. NOT customer support, which is awesome. But their basic communications.I submitted two session proposals for Empower and apparently at least one of them got accepted, no idea which one. The email said to reply to empower@quickbase.com to confirm but I've emailed them 3 times now and it's bounced back. Emailed pr@quickbase.com as well and that bounced back even though that's the flipping email on their website! Called up the contact number and you can't even talk to sales which is ostensibly what that phone number is for. The options are employee HR (why on earth is that a choice for their public number?) or sales. When you select sales, it goes straight to a voicemail. How many pote
I have a Rich Text Formula field, in which I am creating buttons. Then I am selecting the Reports in the Dashboard Widget.Is there a way to make the anchor tag 100% width of the div? See Attached ImageOr is there a better HTML tag to use to accomplish this? "<a style=\"width: 100% !important; height: 100%; display: block; text-align: center !important; background-image: linear-gradient(180deg, #AEE88D, #AEE88D); border: 0; border-radius: 0px; color: #000; cursor: pointer; font-family: Tahoma; font-size: 100%; padding: 3px 7px;user-select: none; -webkit-user-select: none; touch-action: manipulation; \" href='" & ToText([URL]) & "' target=_blank>" & [Description] & "</a>"------------------------------Erica Norris------------------------------
I have need for several fields to be populated with a multiple choice options that are editable after being selected. The multiple choice text options are full paragraphs with lots of standard language, but just a few variables that will need to be added by the user after making the selection. I can't figure out the best way to accomplish this.
My app has a number of dynamic fields that show based on a location field.Everything is working properly. Except, when I just click the eyeball to view the record, I only see the fields that are mandatory on the default report. I know I can open it to see it all, but is there a way to get these additional fields to show? Ideally only fields that are either populated OR the dynamic fields from the actual form that show based on that location. I do see the location as being set on the default report. Can this be done with a report at all? If not the default can I create a new report that will allow me to show these fields and link to it from another report? I have a report on the front page for all new entries and another for new entries that week.
I have these tables:TrailerTrailer InventoryItemItem Usage Currently my structure is set up like this:Each Trailer has many Trailer Inventory recordsEach Trailer Inventory has many Item Usage recordsEach item has many Item Usage recordsEach Item has many Trailer Inventory records This is what I am trying to do:Enter in an item usage record and subtract from Trailer Inventory.When the item usage record is entered, I know the Trailer ID & The Item ID.I need these two IDs to match to a record in the Trailer Inventory table and subtract the quantity used from the Starting Quantity in that line.Example: In Trailer Inventory, I know that my starting quantity for Item #1 on Trailer #1 is 10. I then go enter in an item usage record and I enter that I am using Item #1 on Trailer #1, and I'm using 5 of them. I want that to go match up to the Trailer Inventory record using those two IDs, and subtract the 5 used from the original 10 that we started with.I have a summary field on the
In our application we use QuickBase APIs to pull in the data from rich text fields and insert them into a database. However, we would like to limit the html tags that the user can use to make storage into the database easier. For example, is there any way to whitelist out images so that the user cannot select and try to enter images. We can add a text note on the form "Do not add images" and then filter it out in the PHP code that we use for the APIs and DB writes. However, its much cleaner to simply have some way of whitelisting out the images tab (either remove it from the options or gray it out). Thank you
I am trying to build a connected table between Quick Base and Quickbooks Online and I specifically want to sync my credit card transactions. I see that I can sync bills, but I can not find a way to sync other expenses, like credit card line items or checks.Am I missing something simple? Any insight or ideas would be greatly appreciated!Thank you!
In Referral (key Record ID), there is a field called Referring Contact - which is a key for the table Contact.In Activity (key Record ID), there is a field called Activity Contact - which is a key for the table Contact as well. It also has a field called Team Member ID - which is a key for the table Team Member.The users want to know, for every Referring Contact in table Referral, the name of the Team Member who had an activity most recently with that Referring Contact.The Activity table contains this information but I cannot figure out how to get it into the Referral table to report - I think the two tables should be related, then there should be a formula field that brings the (newest) Activity record, with its associated Team Member, into the Activity Record. But how to relate the two tables, since the "matching" Contact fields are not the key of either table?
I have a child table (Tasks) that displays within my parent table (FWA Investigations) and I can't figure out why sometimes the review completed box will show as checked and sometimes it won't. I included an example in the attachment.
I have two tables, both of which contain parts inventory information. One table is called "Inventory" and is my master table for parts info. I have another one that each night is pulling parts info from another software via Webhook (this part is working just fine) and creating entries for parts inventory in a table called "Temp Inventory".My question is if there is a way to take each entry from the Temp Inventory table, compare with all entries of the Inventory table (using the part # as the comparison), and if no match to the part # is found, create a new record with that Temp Inventory info. If a match is found, then no action is required. After this comparison is completed, the Temp Inventory records are deleted until the next day when the process is redone.Any help would be greatly appreciated!
Hello,I have an app used for credentialing information for physicians. I'm using a form as a data card visualization to provide leadership with a quick overview of each physician's profile and credentialing details. There is a section at the top of the screen with arrows for navigating to previous and next records, but they are currently unclickable. It would be incredibly helpful if leadership could simply click through to the next physician instead of having to navigate out and select a new person each time. Is this functionality possible to implement?Thank you!Meag
I have a dashboard that tracks user reads (app, user, action), we pull three tables from the realm apps, usage, and user reads. We use this to track who is using the app, when, and what they did. This is currently tracking every app we have in our quickbase instance. Since the 2024 October update the actions have significantly decreased. Is quickbase no longer tracking modification actions as actions? We used to be able to see if someone went into a report (1 user read) and then edited a record (1 user read) so the action report_access would have 2 user reads associated with one account. Now it seems like it is only 1 user read. If this is the case, is there a way to track these actions?I found this link: https://helpv2.quickbase.com/hc/en-us/articles/4570366542484-Technical-summary-of-User-and-Integration-Reads But I am just not sure if I am understanding this correctly. If I am, I need to find an alternate solution. It is important we are able to, accurately, see how o
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.