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 scenario where I have a parent table with a list of trial numbers.I have a related table that has a list of subjects. Each trial has many subjects, and some subjects have more than one trial.In my form, I want to be able to add a new subject. In one field, I have labeled the primary trial, which is a table relationship picker.However, I also want to have a second field labeled the secondary trial, which would pick from the same table as the primary trial did, but with different results. How do I make the referenced selector independent of one another?
I have a reminder email notification setup, based on the date in a field called "Remind Me On." This is a date field where the user can specify a date in which he or she wants to be reminded of the task. We chose this path rather than standardizing reminders to be sent X days prior to the due date. This way, if someone wants to be reminded a week before or a day before, they can customize their remind date. In the reminder email template, I have the option to select to be reminded X days before the "Remind Me On" date, or X days after. I attempted to insert a 0 value in that field, and selected "before," hoping that I would get a reminder on the date specified in the field. I did not. The only other solution I can think of is to create a formula field that takes the Remind Me On date and adds 1 day. Then setup the reminder email to send 1 day before that formula date - which would end up being my Remind Me On date. Are there any better solutions?Thank youSherri
I created a button utilizing the copy master and detail function. The button works fine for me (app admin) but a user (participant role) gets a message that zero records were created when she presses the button. I have checked and the participant role has add/edit/delete rights to all the tables and there is not access restrictions on the records.What else should I consider/look at to determine what is happening?ThanksEmber
Not sure if the title exactly describes what I am trying to achieve, but here is what I'm working on.I am trying to create a simple-ish application for one of my teams where they can track projects, enter associated time entries for each and then create invoices for those entries.My setup is Customers table, Projects table, Time Entries table, and Invoices table.Customers relates to Projects and Invoices (1 Customer can have many Projects and Invoices).Projects relates to Time Entries and Invoices (1 Project can have many Time Entries and many Invoices). Invoices relates to Time Entries (1 Invoice can have many Time Entries).What I'd like to have happen is when a user goes to create a new Invoice, they would select a Customer and then a Project and then see a list of Time Entries where Customer and Project match AND the value in the Related Invoice field is blank (i.e. Time Entries that have not been previously invoices).The thinking is that the user would then be able to select a
I just posted a question and then found an answer.Is there a way to just delete my post/question?
I am creating an approval app, in which I have created a request form with various fields. I have another table that has the approval details.For example, in a request, the user selects a company, and the approval goes to the designated approver (which is specified in the approval details table).company approval 1 approval 2 xyz yyy@gmail.com fhfhf@gmail.com When the user selects "XYZ" in the request form and submits the request, the form should automatically look up the company associated with "XYZ". The corresponding approval authority for that company should then receive a notification to approve the request. Please note that I have already created "approve" and "reject" buttons, and I know how to send email notifications.
I know this has been probably answered before, but I just can't get this formula to work. I want it to save a record (even a new record or already created one) and check a box. I am going to use that box in a pipeline. Here is my formula. Can anyone see what I am doing wrong? It does not check the box (fid is 599).var text RID =If(IsNull([P-Referral Record ID#]),"%%rid%%", ToText([P-Referral Record ID#]));var text URL = URLRoot() & "db/" & Dbid() & "?a=er&rid=" & $RID & "&_fid_599=1";var text LABEL = "Send Consent to JotForm";"<a class='Vibrant Success SaveBeforeNavigating' data-replaceRid=true href='" & $URL &"'>" & $LABEL & "</a>"
I have a jinja expression that simply compares old to new, and writes to the text field it sits in on the pipeline:{% set result = "" %}{% if a.requested_offer_types != a.$prev.requested_offer_types %}{% set result = result + "Requested Offer Types from " + a.$prev.requested_offer_types + " to " + a.requested_offer_types + "\n" %}{% endif %}{{ result }}The if works however it overwrites the text field. I want it to append to the text field.I dont want to use the log function, as I dont need the user and time details
I like the new look of the Exchange but it feels as if the resources included has been reduced or "cleaned up". I am searching for templates using search terms that I know just months ago, returned suggestions and now they do not. Does anyone know if the list of available templates was paired down when the move to the new layout occurred?
I'll try my best to explain...I have a dropdown field [Status] with 2 options. - For now we'll label them "Option 1", and "Option 2".I have a date field [O1_DATE] that puts in the "current date" when Option 1 is selected via dynamic rule.When Option 1 is selected, a numeric formula field [FORMULA1] calculates [today] - [O1_DATE] (using ToDays and ToDate), and this gives me a total number of days Option 1 has been selected.so far no problem...Now lets say I change [Status] to Option 2 and 10 days later I switch back [Status] to "Option 1" for 20 more days. How do I get it to only calculate the days that "Option 1" was selected?In a nutshell, I just need to know the total time a record had the status of "Option 1".Thank you and I look forward to your suggestions. LJM
I just encountered an issue I have never seen and am wondering if anyone else has come across this.I have a Formula Rich Text Button that Does the following:'Class=Save Before Navigating'Run an API_EditRecord and set a half dozen fields.I am in Table A, and there is a record in table B being edited.The problem I am having is I will see the 'Saving' dialogue come up (indicating my record is being saved), but it doesn't always see that field was changed. Here is an example.For example, I changed a singular text field (minimally, I removed a period). The auto save ran, but then it indicated '0 fields changed'. Yet, I can see on my launch record the field is in fact saved, without the period. A field definitely changed. (I would post a picture but that seems to be bugged)This is not consistent. Sometimes I run the test and the edit is made as expected. Another time I will run the test and it doesn't register the change. It is almost as if it is a race against the clock. Sometimes the
Hey everybody!I have a form I created to keep track of inventory in our IT room named "hardware". I have another form I created when issuing equipment (new assignments). New assignments allows me to search the user by employee ID number (that's pulled from another table called employees), and then i have a lookup field that brings up the details of the equipment when I search by serial number. One of the details it pulls is the "hardware status" that can be several predefined options like "in stock" or "Issued". I have a checkbox on the form new assignments, that when checked and the form saved, I would like it to automatically update the field from "In Stock" to "Issued" in the hardware table. Is this possible? Where can I find documentation on how to do this? Thanks!Leo. ------------------------------Leo Matute------------------------------
I am playing around with a single Formula Rich Text Field containing multiple buttons. I managed to get it to look pretty good using the code below, however on mobile it is not as nice. The buttons don't stretch nicely and use up the whole screen width. I tried something else (see very bottom) that sort of worked, but still not clean. Any CSS gurus who can get the buttons next to each other on mobile, and have them stretch across the width of the mobile?var text URLOne = FirstURL Herevar text WordsOne = "Button One Words";var text ButtonOne = "<a style=\"text-decoration:none; background: #63bf3c; border-radius: 3px; color: #ffffff;display: inline-block; padding: 7px 12px; text-align: center; text-shadow: none; border: 0px solid #030404; font-size: 13px \"href='" & $ButtonOne & "'>" & $WordsOne & "</a>";var text URLTwo = Second URL Herevar text WordsTwo = "Button Two Words";var text ButtonTwo = "<a style=\"text-
I typically use buttons on my app's homepage to give users quick access to the reports they need. I now have a scenario where it'd be really useful to have a list of reports accessible via a dropdown menu on the homepage. Is this possible? I can't find a way to do it, so I'm guessing that if it is possible, it's going to be complicated - but asking here just in case there's a widget I'm somehow missing. I can achieve the same thing via a bunch of buttons (or a single button and getting my users to filter), but a dropdown would look 'tidier'. While on the topic of making reports accessible from an app's homepage - am I understanding correctly that if you use the Reports List widget, that widget will display ALL the reports in the selected table(s), or is there a way to limit the list to specific reports?
We have taken our first step on the journey of fully re-imagining the Quickbase Exchange. In July 2023 we released an open beta of the new Exchange to all Quickbase users. In this first iteration, you can now browse and install formula fields. You can also install apps in the same way you can in the current exchange. While this is an exciting first step, it is only the beginning! Sub-App Components The legacy exchange has only supported full applications. Over time, we have identified a strong desire from the community for smaller components such as formulas. For example, "Magic Buttons - Having Fun with Formula URLs" is listed for the sole purpose of sharing formula techniques. You may have also seen apps which share components such as code pages or pipeline templates. In the new Exchange, we want to make it easier to discover and consume these types of components. As Quickbase builders, we all know how important and powerful
Hello! Intermediate-level user here and very much enjoyed the former QB forum - hoping to see some familiar faces on here.I am dipping my toes in the waters of fixing a Quickbase app that I didn't actually build - which is great! Something I'm thinking I want to learn more about/perhaps pursue from here. But also feels like the litmus test here - fixing my own Quickbase that I built is one thing, but now getting to know the ins-and-outs of someone else's is - wow. Anyway. One ask from the team I'm refreshing this for, I'm struggling with because I'm not sure this is possible. They want to see on the Table view, a field that populates a date from the related table of the last record. Perhaps there's a formula that I can pull to make this a field. So -- in the simplest terms, I feel like what this field needs to be is:Parent Table owns the field, and that field is points to the Record Date of the newest Child Table record.How can I do this? Is there perhaps a formula field to build?
Has anyone connected QuickBase to Google's BigQuery?
Good Afternoon All,I've recently started playing with the Rich Text page feature. My plan is to put together a How-To guide for importing data into the system, incorporating notes and screenshots into the guide. However, when I go to save my changes to the page in settings, Quickbase freezes and I have to continually click "Wait for Page" for several minutes until it finally saves and redirects to the settings page. I have tried using both Google Chrome and Microsoft Edge and they both have the same issue.Does anyone else have a similar experience or any kind of advice as to how I can speed up this process?
Hello,For context: I have 3 separate tables to manage research study data. Let's call them Study 1, Study 2, and Study 3. Each study has follow-up visits at different designated Timepoints. Some Timepoints has a ± 7-day window, and other Timepoints have a ± 14-day window for when the visit can take place. For example:Study 1, Patient TimepointsPatient IDStart Date1-Month Window3-Month Window00101/01/202401/24 - 02/0703/25 - 04/0800202/01/202402/23 - 03/0704/24 - 05/0800303/01/202403/24 - 04/0705/25 - 06/08 I have fields in each table to calculate each of the Timepoint Start and End Dates based on the patient's start date (1M Start Date, 1M End Date; 3M Start Date, 3M End Date; etc.). I then combined each timepoint's start date + end date into one field to minimize the number of fields in my report (1M Window).Lastly, I added a formula-text field that returns the Current Timepoint each patient is in, example: 1-Month Visit, 3-Month Visit (when the patient is within a time
Hi, has anyone else run into the issue this week where the QR generator at chart.googleapis.com has suddenly stopped working? Even my sample code of https://chart.googleapis.com/chart?chs=100x100&cht=qr&chl=HelloWorldis returning a 404 not found....
Greeting - I want to do an IF Statement to tell me if a file has been attached to the record or not. it does not seem to be working when i say Attachment=True. how could should I format my text formula field to tell me an attachment is present?If([Attachment]="true","Yes","No")
Formula help I am trying to figure out how to apply 1 incoming payment to many invoices. I have 3 tables Clients, Invoices and payments, each client has many invoices. Client usually makes 1 payment which I need to apply to several invoices at one time. Can I set up a checkbox that would trigger a formula to divide the payment equally among all the invoices for that client that have a status of balance due? Forn example, Client A has 10 invoices with a status of balance due totaling $10,000.00 and we receive a single payment of $7500.00 which I want to divide among these invoices via my payments table. To complicate things, I have another field in my payments table that automatically calculates the write off amount. Then I have a formula field which takes the invoice amount due – payment received – write off amount = $0.00 (all invoices always have to have a zero balance to close them out. Originally, I had this set up through my Clients table.&
I am using the add child record button that's created from the relationship. The button exists on the 5th page (tab) of the form. Once I finish creating the child record and save it, it does bring me back to the form, but on the first tab. The only time it returns me to the correct tab is if I refresh the window on the form page that the button is on and then click the button. Is there anyway to use a "custom" Rurl() so that it always sends you back to the correct form page? Or is there another method to return to the form page? This button does require user input so the rdr method doesn't apply I believe. The current formula is (sensitive data replaced with XXX): URLRoot() & "db/" & [_DBID_XXX] & "?a=API_GenAddRecordForm&_fid_19=" & [Record ID#] & URLRoot() & "&z=" & Rurl() ------------------------------Dustin Johnson------------------------------
I'm trying to write a formula for two fields-- Field 1 has Option 1 and Option 2. I'm trying to configure it so that if the user selects Option 2, then another field will pop up for them to answer. Right now, my formula works because I have Field 1 set as a Multiple Choice field type. However, I need Field 1 to be a Multi-Select field type, and when I try to change it to a Multi-Select, then my formula does not work. I get this error: Invalid formula provided in form rules: [{"errorMessage":"Formula Error -- Type MismatchThe expression [_fid_18] on the left hand side of the operator \"=\" is of type textlist while the expression \"Vendor\" on the right hand side is of type text.","ruleIndex":11}]What's the best way to implement this?
I have 2 tables with relationship. I want to show 2nd table column2 data in a list view as per the relationship selection criteria. This list view needs to be added in a form.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.