Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I would be the first to admit , multi to multi is a pain to setup . In this video we are automating the process of Multi to Multi by using form rules and pipelines (Jinja). See the video herePurpose of the video is to get your creative juices going , this is again version 1 and very basic , I can give v2 if needed.1. I' have purposefully chosen food as it's very easy to understand2. Quick Adoption of this includes Team Members for a given project (who are not users) , Simple BOM items from a dropdownVIDEOBecome Multi Relationship Hero with Form Rules & Pipelines Loom remove preview Become Multi Relationship Hero with Form Rules & Pipelines View this on Loom > ------------------------------Prashant Maheshwari------------------------------
I am wondering if it is possible to add a link to a copied record back to the original record? Here is what is happening...I currently have a copy record button that is working as expected. See code for button below. The issue is when I copy the original record I do not get any attachment field files. Those types of fields are blank in the copied record which is not all bad because I don't want all the extra files if I can link back to the original where those files can be found if need be.Copy Record Button:"javascript:void(copyMasterDetailButtonHandler('&copyFid=19&destrid=0&sourcerid=" & [Budget item ID#] & "', 'bssz8m82p'))"------------------------------Brian Dunk------------------------------
Good morning, please help me:Need to calculate the number of hours from two date/time values: [Job Ended] and [Job Started]Looked at examples in the search, found something formula. But the formula does not work. Empty value:ToHours(([Job Ended])-([Job Started]))What am I doing wrong?------------------------------Dmitriy Serebrennikov------------------------------Ready: ToHours([Job Ended]-[Job Started])
Hi all,Is there anyway to battle the 1MB limitation of richtext fields? We are trying to add snippets into them but the images are just too big, even if we size them smaller beforehand, we can barely add one.------------------------------Aylana Vorster------------------------------
I may be coming at this from the completely wrong direction, but I have two related tables and would like to create a field that pulls the correct record ID for a "vehicle assignment" that is associated with a "driving event". This formula isn't giving me any results, but I can't figure out where my thinking is going wrong. Happy to provide additional context, just not sure what is helpful.If(((([Vehicle Assignment - Start Date]<[Date]) and (([Vehicle Assignment - End Date]>[Date]) or (IsNull([Vehicle Assignment - End Date]))))), (GetFieldValues(GetRecords("{9.EX.'"&[Vehicle OR P&P GPS #]&"'}", [_DBID_VEHICLE_ASSIGNMENTS]), 3)))------------------------------Amy Christensen------------------------------
Is there any way using the ExactForms tokens or Javacript to check or uncheck a checkbox.I have many checkboxes like the one below, which I need a case statement or something of the like to check the correct box. Has anyone done something link this with Exact Forms?Thanks------------------------------Matt Holmen------------------------------
Hi, is it possible to extract text from one field to another based on a specific word or string? I have been playing around with the right function but I am not getting the results I need. As an example I would like to extract the data in bold type for each question. So couldn't you have a formula that would look for "in the appeal:" and give the result "W123456789"?1) Please enter the ID at the top of your letter in the appeal:W12345678902) On a scale of 1-5 how satisfied are you : With the time it took to resolve the appeal once you submitted it to the appeals department: Not at all Satisfied with the time it took That you were treated fairly?: Not at all Satisfied that I was treated fairly That the response you received was clear and easy to understand?: Not at all Satisfied was easy to understand &nb
Hi all, I'm building a dashboard in Quickbase, and ran into a couple issues: 1) I would like to add multiple report widgets to the same dashboard, each showing a subset of data from the same table, with different filters applied. The issue I'm running into is that it seems that filters need to be applied at the dashboard level, thus affecting every report widget on the same dashboard (thereby making it impossible to show different subsets of data in two or more different widgets). 2) Additionally, it doesn't look like it's possible to save filter selections--every time the page is refreshed, you would have to repopulate filter selections manually. Has anyone else found a solution for these issues? Thanks in advance! ------------------------------Daniel Marshall------------------------------
I have created a formula field on my Project Status record to concatenate Project record id (totext version of it) and a date field on the project status record (child of project). I would like to make this unique so the system would prevent the user from creating multiple statuses on the same date for a project. When I try to enforce uniqueness on this field I get the following error message: Here is the formula:ToText([Project - Record ID#]) &Mid(ToText([Status Week Of]),7,4) & Mid(ToText([Status Week Of]),1,2)& Mid(ToText([Status Week Of]),4,2) Here is the error message when I try to enforce uniqueness:?This formula is incompatible with this field being marked unique. Please change the formula or uncheck the unique checkbox.? How can we meet the requirement underlined above? Let me know if you need further clarity.
Hello,I am fairly new to QB. I would like to highlight when two fields of two different records (on a report) are not equal. For example, looking at September and October caseload numbers for a user. October caseload at beginning should equal September caseload at the end. when these fields are not equal, I want the records to be yellow.How can I do this?Thanks for any and all help/guidance.------------------------------Monica (DBH) Hammock------------------------------
Hi,Plz bear with me, I'm pretty new. How do i check 2 Date Fields and if they both have dates, add the most recent to a Formula - Date field?------------------------------Mike Sanders------------------------------
Hi all,I'm quite struggling being able to select a field from the API responses. I'm using requests to do the initial call, but from there it's a jumble of XML and JSON and .loads and .dumps and xmltodict.parse and nothing has been working for me. I'm doing an API_DoQuery call, and it's returning the normal things starting with:<?xml version="1.0" ?><qdbapi><action>API_DoQuery</action><errcode>0</errcode><errtext>No error</errtext><dbinfo><name>TABLE NAME TEMP</name><desc></desc></dbinfo><variables></variables><chdbids></chdbids><record>and then all the records start, and form those records, I only need one or two fields of data, so I would love some method where I can have array = API_data["FIELD NAME"]or some other method just to get the data into workable forms. Otherwise, I'd have to handle the XML as a text file and go through each line in a way thatif
Is there a formula, or a way, to have the date from a log entry field pulled into a separate field or into another formula? Here's my setup and what I'm trying to accomplish: 1. A hearing is completed >> Field Name: [ALJ Scheduled Date & Time]; Field Type: (Date/Time Summary) 2. 60 days from the date of the hearing, the user should conduct follow up and add the status of that follow up in the follow-up field >> Field Name: [Follow Up Status]; Field Type: (Text-Multiple Choice) 3. Every 30 days from the last follow-up status update, the user should be following up. I'm trying to insert a field that will calculate the next follow-up date each 60- or 30-day follow up, without the user having to manually enter a date of follow up. (New field name: [Outcome Follow Up Date]) My thoughts were to try to base the new field [Outcome Follow Up Date] on the [ALJ Scheduled Date & Time] field for the first 60-day follow up; then the next 30-day follow up to be cal
Hello,I am trying to set up a webhook to capture any changes to a record. I don't know which field is going to me modified by the user, therefore, I need the webhook to capture the field name that's being changed. My question is is it achievable with webhook? If it is achievable, how?Thank you.------------------------------Chaohan Li------------------------------
Hello,Trying to do a formula that looks at if a field says "Delivered" , however sometimes it could be "DELIVERED" the formula I have now will not pick up both. So can I do an IF OR statement. If so, how?If([Return Tracking Status]= "DELIVERED" and [Order Cancelled]=false and [Updates Needed]=false, "Complete", "Not Complete")------------------------------NOEL HODGES------------------------------
I'm wondering if it's possible to have a webhook put the name of a specific field inside a text field on another table.I am creating an audit trail table, that will track the changes of a specific field. However, I have several fields that I want to track changes for. I have it working where it will put the old value and the new value in, and even the name of the table that the record was changed on. So I'm hoping that much like the table name, I can pull the name of the field as well. Thanks!
Hello everyone. Multiple-select lists are very handy, but they can be quite "tedious" when generating reports or other actions related to multiple-select. I want to suggest from a strictly academic point of view of software architecture that you use intermediate tables for this type of needs. It takes a little longer, but FOR ME it is the correct way to store this information.Marcelo Benavides Torres------------------------------Marcelo Benavides------------------------------
We have a table that lists everyone's upcoming time off, called team calendar. I'm trying to use Get Field Values to show me a list of everyone who has requested off at the same time. The relevant fields are Type, fid 15 User, fid 7 Start Date (of Time off), fid 6 End Date (of Time off), fid 18 This is the formula I have now ToText(GetFieldValues(GetRecords("{15.EX.'Vacation'}AND({6.OAF.'" & [Start Date] &"'}AND{6.OBF.'" & [End Date] & "'}) "), 7))Unfortunately it's only showing me values where the start date matches the start date of the new request, where I need to get any request that occurs on that date, even if it's in the middle of a request range. Thanks------------------------------Sean Boat-MooreHospitality Solutions Development ManagerNCR Corporation sean.boat-moore@ncr.com | ncr.com------------------------------
I want to write a fairly basic If statement that would look something like this:If([Resolution Date] > (3+[Initiation Date], "TRUE", "FALSE)However, I receive the error "Expecting bool but found date".Are dates able to used in this way? Are there any possible workarounds I could explore?Thank you!------------------------------James Warren------------------------------
In a project management app, I have two tables to capture expense records. Expense A contains accounts payable bills, entered manually. Expense B contains credit card transactions. They must be separate because Expense B syncs to credit card company using the credit card company's record ID as the key field. Both tables have similar data: transaction date, vendor, amount, etc. Both tables are related as children to a parent Job table. Data from the two Expense tables is summarized in a formula field that combines the two sets of related Expenses. I would like to be able display a list of all expenses related to a given job as a single report on the Job form like one might with a report link field.My current, clunky solution is to have a third table: Combined Expense. Since I want a list/report of all data from Expense A and Expense B, I made Combined Expense a child to both Expense A and Expense B with lookup fields to gather the data, and a third field to combine the two se
Hi everyone,I am trying to create a checkbox formula field that should check automatically if ALL 3 URL fields are not blank (have any info loaded in those URL fields) Can I do this with a Checkbox formula field? maybe a dynamic form rule? I am assuming this could be done with Pipelines but I want to try to do it with either a Checkbox formula field or a dynamic form ruleThanks in advance!------------------------------The Reynolds Company------------------------------
Good day,I hope all is well.Is there any way when pasting an image into a rich text field to resize it using your cursor? As in, selecting the border and resizing it that way instead of having to right click and go to image properties and resize from there? We're having troubles with sometimes inserting screenshots that exceed the capacity and the entire website lags after that and we have to restart.Thank you in advance.------------------------------Aylana Vorster------------------------------
I've been using below methodology at LOT for quickly capturing info on the go on mobile , this is also used by my assistant for quick capturing information in 1 place during meetings. Why am I posting this ? Barely any information exists on JINJA on forums and online from pipeline perspective. PS : This is a Version 1 video , I do skip through explanation of jinja code thoroughly , if people demand , version 2 would be created Jinja - Generated Children through text fields Loom remove preview Jinja - Generated Children through text fields View this on Loom > ------------------------------Prashant Maheshwari------------------------------
How to clean up too many relationships.I worked on an app ~ HIT. It's a hardware app for the hospital. So it is an inventory of hardware and software assigned to employees.I just cleaned up a section to show the specific hardware assigned such as ( AHL-DESK-1063 - Laptop - - -). the dashes in this example show data that isn't in the table, which is okay.Then for one employee they show all the data fields filled out. (AHL-LAP-2079 - Laptop - Hewlett-Packard HP - ProBook 445 G7 - Win 10 Pro x64)I have another form to work on, maybe two to fix too.But I have noticed quite a few relationships, especially for two tables. Some show the same relationship twice, and some have the relationship reversed, which is acceptable. But is having the same relationship twice unnecessary? I know the lookup fields and summary fields may be different on the two 'identical table relationships'. It just seems that duplicates should be removed, but make sure the lookup fields and summary field
Hello All,I need a formula for a field that sums up the total weight of specific bags in my table.I currently have 25 Text-Multiple Choice fields titled "Item 1," "Item 2," etc., and 25 numeric fields titles "Weight 1," "Weight 2," etc. Each Item field has 4 choices. One of which is "Checked Bag," and then the relevant weight is displayed in the corresponding weight field based by number. I need a formula that sums up the total weight of all items (1-25), if the item field is equal to "Checked Bag."Hoping for a simple fix here. Thanks,------------------------------Aidon Olligschlager------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.