Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I have a table of leases, and a child table of expenses. When expenses change, it fires a notification off. When expenses are deleted, it also fires a notification. This all works great, except in the specific scenario when multiple child records are deleted at once. In this case, the multi record notification fires, but there is very little information available. I would like to put in a link to the parent record, but I don't think that is possible since I cannot reference a field in the multirecord.My only idea is to make a report of recently changed expenses, but that would only work if they click on the link to the report the same day the notification is fired. Anyone else have creative solutions to this issue? ------------------------------Mike Tamoush------------------------------
Hi team,I moved a table from one application to another, then move this table back to original location, the dbid didn't change, but the data was missing, showing blank table. Do you have any idea what connection was broken? and how to bring data back?Thank you.
Hi,I have an embedded report and each record on the report has a bunch of children records that feed up to it's total dollar amount. That dollar amount is represented as a rich text field. I want the number to be a clickable hyperlink that pulls up the Related Records.This Related Records field name is "Monthly Accounting Review - CM - Related Actuals Records."I've referenced this field in the rich text field via this:"<a href="&[Monthly Accounting Review - CM - Related Actuals Records]&">"&$SummaryNumber&"</a>"This does the job in making the number a hyperlink. But the problem I'm running into is that the link is now operating differently in the rich text field than how it does as it's own field.Here is the report view:But here are the URLs I get for them (top link is the rich text field and the bottom link is the report link field):Thanks in advance for any help on this!
I have made my forms look better and it is easier to enter data. My question is how I can get someone to press a button or tab to bring up these forms in a "New" data entry form? Equipment type I (child table) Tab/Button Agency(table)-------Equipment type II (child table) Tab/Button Equipment type III (child table) Tab/Button
How many different types of forms does Quickbase(legacy, dynamic, or?) use and what are the differences, benefits, and processes of development?
Hello,I am building an application with the intended purpose to have the forms filled out on a mobile/tablet device. One thing I noticed is the notes I added to one of the form fields does not show up on the mobile. does anyone know how to make sure those notes show up? thanks,
I have a formula date field and this is my formula:If (not IsNull([Date ReOpened]) and ([ReOpened Reason]="Mishandled"),[Date ReOpened],"")I get an error on the last "" expecting date but found text.How do I tell it to do nothing if the the formula is not true?
I have a date field that is tracking a transition date, and need to create another field that will calculate 60 days prior to the transition date. How do I set up the formula in the field to show the date 60 days prior to the transition date?
I'll start by stating while I have gone thru much of the free training and also have taken several paid classes, this is my first app that I'm building from scratch.I am looking to create a small walkaround/audit app for a number of facilities.For the sake of this example let's say I have 4 facilities and 5 locations in each. There will be a "checklist" or "set of questions" assigned to each location in each facility. These checklists may be reused by different locations, but not necessarily.Technically, a single audit will have a single location, and a single checklist/set of questions assigned to it. If I create the new audit, and I choose the Facility and Area, I want the assigned checklist/questions to show up for the auditor to fill out. Is there a way to dynamically add these questions, or dynamically add a new pre made form with these questions to the existing form? I initially thought of just adding ALL the questions to a form and use dynamic form rules to make them visibl
I am having 2 issues. Header is bleeding into body of template I don't want the footer to appear on the first page of the template. Word has a feature called "Different First Page". Any idea if this is possible?
How can I reassign a task from an Auditor to another auditor without removing the primary auditor.Let say there is 100 task for Auditor A, but he wont be able to finish it on time so Auditor C, or D would like to reassigned 50 task to themselves at once. Thank you.
I'm running tests on my app and am working on user/approver access. So far I have been the only tester but soon the approvers will be testing but I would like them to be able to test on test records already created. DB summary: Leaves request db for faculty where single request (Leave Requests table) is approved by multiple (7) approver (Approver List table). When leave request is submitted pipeline creates 7 decision records for each approver with status of "pending" in Request Decision table as well as also creating same 7 records in Decision Status Changes table (log of decisions). Currently all records have me as record owner. When app goes live it will have faculty as leave request owners, and would like all decisions records, in either Request Decision table or Decision Status Changes table) be owned by the specific approver user. I can see it is possible to create a pipeline to change ownership for future records, but curr
I need assistance with setting up a formula field where it captures an audit date when the status changes to “Awaiting Corrections.” The date should be recorded on the day the status changes to “Awaiting Corrections” and should remain unchanged even if the status later changes to “Validate Corrections” or “Completed.”For example:If the status changes to “Awaiting Corrections” on 11/08/2024, the audit date should be 11/08/2024.If the status changes to “Validate Corrections” or “Completed” on 11/09/2024, the audit date should still remain 11/08/2024.The audit date should only be set based on the initial change to “Awaiting Corrections” and should not update with any subsequent status changes.Could someone provide guidance on how to achieve this using formula fields?
Hello:I have two fields that I want to merge for reporting purposes.Application Status - PrimaryApplication Status - SecondaryI created a formula-text field named, Merge Primary/Secondary Application Status. I tried the formulas below, but none are working. Could someone assist me with tweaking any of my formulas, please?First TryIf([Nursing]="",[Application Status - Primary Program],[Application Status - Secondary Program])Second TryIf([Nursing]="Application Status - Primary Program",[Nursing]="Application Status - Secondary Program",true,false,)Thank you,Roula
I am having a tough time figuring out the most efficient way to handle this use case. Currently, my pipeline has been running for 12 hours on about 45000 records — so my current method does not work!I will regularly receive a csv file of about 35-40,000 records or about 5mb of data. The data is basically a contact transaction - has a handful of fields including my employee’s unique employee id.Using pipelines, I want to create a key ID by concatenating three fields together, and add a Related employee ID from my employee table.I’ve created a bulk upsert, fetched the csv (which took two hours as it was loading 10 rows at a time), and added a search step to pull the related employee id. It adds the upsert then loops back.I only have about 200 employees - is there a way to loop through the unique employee ids in the csv to update in bulk or is there a whole better approach I’m missing? I need non technical folks to be able to drop the file and have it run. thanks! malcolm
Has anyone used pipelines instead of the Copy Master Detail feature to automate the process? Would like to use a trigger rather than requiring users to press a button.Thanks!!------------------------------Christine White------------------------------
I’ve been trying to set up a notification email for approvers, where when a leave request is submitted by a faculty member, approvers receive the email notification that there is a leave request pending that they then need to approve or deny. The email text will be pulled from a form I’ll create including approve/deny buttons. My problem is the two tables that hold the approve/reject statuses: REQUEST DECISIONS and DECISION STATUS CHANGES, which you helped set up by having REQUEST DECISIONS be the table containing the single approval record for each approver for each request and the DECISION STATUS CHANGES table contain all status records over time (ie: pending/approved or rejected). I’m not sure how the process for the buttons would work correctly.Should I:Create Formula-Rich Text button fields that use API_EditRecord from related REQUEST DECISIONS RID and then add copy of this info to new record in DECISION STATUS CHANGES orCreate Formula-Rich Text button fields that uses API_AddReco
My question is twofold:I have a daily subscription set to send out to a large number of people. It is not every user of the app, so it's a list that's been parsed from the entire user list. Not everyone has been receiving it. Is there a limit to the number of names (or email addresses) that can be added to the delivery list?Secondly, I have an additional list that needs to be added to the recipients that are all QB users, but not necessarily users of this particular app. Is that prohibiting them from receiving this report as well? There is no other reason to add them to his app, but they have an operational interest in the information coming from the report.Additionally I don't seem to have any access to Pipelines to go that route.Thanks for any help!
We have a request to limit what records certain users can see. Our viewer role is directed to a Viewer dashboard where all the objects (reports, buttons, charts, etc.) point to specific reports where certain parent records are filtered out based on a checkbox on the record. I have hidden ALL tables from the viewer role so their only access to the system is via the viewer dashboard.All works as expected, EXCEPT for the global search box. The "hidden" records are not showing on the viewer dashboard reports but if they use the global search box they CAN access those records.Is there a way to configure the global search box to respect the user role or is there some other/better way I should use to effectively hide certain records both from reports and charts but also the global search box?Thanks
Hi,I am not sure on how to accomplish this and I am very open to out of the box ideas. I have a parent table called measures that has a start and end date for that measure. I have a child table called Projects that has a date field called start date. I would like to see a conditional cascading drop down of measures on the project form for the user to pick where that measure's start and end date are between the Project's start date. From what I can tell in the Related Numeric Reference the conditional values has to be equal not <>.
Hi all,I'm trying to do a bar chart where my values across the X label always = 100% of the specific label. I'm not sure what I'm doing wrong on the back end, but I am not sure WHAT it's calculating here.... it seems like the bar chart may be showing how often each county used my program (but that doesn't make sense either -- because in that case, left to right the total would be 100%, and that's not the case either). I want it to basically measure that, WHEN a county used my program, these are the three outcomes by percentage -- and each county's total should = 100%What might I be doing wrong?
I need to filter my report based on a Combined Text Summary Field called "Fruit Salad," which can contain up to multiple different options. I want the report to include only those records where more than one option is selected in the "Fruit Salad" field. For example:Record #1 has "Apple, Banana, Orange" selected.Record #2 has only "Apple" selected.I want my report to exclude Record #2 because it has only one selection, and include Record #1 because it has multiple selections.To summarize:Records with less than two selections in the "Fruit Salad" field should be filtered out of the report.Records with two or more selections should be included in the report.This way, my report will only show records with multiple selections in the "Fruit Salad" field.
When in a table that has a link to another table in that App a new browser tab opens. This can create alot of open tabs. Is there a way to prevent the new browser tab from opening? ------------------------------John Romano------------------------------
This is my goal...getting error message tho. Have tried several other ways, but can't get it to work...thanks for your help.If([Task - USE DEFAULT UNIT COUNT]=true,[Task - Default Unit Count],[Task]="CAULK HVAC VENTS", [Task - Default Unit Count],[Task]="HANG",[FIELD BOARD COUNT.TO PAY],[Task]="Drywall.Item",[Take/Off Calc - NON-STRUCTURAL ITEM COUNT],[Task]="SCRAP",[Job - Maximum FIELD BOARD COUNT.TO PAY],[Task]="FINISH" and [Job - Project - GARAGE.FINISH-TAPE ONLY]=true,([Job - Maximum FIELD BOARD COUNT.TO PAY]-13),[Job - Maximum FIELD BOARD COUNT.TO PAY], ****GETTING ERROR MESSAGE-expecting boolean, but found number*****[Task]="SAND" and [Job - Project - GARAGE.NO SAND]=true, ([Job - Maximum FIELD BOARD COUNT.TO PAY]-24),[Job - Maximum FIELD BOARD COUNT.TO PAY],[Task]="PRIME P/U" and [Job - Project - GARAGE.NO PRIME PT/UP]=true,([Job - Maximum FIELD BOARD COUNT.TO PAY]-24),[Job - Maximum FIELD BOARD COUNT.TO PAY],[Task]="PRIME", [Job Specific Take/Off - Take/Off - Total
I have created a formula field by piecing together answers from similar posts, but now need to take things a step further and can't seem to find the answer.I have a notes field (Status Update) that is set to log field entries which prepends the newest entry at the top. The field displays as:[DATE User] CommentAdditionally, the formula results in showing either the maximum of the three most recent entries, or 2 if only 2, or 1 if only 1, or displays "No Update" if none.Original formula:var text LINEONE = Trim(Part([Status Update],2,"["));var text LINETWO = Trim(Part([Status Update],3, "["));var text LINETHREE = Trim(Part([Status Update],4,"["));If(Length($LINEONE) < 1 and Length($LINETWO) < 1 and Length($LINETHREE) < 1, "No Update",If(Length($LINEONE) > 1 and Length($LINETWO) < 1 and Length($LINETHREE) < 1, "- " & $LINEONE,If(Length($LINEONE) > 1 and Length($LINETWO) > 1 and Length($LINETHREE) < 1, "- " & $LINEONE &"\n"& "- " & $LINETWO,"-
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.