Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi Everyone,Is there a way to create a chart, that pulls in data from multiple table? I'm trying to create a Pie chart showing a count of On Time / Late proposals. This information is stored on four different tables.Any help would be appreciated.------------------------------Terri Wells------------------------------
I have multiple fields in a form that reference another field in a different table. I want to eliminate a selection after it has been selected in a previous field. Example: Field 1 : Apple. Count:5 Field 2 : Orange. Count: 10 Field 3 : Count: So field 3 i don't want Apple or Orange to be a selection option. Can i do this with form rules?------------------------------Cameron Arave------------------------------
Hi, We have a form with a basic parent-child relationship for users to add children records. Sometimes, the users need to add up to 100 records. It becomes very tedious to do this 1 at a time. Does anyone know of a simple way to solve for this that allows users to upload bulk records? I have a fiew ideas, but none of them seem very user friendly and I want this to be something relatively intuitive for end-users who aren't in Quickbase all the time. Thanks in advance for any ideas!------------------------------Curtis Middleton------------------------------
On all table home pages, on the top right there is an import/export button. Is there a way to hide that for users? Seems like a liability that they can import data to tables....------------------------------Mike Tamoush------------------------------
I want to compare the time value currently we have in our data with the current time value and I'm using Now() function for this but due to seconds difference it is not able to compare. For example: if we have the date time value as 12/21/23 3:30PM and I want to check if current time is equal to 12/21/23 3:30PM (Now()= 12/21/23 3:30PM) then return true else false but due to seconds value it is giving incorrect result/false. Any suggestions to solve this? Regards, Hunny------------------------------Hunny Vinod Kumar------------------------------
Table 1 (Request): has unique records designated by a report name. Table 2 (Open Items): has open items or tasks that are relevant to Request items Relationship was built to where the request is the parent and could have several open items or tasks associated. How can i get report on parent to show only relevant open items associated with a specific report. The relationship built allows us to associate the report name, however the report is pulling all open items records and not just the ones associated with a specific record from parent table. ------------------------------Edward Torralba------------------------------
I am redoing our forms thus, I am moving over to the new forms. I have a pop-up message on my legacy form that utilizes some HTML. It's a safeguard to stop our end-users from just clicking okay without reading the message (which they were doing originally when it was just plain text). With the new forms, I tried doing the same in my new Form Rule but it just shows it as plain text. Is there a way to achieve this with the new forms? Or is this no longer a feature?Example of what we want:<Center><img height = 100px src="image_link"><p style="color:red; font-size:25px;">SKIPPED Steps</p><p>Please review the <span style="color:red;">Skipped Step</span><strong>BEFORE</strong> starting the Payroll Process.</p> ------------------------------Kaitlyn Stanley------------------------------
Hi, I was asked to find information about Quickbase as a CRM, and I need some specific functionalities. I wanted to seek assistance here. In my opinion, Quickbase is primarily designed for data management, visualization, and project management. Regarding its CRM capabilities, the functionalities I was looking for include: Email marketing with customizable emails (I'm aware that this is possible). Integration with Aircall. Allowing leads to schedule their own calls through a calendar report (I'm not sure if this is feasible). Call recording and tracking points of contact. Sending customized surveys. Lead management. I'm hopeful that you can help me with this information. Thanks! ------------------------------Francisco Ojeda------------------------------
I'm creating a record (B) when another record (A) is updated. But not every time (A) is updated, just when field Transform (a checkbox) changes from unchecked to checked. I need a filter for this. How can I express "checked" ? Should the pipeline say Transform is True, Yes, or 1? (there's no drop down for "checked") And do I also need to add to the filter that Transform is Set? I don't want the pipeline to run every time it sees the Transform checkbox is checked after the record is updated in any way, but rather to run only when the current modification includes the Transform checkbox changing from unchecked to checked. ------------------------------Charlotte Morin------------------------------
Hey Qrew, I have a question that feels like it would be really easy but the lack of documentation around formula URLs is complicating it. I want a button in a form in table A, that takes me to a custom report (report 11) in table B, only showing records where FID 83 in table B is equal to [Related Deal ID] in table A. I have this formula URL: URLRoot() & "db/" & [_DBID_PROPERTY_METRICS] & "?a=q&qid=11 Which takes me to the right report, but no filter on it. I edited it with this information: URLRoot() & "db/" & [_DBID_PROPERTY_METRICS] & "?a=q&qid=11&_fid_83=" & [Related Deal ID] But it just gets me to the same report, no filter. I'm not sure how to feed the following query into the URL either: "{83.EX.'" & [Related Deal ID] & "'}" All the prior discussions seem to circle back to "use a report link", but, while the report link does lead to the right table, with the right filtering, I can't figure out how to get the right report disp
Good afternoon, I am trying to create a button that will save a record then put me back into edit mode then copy information from one field into another. I have done research on this and found two separate solutions. I have the rich text formula for the save and conintue button below: var text RID = If([Mission ID#]>0, ToText([Mission ID#]), "%%rid%%"); var text URL = URLRoot() & "db/" & Dbid() & "?a=er"& "&rid="& $RID; "<a class='SaveBeforeNavigating' data-replaceRid=true style=\"text-decoration:none; background: #117a39; border-radius: 5px; color: #FFFFFF; display: inline-block; padding: 4px 4px 4px 4px; width:140px; text-align: center; text-shadow: none; border: 2px solid #0863f5; font-size: 12px \"href='"& $URL& "'>Save and Continue</a>" Then on my own I created the formula url button below: var text LINKMISSION = URLRoot() & "db/" & Dbid() & "?act=API_EditRecord&rid=" & [Mission ID#] & "&_fid_153=
Is there any way to tell if a role is part of any dynamic form rules, or if it is used in any formula text fields? I am thinking I might be able to use the search schema to look through formula text fields, but is there any way to know where you have used a role for dynamic form rules?------------------------------Michael Tamoush------------------------------
I have a file field that I must keep secure (I cannot open to public). A teaming partner has a limited access role, so that they can be logged into our realm in order to access the files. The problem I am having is this: In other scenarios, if you click on a QB link and are not already logged into the realm, it takes you to the realm login page. However, if you click on a file, it just gives you a 404 Error page. To the user, there is no indication that the real issue is that they need to log into the realm. Any thoughts on how to combat this? My instinct is to make a formula rich text field that doesnt take you to the file, but actually takes you to a custom form with only the file field on it. This way they should be sent to the login screen. I don't love that idea though, anyone have any better thoughts where they can still click on the file itself, and if they are already logged in it opens the file, otherwise it asks them to log in?------------------------------Michael Tamoush----
I have a pipeline snippet below that functions as require, however, I have two issue that I cannot get past. The duration code below stems from an actual duration field between two dates plus days(1) to capture first and last day. The snippet is part of a larger Outlook channel HTML email /// SNIPPET /// {# Duration between 2 dates #}{% if a.duration>0 %}Duration: {{a.duration}} Day(s){% else %}{% endif %} /// RESULTS /// Duration: 86400000 Day(s) /// Issue #1 /// No matter what I try, I cannot deduce the milliseconds to actual days. Dividing my duration by 86400000 should give me 1 Day, I simply cannot get the jinja code correctly update to achieve this result. /// Issue #2 /// The snippet provides a line feed or break regardless if the statement is true or false. ------------------------------Thank you so much,v/r,Chuck------------------------------
Is it possible to create a unique identifier? For example, there is a field in the parent table called "Position Number" and a reference field in the child table. When someone adds a new record for that particular position number in the child table, which is a vacancy tracker, I want to create a unique identifier using a combination of the Position Number from the parent table (which is also a key field), +current year, and the number of records attached to that identifier in the child table on QuickBase. If the Position Number is 12345, the unique identifier should be 12345-2023-01 for the first related record, 12345-2024-02 for the second related record, and so on.------------------------------Chaitali Damani------------------------------
So I have two fields: the first is a projected 'delivery date' and the second is a 'how many days until delivery" (essentially, its a countdown). On the Days-Until-Delivery field I have the following formula:ToDays([Projected Launch Date] - Today())And it works great. Problem is, after it reaches the due-date, it starts to show a negative value. I would like it to simply 'zero' out once the due-date is achieved (I already have it set-up to show any records that are past the due-date to be highlighted in red). Any suggestions on how to code this out?Thanks in advance for your help.
If I have a database where my tables are events and audits and I want to be able to have many events and many audits that can be related both ways, I know that there is an intermediary table required, which i have set up. How do I bring the existing data into the intermediary table without creating a new record. The goal is to list certain events that are related to the audit on the audit form. Any help is appreciated very much.------------------------------Tonya Jacques------------------------------
Hello, I'm hoping someone smarter than me can help! I am using Dynamic Form Rules to adjust the fields that show on a form. Here's a simplified example of what I am trying to do but can't figure out how to set up without triggering the Form Rules warning about 'show/hide rules' on the same field; If the field Part is set as "Tire", hide the field Interior If the field Part is set as "Wheel", hide the fields Interior and Consumable If the field Part is set as "Reflector", hide the fields Interior, Consumable, and Replaceable If the field Part is set as "Paint", hide the fields Interior, Consumable, Replaceable, and Size Thanks in advance for your counsel!------------------------------Eric Rovner------------------------------
We have built a custom Save/Create button that will SaveBeforeNavigating and direct the EU to a GenAddRecordForm. It works PERFECTLY in the standard native form this button lives on. If we try to access the same form with ifv=1, ifv=0, ifv=10, etc., it tells us to Save the Login first. We don't want the EU to access the native Save & Close button. Does anyone know why it will work in the native form, but not the ifv version?------------------------------Danielle Wilczewski------------------------------
Hello Quickbase Community.Is there a way to get a Quickbase mobile form scroll automatically to a specific place after having reloaded the page?We have a very long form, which will be used from Android phones, the form contains questions which will be answered with two different buttons each, as the user answers the questions they will have to keep scrolling down and answering.I need a way to make Quickbase scroll down to wherever the user was before pressing one of the buttons, so that he doesn't have to manually scroll after each answer.I tried using fragment identifier, by adding for example "#tdf_362" at the end of the redirect URL (see 2nd screenshot), which worked nicely for the desktop view, but didn't work for the mobile view.The buttons update a checkbox field in the background and then reload the page on edit mode, here's the code of one of those buttons.URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &"&rid=" & [Record ID#] &"&apptoken=xxxxxx
I am embedding reports into some exact forms and it is recommended to accomplish this by creating report fields (like the ones that are auto-generated when you create a parent-child relationship between two tables). The reports are flagged as "Temporary Reports" by the system and display different settings pages from a normal "persistent" report. Attempting to save a custom report generates a new "persistent" report and therefor is not referenced by the report field. so, two approaches to answering this question: 1. how do i customize the default fields that are displayed in the temporary reports generated by Report Link fields? Can this be done with URL encoding? by declaring fid="[desired field]" in the corresponding order of columns i desire seeing in the report? 2. is it possible to embed a SPECIFIC "persistent report" i have already created through the report link field? rather than using the matching and target field interface in the settings page? as usual, d
I have created a pipeline realm using a system user (yes, I am a realm manager and can "switch users" in Pipelines). However, when I create a pipeline in this realm and have the pipeline update a mult-text field with log edits checked, some how the log edit feature still knows that it is me not the system user. Any fix for this?------------------------------George Bramhall------------------------------
Table A · field - Task (text) · field - Job Number (text) · field – Active (checkbox) · and a field called Task_Job Number which is the Key Table B · field called Job Number (a lookup field from another table) Table C · child table of A and B · lookup field from Table B to get the Job Number · lookup field from Table A to get the Job Number · has a conditional dropdown field o show Tasks (from table A) that matches the Job Number from Table B the conditional dropdown works fine, it only shows tasks that are for the specific job number, howe
Hi all, I have a field that is a checkbox that indicates whether the item is Active vs Inactive. Active = checked Inactive = unchecked I would like a bar chart that looks something like the image below, but am having trouble getting it to work. The checkbox is called Active? Any help you can give is great! ------------------------------Angela Rackley------------------------------
A user contact me about the the possibility of adding "Save & New" functionality alongside the rest of the options shown in the Save menu. Navigating to Form Settings shows a hint of being able to select options under "Available save options". Sadly, no options are presented. Am I missing something here? Thanks. ------------------------------Michael Rose------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.