Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello I want to start working on app for tracking mdt appointments. the appointments can have 5 possible departments in the meeting. I wanted to see if it was possible to set up pipelines to send and if selected department is marked can it send an email of the record where it has the details of the appointment. If the department is not marked the email wont be sent to them. Or would it be best to just have a table with the emails have a relationship with the appointment table and then Have a pipeline send an email to all representatives added to a record? Or would I have to create notifications for each department so it be sent to their emails. What would be the best way to go about it? Thank you in advance for your time and help.
Hi! My title is incorrect above and I can't seem to edit it-whoops! I am trying to set up a formula field that finds the difference between two fields in two separate entries (for the same customer) and for the two most recent entries only. For example, Entry A field X from 01/01/2022 is 98.72; Y is 50. Entry B field X from 09/06/2023 is 200. This formula field would calculate the difference (always a positive value) between B and A (X-Y) and record 150 in field Y in Entry B. Then, Entry C field X added on 10/24/2024 is 700; the difference between Entry C X field and Entry B (most recent) Y field is recorded in field Y in Entry C...and so on always focusing on the two most recent entries by Read Date. I have attached a screenshot of how I would like it to function; I have manually entered the data in this example. Is this possible? Or something similar? Thank You! ------------------------------Jill Jackson------------------------------
My connected table has been erroring out on the hourly table refreshes due to the following error: The error was: Trying to add a non-unique value to a field marked unique - Your import data has duplicate values for the following unique fields Field name: "I was able to verify that the field in question does not have any duplicate values in both the source and destination table. In addition, the destination table already has the records in question within the table, so if anything, the records should be updated but there shouldn't be an error on the refresh. Has anyone else dealt with a similar issue? Not certain of what next steps to try aside from reaching out to QB Support.------------------------------Niraj Shah------------------------------
Hello,I have a user reporting issues with saving a record. This appears to be sporadic, but has occurred more than once. This is saving from an 'old' form. She receives a message similar to:Red notice: “ unable to contact Quickbase to avoid losing work. Please leave this window open and try again in a few minutes.”Does anyone know what scenarios would result in the above error? I tried reproducing by disconnecting WiFi; however, I received a different error.Thank you!
I have tabs set up in my parent table that when a user enters in the main record they can go to the subsequent tabs and enter in placements records in one tab, and updates in the following tab. The placements, and updates are connected to child tables. The issue I'm having is the embedded report that displays in each tab is showing no records at all, even when records were entered for the parent record, or it's showing all of the records entered that aren't even related to the parent record.The first screen shot shows the tab and it's displaying records related to the main tab, and the second screen shot shows where no records are displaying for the main related tab. Same for the last Updates tab, no related records are displaying and it's blank.
Hi there,New to Quickbase, but have a big MS Excel background. What I used to find easy in Excel, I can't seem to get my head around in QB. If anyone can help enlighten my rookie brain, it would be greatly appreciated.I'm trying to colour-code a date type field based on multiple conditions:Say for example I have field called 'Survey Required By', which is the date for when we want a survey to be completed, and then another field called 'Survey Completed', and in this field we enter the date when the survey is completed.I want to highlight the field text or background in red if the 'Survey Required By' date is today or older, and the 'Survey Completed' field is blank.I've googled and tired many different formulas, but the best I've managed is to color code a whole row on a report, which I don't want to do. I just want the 1 field color changed.The formula I have so far is:if( isnull([Survey Completed]) and [survey required by]=today(), "red","" )
Strangest thing! On the dashboard I have a Summary Report for Revenue for the Year. I can click the Month (the Columns) and I can pull up the drilldown report for that specific month. However; if I click the Retailer (the Rows), or the $ amount in the month the drilldown report states "no records found". I can go into the Revenue folder and access the report there and everything functions as it should.Any clues???
Hi allI'm trying to calculate a total cost per unit shipped of both Overhead Expenses and Operating Expenses so that I can benchmark a KPI for my services. I am having trouble summarizing totals from another table.Operating Expenses are easy - we track based on jobs and log expenses. This can include gas, contractors, extra rentals, food expenses, etcOverhead Expenses - I am struggling with because my per unit Overhead expense should get lower and lower the more units I ship, but will also go up the more days into the Fiscal Year I am in. This requires me to solve for how many days into the Fiscal Year have passed (no issue), and also to summarize how many units I have shipped this fiscal from another table (my problem)How do I put into a formula, a request to summarize the total from a different table using a parameter? ex: var number totalUnitsShippedThisYear = <look in table unit shipped and get total # of units shipped who's ship date = this fiscal year>
I created a code page that displays a graph. It is embedded in a form but it only works new form style and not the old/legacy form styleFormula url: URLRoot() & "db/"& AppID() &"?a=dbpage&pagename=graph_only_run_chart.html" & "&related_chart=" & [Record ID#])It seems that the url for the code page works everywhere except for when its embedded within the old/legacy form.The code page when embedded in the old style gives a 'QB API ERROR: Error: Request failed with status code 500' Any thoughts?
Our business can be complicated. as of now everything is done manually. There are multiple commissions based on about 7 different things. Location, Manager, Supervisor, sales person plus what type of products which are 4.We have 12 separate Locations with each different Manager, Supervisor and sales person. Oh and they each have a different % and then on top of it all those % sometimes don't stay static. The owner comes in and makes changes once in awhile. Would I build a table that a drop down menu with the Locations in - once picked then the manager, supervisor and sales person would show ( using dynamic form rules) then a numbers field where the person can add the % and then a formula field to calculate? I really don't know where to begin - thanks for any input
FYI %%rid%% has stopped working. I and others have put in support tickets and are waiting to hear back. But if you check your app you should find the same. Please also put in a ticket so they handle this as a top priority.
Hello,I have a checkbox field that can be manually checked, and a separate formula checkbox field that I would like to be checked if either the manual checkbox field is checked, or if a certain parameter is met. In this case, the parameter is that the Schedule Notes field contains the term "bip". I created the formula below, and the formula checkbox field is checked for sites meeting the specified parameter, but not for sites where the For BiP_manual checkbox field has been manually checked. Can anyone help me figure out what edits I need to make to the formula to accomplish what I need here?If([For BiP_manual]=true, Contains([Schedule Notes],"bip"))
I have a table-to-table app with three tables: Employees, Access Groups, and Permissions. The Permissions table is used to link the other two tables. Each Access Group has multiple Employees, and each Employee has multiple Access Groups.However, I need one Access Group that includes all Employees. Is there a way to add all without selecting and saving individually for 500+ employees?Thank you!Meagan
I have a Parent/Child relationship that has a Report Link and a URL Formula calling a form. I would like to create another similar relationship (same partent/child setup) but call a different form and display a different report related to this new form. I am not sure the best way to handle this? Should I create a new table relationship basically the same as the first one but edit the results when creating the report link and the URL formula? Seggestions?Thanks,Brian
Hi Everyone , I am currently in a project where i need to give data changes which has happened from past 1 week . Initially it looked easy as we have date modified in each and every table. But the catch is in almost every table there are reference field ( table to table relationship) . If those column changes then the reference table date modified does not change. For Eg . If in Table A , table B is being referenced the changes happens in table B get reflected to table A but date modified does not change. Any advise please
Hello all, trying to have a checkbox formula that will look to see if all checkboxes are checked for a section, which I have working. But I need to limit it by project, so it doesn't think they are all the same, since each project will have its own checklist. How do I alter the syntax to correctly only associate the checkboxes on the same project? If(([Yes] = true and [Section] = "Lorem Ipsum") or([No] = true and [Section] = "Lorem Ipsum" ) or([N/A] = true and [Section] = "Lorem Ipsum"), AND <I need to limit this to only items on the same project>Ive tried to put in and GetRecords("{16.EX."&[Project - Record ID#]&"}",[_DBID_CHECKLISTS])But it returns the error "The operator 'and' cant be returned on types 'bool' and 'recordlist' What syntax am I missing to limit the IF check to only items that are part of the same project?
Hello!I am trying to find a way to pull related Records (from the same Table) onto a Form by way of a Parent relationship. I'm not totally sure if this is achievable. Separately, I would also love to be able to click/view a parent from the Child record report (which I'm trying to do for two purposes, but this may achieve the first above).The situation:My parent table "Cases" may have many child "Calls". When a first Call is entered, that's fine. When subsequent Call Records are entered, I'd like to have end users be able to view a report of all Call Records for that Case, ideally embedded in a page of the Form.Alternatively, if they can at least click/view the Case, where I have all this info displaying on a report, that works too.Secondarily, I'd like users to be able to access the parent record for Hospital Logistics. That's a parent table also, and ideally, it pulls a report of those logistics, but alternatively, I just have a way for them to click/open the Parent table in a pop up
To populate a userlist, while using an IF formula to determine whether to pull those users into the userlist, is it possible in one formula field? I want to add the users into the list if Their section meets the criteria, obviously a regular IF statement just ends after the first being true, and skips over the subsequent ones? For example:If([Section01]<>"Complete",ToUserList([Assigned001],[Assigned002],[Assigned003]),If([Section02]<>"Complete",ToUserList([Assigned004],[Assigned005],[Assigned006],
solved
I am trying to use an Outlook pipeline to get multiple attachments from an email and put them in attachment fields on a record. I can create the record using the email, and I can put a single attachment into a single field. I was hoping to somehow use a loop counter or some other method to put the second attachment into field "Attachment2", 3rd attachment into "Attachment3" and so on. But I can only get it to give me a single attachment from the email.------------------------------Mike Brady------------------------------
Hi all,I have three project tables from different business units, each with fields for contract value, contract date, and other details.We want to create a dashboard with reports combining the data from all three tables.What is the most efficient way to achieve this? Does anyone have any suggestions?Thanks!
Hi all,Another loan database question. I need to create a formula for calculating previous balances on a loan and the current ending balance.I also need to be able to create a reconciliation report where our finance department can put in a start date and an end date and get the balance at the start of that period and at the end of the period.What is the best way to address each of these?
Hi, I have a pipeline that is taking an event created in Quickbase and creating an Outlook event. Does anyone know if there's a way to capture responses from attendees (Yes/No/Maybe) and pass those using pipelines between Quickbase and Outlook?
I have a Formula Rich Text field to display a grand total. If the cents end in 0 like .10 it drops the final 0. Here is my formula"<p style=font-size:14pt;color:red;><b>"& "$" & ToFormattedText(Round([Total with Tax & Fee],0.01),"comma_dot",3)& "</b></p>"What do I need to add to show that final 0?
Is there a special character at the end of each comment when using the "Log the edits to this field, and show them on forms"? I would like to use a formula text field to peel off the last entry logged.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.