Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Has anyone else noticed this problem with the new Pipelines Designer? I tried to enter an Advanced Query and everything looks fine, but as soon as you click off of the step, or refresh the page, anything I enter into the 'Advanced Query' filter disappears.If I turn off the Pipelines Designer and go to the Legacy Builder, I'm able to enter an advanced query and it remains.
I am trying to change the fields label in a table report using the Column headings option and it appears to be not saving and only visible until I refresh.Can anyone help?
I have two list-user fields - List1 and List2 I want to compare these two fields in a formula-checkbox field and have the result be true if ONE OR MORE user(s) from list1 appears in list2. Example 1: List1 - user1,user2 List2 - user2,user3,user4 Result would be true because user2 exists in both list1 and list2 Example 2: List1 - user1,user2 List2 - user1,user2,user3,user4 Result would be true because one or more (both) user1 and user2 exist in both lists Example 3: List1 - user1,user2 List2 - user3,user4,user5 Result would be false Any help? ------------------------------Drew Voge------------------------------
Hello, I am trying to figure this outHow to calculate a duration for each year based on a varying start date?The start date can be at any month of the year (just calculating months, not days) and the project will last over the next 5 years. Example: IF the Start date is September 2024, there's 4 full months for the first year. And if they're needed for ([Months Needed] is for 12 or 18 or 60 months, then how would I find the duration of the next year, and the next?Would each year need it's own duration field? Like Year 1 duration, Year 2 duration, etc?I'll have these fields[YEAR 1], [YEAR 2], [YEAR 3], [YEAR 4], [YEAR 5]. [Start Date][Months Needed]
Greetings,We are trying to create an application to store Training Records. Each Function is related to many Training Records. Each Person is related to many Training Records.People[Person Name] (also known as "Trainee" in English speak)Function[Function Name], [Revision Date]Training Record[Training Date], related [Function Name], related [Person Name] (from Person table)We are seeking to build a Report of all Training Records for which the latest Training Date (from Training Record Field for a given Trainee) is before the Revision Date from the related Function field. (If a Person was trained to the Function in 2019, again in 2020, again in 2022, and again on 4/2/2024; only the 4/2/2024 latest training date is examined per the Function Name). We don't want to display expired Training Records if there are newer (non-expired) Training Records to the same Function Name for the same Person Name.What fields/relationships/summary fields/etc. need to be s
Hello Everyone, I'm trying to create a single button that will allow our users to add an effective end date to a record on form ID 11 and then when that is saved redirect to the add record api using form ID 10 populated with data from the previous record. Since I haven't been able to get it to work in a single button I created 2 buttons. Indivually both buttons work but combining them isn't. Any ideas?Step 1 code: URLRoot() & "db/" & Dbid() & "?a=er&rid=" & [Record ID#] &"&dfid=11" & "&rdr="Step 2 code:URLRoot() & "db/" & Dbid() & "?act=API_GenAddRecordForm&dfid=10" & "&_fid_6=" & [Paragraph] & "&_fid_7=" & [Publication] & "&_fid_8=" & [Description] & "&_fid_11=" & URLEncode([Staff Contact]) & "&_fid_17=" & [Effective End Date] & "&_fid_19=" & [Record ID#]When I combine the code I'm using thisU
Hello,I haven't been able to find any instructions anywhere on how to setup a Pipeline to push JSON data to an external API endpoint.Ideally, I want to send JSON data to an external API endpoint when a record is created, or modified via pipelines. I was able to set this up with a Webhook, but Pipelines doesn't seem as obvious.Thanks, James
I am using legacy forms to try and accomplish this. I have these tables in use: Expense, Dates of Service, Invoices and Links to invoices. Expenses is the parent to Dates of service, Dates of service is the parent to links , and Invoices in the parent to Links. 1 Expense has many Dates of Service1 Date of Service has many related Invoices1 Invoice can have many linked DOS's (which need to connect to the related expense)What I want to do is streamline my process and try to add the date of service AND then link that DOS to an invoice, all while staying on the Expense's table and at one time. Currently, after creating the expense and date of service, I then have to go to the DOS table in order to create a link between the dos and invoice. My process goes like this:I receive and enter a new expense in the expense table. Since each new expense has many different Dates of Service (DOS's) I have the DOS table. On my expense form I have a
Good morning,I've created a pipeline to create a Jira story when an issue record is created in QuickBase. Most of it is working, but I can't seem to get the Assignee and the Reporter fields to work. I'm thinking it is because they are user fields?Is there something I need to do to convert the QuickBase data to what Jira needs in these user fields? I've tried using each of the options (email, first/last name, screen name) but it just appears as blank in the Jira ticket. Thank you!
I have an approval box that I want to log when and who approved or rejected. When they reject, an email should send and another box should come up to the right of the notes box. I assume because of the log, it is causing my rule to fail? Dynamic rule
I'm hearing that you can embed reports on the new forms. I know how on the old forms, but am puzzled how on the new forms? My three uploaded snapshots, two show a Warranty Table form, the old form, and then customize report option to embed a report in a report link field. The third snapshot shows the new form with the same report link field, but I'm not sure how to embed the 'Embedded for Warranty' report on the new form?------------------------------Bob T.------------------------------
I need to understand how to re-establish relationships on existing tables that I have migrated into Quickbase. I know am absolutely missing something that is probably pretty obvious. Its an MSAccess database, so its SQL compliant.I have a table with important information in a field that I want to preserve. This is the field in the child table--lets call the field BigInfoValue (a numeric field) and the table ChildTable. I have a tiny table with other information in it that defines what the values in BigInfoValue mean. Lets call this BigInfoParent table, and lets call the fields BigInfoValue (a numeric field I want to relate the tables on which I've also designated the key field), BigInfoTerm, and BigInfoDefinition. I absolutely cannot figure out how to make the two tables link on BigInfoValue. When I try to create a table relationship, with BigInfoParent, Quickbase does not offer me BigInfoValue in the child table as a linking field. It creates a brand-new field called Re
Is there any way to prepare an excel document so that when I import it onto my QuickBase App, those selections automate so I don't have to go into every individual specific report and update those drop downs manually?
We need to convert Excel once it is uploaded in form into PDF, so that we can view the document without having option of editing. Please suggest if anyone had its solution.
Good Morning,I am new to QuickBase and would like to have a report that has a Starting Date and Ending Date that the user would be prompted to enter.Could someone advise on how to accomplish this?Thank you,Bob
In case others haven't realized, the %%rid%% has stopped working on mobile. If you attempt to use a button on mobile in add mode that is utilizing this feature, the URL button will not function at all, and will not even attempt to execute your URL.Customer support as recognized this and states they are working on it. However, they have not told me any more information (such as if they have prioritized it, or is in their bucket of working on but will never actually fix). This has been broken for about 4 days so I do not think it is a priority for them.Just want to be sure everyone else knows as well. It's dissapointing, I use this feature in probably 20 or 30 buttons so now I will need to take probably an entire day to find them all and come up with a work around.I do have one work around that uses a helper table and an action to always find the max record ID. If anyone is interested they can let me know. Though with actions going away, even that will now become difficult. Sadly, Quickb
Good morning. Does anyone know how long a user is logged in before Quickbase automatically logs you out?Thanks! Allison
I have three tables Templates, Template_Events & Template_SubEvents. Templates has a relationship with Template_Events, Template_Events has a relationship with Template_SubEvents, and Template_SubEvents has two self-identifying relationships (this allows for different Template_SubEvents to be selected in two places on the form). What I'm needing to do is prevent a circular dependency in the Template_SubEvents table. What I've come up with is using a Text field (Hierarchy List) to store the Child record(s) ID and the Child records of its Parent.For example:If I have Record IDs of 1, 2, 3 & 4. 2 is a Child of 1. 3 is a Child 1. 1 is a Child of 4. In the Hierarchy List for ID# 4 would be "1,2,3". In the Hierarchy List for ID# 1 would be "2,3". So ID# 4 wouldn't be able to be the Child of the records 1, 2 or 3. A formula field would compare the contents of Hierarchy List field to the selection made in the Parent_SubEvent ID field and then a Dynamic Form Rule would display a message
Where can I update where someone is directed to after a record is saved? Here’s my scenario. I have a table called Recipes. I have another table called Comments. They are connected in the app with a table to table relationship where Recipes is the Parent Table. In the form for the recipes, I have a button to “Add Comment”. If a user goes to a recipe record, then clicks the button to add comment. Then they fill out the Comment form and save, they get this: How do I update settings someone to tell QB to redirect them back to the home page?
I have an add record form for a barcoding application.I have one receipt to many objects.Users would enter a receipt then add object records to take a picture of each object and assign a barcode.The button works great in desk top but the record id from the parent doesn't go to the child in the mobile app. any ideas here?code for the button: var text STYLE ="background: green;" & //button color"color: white;" & //text color"text-align: center;" & //text alignment"text-decoration: none;" & //none, underline, line-through"font: 18px Calibri, sans-serif;" & //text size, font, & style"border: 3px solid #505050;" & //border width, style, & color"border-radius: 5px;" & //roundness of button corners"width:100px;"& //button width"padding: 5px 50px;"; //space between text & buttonvar text RID = If(IsNull([Record ID#]),"%%rid%%",ToText([Record ID#]));var text URL = URLRoot() & "db/" & [_DBID_OBJECT_PICS]&"?a=API_GenAddRecordForm"
I created a check box field and it's currently used in 7 forms/reports. When I copied it to add in another area of the same form it shows as only being used in 2 forms/reports. How can I add it to the additional areas I need it in? I want the copies to function the same as the original. I attached screen shots of the original and the copy. Thank you!!
I need some help thinking through this architecture. My table 'Asset form' collects data related to company assets. My other table, 'Asset Approvals' will collect approvals for these asset changes. Now the data for these assets ('Asset form') is going to be collected via GRID EDIT mode; so a bunch of Assets will be clubbed together and will require only one approval. I have created a formula field 'Change Req ID' that is a concatenation of person creating the request and date and time. So ideally I want to create a one to many relationship between the 'Asset Approvals' table and the 'Asset form' table but link them using the 'Change Req ID.' So from the 'Asset Approvals' form I would like a drop down of all 'Change Req IDs' (which would comprise of many Asset form records), choose one and upload my approval attachment. This should then show up on all Asset forms as an attachment that has that 'Change Req. ID'. What's the best way to achieve this? Thanks deepa --------------------------
Hi all!I'm just looking for some beginner/intermediate wisdom. I am taking on the (to me, much coveted) task of managing and revamping Quickbase across other arms in my division. This'll be the true test of whether I'm actually cut out for this haha - it's one thing to be self-taught and know how to build and fix across the empire that I've built, but another to jump into someone else's empire.So. Looking for some wisdom:What things should I know when going in and offering up a "revamp" of sorts?What major pitfalls should I watch out for?How might one approach doing this sort of thing? My first approach has been to learn about what sorts of things they use Quickbase for today, what data is captured, what they'd like to use it for down the line, and then with that, I'm peeking in the back end, seeing what fields/forms/reports exist, and wrapping my head around how it all is (or isn't) working together todayA sub-set of questions - might it behoove us to build several
Simple user here. Not an expert or well versed in Quickbase, but it's what my office has used in the past so I inherited it. I recently updated the language in an email notification (triggered by a checkbox). The email sends, but is still using the old language, even though when I go check the notification itself in settings, it shows the new language. I have no idea why it won't send the updated custom message. any help is greatly appreciated.
Does anyone use Firefox? I used to use it exclusively, but after some update (not sure if it was a firefox update or QB update), I have seen a lot of issues.Many GUI issues where the options (grid edit, customize report, etc) simply do not show up on new reports. Also, some reallllllyyy slow loading times.Nothing is consistent (I can't force the issue), but it is consistently weird.I have since switched to Chrome and have had no issues. I am just wondering if others have seen this, and if anyone has pinpointed the issues and figured out how to recreate.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.