Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi everyone, I reached out to Quick Base support but unfortunately got the most ridiculous no effort answer ever :(. So disappointed in that honestly as they are normally helpful. I assume checked out for the holidays. But, I am hoping someone here can help me. I have an app that maintains a billing section of the app under a larger Project Manage Scope. The organization is as follows: Projects < Opportunities < Orders < Invoices What I am trying to accomplish is a line chart that over three years can show me a comparison snapshot by month of cumulative billing. I want two charts: One chart showing the data as Total Invoices. So it compares monthly and cumulative. So the data point for January needs to be January, February is January + February, and March is January + Feb + Mar etc. The second chart is going to do the exact same thing but filter the data on a "type" field in the Opportunities table. That is already carried all the way
Hello,I have created a dropdown for Project Status, one of the options is On Hold. When they select On Hold, they have to provide On Hold reasoning from another drop down. Then there is an option to select "Other", when user selects Other they have to specify the reason. I want to create a rule to where it clears the filters if On Hold is not selected. because if you make a selection but go back to change your project status to something else, it still saves your old filters. I want to clear all filters under On Hold if its deselected. on hold selected/ on hold reasoning otherwhen I select project status as something else, it doesnt clear the On Hold Reasoning and still shows the Specify box because Other is still selected in the back end. I want to clear the filter.------------------------------Sunakshi Sethi------------------------------
I am wondering how to map one field from a source file to more than one existing fields when performing a file import. As an example, I might have "Customer Name" as a field in my file that I am importing into a table. The existing table may have both fields "Customer Name" and "Customer ID." In this case, I want to be able to map the "Customer Name" from my file into both the "Customer Name" and "Customer ID" fields during the import.Is this possible without modifying my source file to make an additional field that is a copy of the customer names prior to import?------------------------------Jeff Carlson------------------------------
Hello everyone! I was hoping that someone here could help me figure something out with my latest Quickbase App involving Table Relationships and Checkboxes. Thank you in advance! I have two tables. One called Employees and the other called Inventory. In the Employees Table/Form I have a checkbox called Asus USB Monitor and a Numeric field called Asus USB Qty. In the Employees Table I have two Dynamic rules. 1. When the Asus USB Monitor checkbox is checked, set the Asus USB Qty to 1. 2. When the Asus USB Monitor checkbox is unchecked, set the Asus USB Qty to 0. I have created a relationship where the Inventory Table is the Parent and the Employee Table is the child. I believe I need to add a Summary Field to the Parent table. Let's call that field x. The Employee Table includes the following: Field Name -> Value Inventory -> Yes Description -> Asus USB Monitor Total # of
Hi all, I ran into a bit of a snag when integrating Jira with my Quickbase application. We utilize Jira as an externally facing tool for data collection within our company and Quickbase is reserved specifically for my team, due to data separation policies. We developed a workflow in Jira that other employees can interact with to catalog specific information, and we store those details within "Custom Fields" in Jira. I am trying to create a pipeline that takes information from linked Jira tickets whenever a status is changed and brings that into a linked record in Quickbase. However, I am unable to access all of the fields in the Jira ticket from within pipelines. Most of the information available is metadata included in all Jira tickets. I cannot access the specific Custom Fields that I need to collect data from.Any advice on how to access all of the fields within my Jira ticket so I can use them within Pipelines?------------------------------Matthew Rand---------------------
Hi Folks,I have an app where ~500 users are "clocking out" at the same time or close to it. The app is experiencing a 429 Error which I am trying to confirm if it is a QB limitation or if I am hitting a Cloudflare limit.Does anyone have a work around or solution to avoid the 429 Error?Below is an example of one of the buttons being used. Thanks for your help!Matthew-------------------- var text RefreshPage = URLRoot() & "db/" & Dbid() & "?a=doredirect&z=" & Rurl();If([XXXXXX]=0,"", URLRoot() & "db/" & [_DBID_XXX] &"?a=API_EditRecord" &"&apptoken=XXXX" &"&rid=" & [XXXXX] & "&_fid_40=" & (Now()) & "&rdr=" & URLEncode($RefreshPage)) ------------------------------Matthew Brisch------------------------------
Hi,I am trying to include an image (logo) on a form. I have read all the posts and followed the instructions but no matter what I try the image shows like the one at the bottom of this post.I have tried:- Different browsers with images enabled- Rich text field <img src="https://ibb.co/4pdhcTt">- Rich text field <img src=\"https://ibb.co/4pdhcTt\">- Form text field with html enabled and the above image statementsall of the above with a url from an image loaded into a quickbase fieldDoes anyone have any ideas on how to solve this. ------------------------------Pete James------------------------------
I have a field on child form i would like to snap shot from a parent form, but only when the child record is created when a specific (drop down) field is set to a condition.is that possible?------------------------------Nic M------------------------------
When i click on a pdf file from Firefox, it opens in a browser tab. The same thing in chrome, and it downloads the pdf. There is a specific setting in Chrome that states "Open in tab versus download for pdfs'. This setting seems to do nothing. Have other people had this issue with Chrome?Also, when building file links in rich text fields, is there any way to control whether a file is downloaded or opened, or is that purely decided via browser settings?------------------------------Mike Tamoush------------------------------
I'm trying to generate a list of items in one table that don't exist in another table based on query parameters. Intent is to create a system whereby a clerk can check on availability of an item between certain date parameters. Roughly an SQL would look like this: SELECT ItemIDFROM ItemsWHERE ItemID NOT IN ( SELECT ItemID FROM LoanedItems WHERE Start_Date >= '2023-01-01' AND End_Date <= '2023-03-31');I'd like to be able to do this interactively on the fly; Anyone got any ideas how to do this, I'm somewhat stumped. I don't believe a query formula can be used this way, and it might have difficulty with returning data set; i thought about generating a report to show items loaned in the period (positive logic) and show it in a window for the clerk - but that would require human processing to know what items AREN'T in the list to figure out what is available.... I thought about a pipeline, but how can i TRIGGER it withou
Is it possible to have multiple tabs under multiple section headings? Right now I have several tabs under a section heading, but when I create a new section heading it doesn't display on the main form under the other headings, it gets stuck (or embedded) under the last tab.------------------------------Allison Watson------------------------------
I have a Formula Currency field "Total Filing Fee" that needs to preform the following function: Take the value entered in "Filing Fees - Manual". If the field is blank then check to see if "Charge Filling Fee?" is check (lookup). If it's checked then take the value in "Filing Fees (per Filing)" (lookup). If the checkbox is unchecked then the fee should not be pulled into the Formula field and it should just calculate as a $0.00 Below is the formula that I have built. It pulls in the "Filing Fees - Manual", but stops there. I would greatly appreciate any input. Nz(([Filing Fees - Manual]),(If([Schedule - Charge Filing Fee?]=true,[Schedule - Filing Fees (per Filing)],0)))With Manual Fee:Without Manual Fee:------------------------------Ashley Solomon------------------------------
I am having trouble getting my code page to format correctly. It used to be correct and now it has moved the signature portion. Below is the code for that section and attached is an image of what its supposed to look like (ppd redacted) and what i currently looks like (current redacted)code TB (PPD) administered: <span ng-show="$ctrl.ppdArm === 'left'">X</span> left arm <span ng-show="$ctrl.ppdArm === 'right'">X</span> right arm Date: {{$ctrl.ppdDate}} Time: {{$ctrl.ppdTime}} </div> <div class="col-3">Administered By: {{$ctrl.administeredBy}}</div> <div class="col-4 bottom-b"></div> <div class="col-1"></div> <div class="col-4 bottom-b"></div> <div class="col-3"></div> &nbs
I have a pipeline that is going to send an email to multiple fields. It seams to error when one of the fields is not filled in. How do I get around this as it will not always be filled in?------------------------------Kirstynn Rowe------------------------------
Hi, I am trying to give the option of creating templates to the non admin users and I am trying to pull a field value in to the rich text field by entering the [field name] in the rich text field like how we do in the dynamic form rules. I even tried to add it in the HTML source that is shown in the right hand side top corner of the rich text field but it doesn't display the field value but rather just the text field name that I did input. Is this possible to achieve? Thanks. ------------------------------Srinath M.R------------------------------
We have a form for requesting meals to be ordered from a vending service for when we have guests and such. Previously the menu was in the form as a formula URL that had the link to the menu as an attachment from a resources table. I was asked to update the menu. That's when I learned that employees would click the link in the form and the attachment would download and then they would have to open the file to view the menu. Not optimal. I did some research and found a way to embed the PDF menu in the form as an iframe. Here's how: upload the pdf to a file attachment field create an HTML page toggle the HTML button so you can add code add this code to the HTML page <iframe src="https://docs.google.com/gview?url=COPY&PASTE_YOUR_PDF_ATTACHMENT_URL_HERE&amp;embedded=true" width="600" height="650" frameborder="0" target="_blank"></iframe> create a formula URL field add this formula URLRoot() & "db/" & AppID() & "?a=dbpage&pageid
I've created a pipeline to Outlook that will send out an email from a contact record. This was connected to my Outlook account. How do I set it up so that the emails will come from the person updating the record? Does each person have to create a Pipeline that connects to their Outlook email account?------------------------------Renee Williams------------------------------
Hello Community, I am trying to match a text field with a text list formula field, by using the contains functions but it is not giving me an exact match. eg : if text list contains apple ; oranges and my text field is apple it is giving an exact match but even if i write app it will still give me a match.Is there a better way to find the match? I want to tick a checkbox based on this match.------------------------------richa shubham------------------------------
HI, Thanks in advance, How do I write a formula that returns a "Current" or "Overdue" based on a field that tells how many days that task has to be performed and it has a Max activity date summary field, and a "Activities Due Every (x) Days" field.Today()-[Max Activity Date]>([Activities Due Every (x) Days]),"Current","Activities Due"))That was the best I could figure out. Thanks again------------------------------Bob Faulk------------------------------
In a subscription email, you can choose to attach the csv. Is there anyway to specify the name of the file? It defaults to report.csv------------------------------Mike Tamoush------------------------------
Probably easy for you, what is the difference between a "Report Link" and an "Embedded Table" it feels like they are the same thing, and I am having issues creating a "Report Link" that actually works. Probably making this harder than I should, but figured maybe you can point me in the correct direction.------------------------------Michelle Craig------------------------------
hello,I'm trying to archive a field from a parent table to a child table. then update the parent table.I have a parent table. "device_location" (key is record ID) and a child table of "service" related to parent by Numeric (reference) proxy field of "device location name" the parent table also contains a lookup to a master table of device serial numbers.A device serial number is placed at a location in the parent device_location table. occasionally a device needs to be removed and replaced in the service table.when creating a service record I will select a service action from a drop down list. the service is called R&R (remove and replace).I would like to have the child table retain (snapshot?) the old serial number from the parent table (based upon R&R selection) and then have a field for the "new serial" to be entered and have that update the parent table.not sure if this can be done?and this may not be the most clear way to ask?thank you-N-------------------
Hello,I'm trying to write a formula for a field 'Request Status' whose value depends on the 'Request Flag' field of the embedded report. Can someone please tell me how I can do that. Please see the attached screenshots.Also, if the total of the [request flag] is greater than 0 then [request status] should be green otherwise red.Thanks------------------------------Kirti Menghani------------------------------
I have a long data entry form and switched two Sections to Tabs in the middle of the form. When the first Tab is selected, the remainder of the form below it disappears, but when I click on the second (adjacent) Tab, the remainder of the form below it reappears. Any ideas as to why it's behaving this way? I do not have to use Tabs (Sections work fine), but they help with the form optics. Thanks.------------------------------Keith Hendrick------------------------------
Hello, I have a fairly large list that contains groups and sub-groups. Much too many to list in a single dropdown mulitselect field. I was wondering if it could be broken out? The first list would contain the main groups. (You must be able to select more than one option from all dropdown lists.) After selecting the main group(s) in the first dropdown can a subsequent dropdown list be displayed showing the sub-groups for only the selected main groups in the first dropdown list?How would you go about creating this functionality?Thanks,Brian------------------------------Brian Dunk------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.