Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hello, Is there a way to change or override the default calendar report hover fields? Instead of showing the built-in fields, "Event" "Start date" and "End date" , we would like to display our own fields. Is there a way to do this? Thank you!
QuickBase Support Center I've looked at the formulas for dates above but couldn't find what I needed. I need a read only formula field that will always be the 10th of the following month based on another date field. Thanks.------------------------------Chris Baker------------------------------
Good Morning Everyone, Currently I have a URL - Formula Button that directs people to edit their related record. It works perfectly fine on the web version, but not on mobile. If I sent the direct link that works on web to mobile, it then works on mobile. The button returns the user back a page instead of where it is suppose to go. Here is the code below, any help is appreciated. URLRoot() & "db/" & [_DBID_PERSONNEL] & "?a=er&rid=" & URLEncode([PersonnelRecordCopy]) &"&dfid=2" & "&z=" & Rurl() Thanks------------------------------Sean W------------------------------
How do I allow non-Administrator roles to have access to my Quickbase application via the REST API? Currently, it looks like only Administrators have REST API access. ------------------------------Hersh Gupta------------------------------
I have numerous multiple choice fields that are logged. They are also read only (filled in using button pushes). In edit mode, see picture below. One multiple choice field shows a line, the others do not. Does anyone know when it shows the gray line? Not a big deal, but messing with my OCD! ------------------------------Mike Tamoush------------------------------
Hello - Is there a way to add field values to Rich Text elements added to the forms (new layout) or Dashboards using the code <> option? If so, are there any resources on syntax? Edit: For example - On my dashboard I have several gauge reports showing as counters and the numbers are all different sizes (and appear bolded compared to other text on screen), so I would love to use a Rich Text to have more control over formatting. ------------------------------Thanks in advance,Jennifer Paschal------------------------------
We recently created an API where it gets Quickbase records, performs an IRR calculation using a python script, and writes the IRR calculation back to the Quickbase records. The problem with this is that we have to run this against all Quickbase records in our table. Ideally, we'd want a pipeline to trigger the API on that record alone, as to avoid incurring cost through a Databricks contract for having run the API daily against all records. The issue we're running into is that the [Python] notebook runs behind our firewall so Quickbase can't run the pipeline successfully. Anyone gotten this to work on internal VPNs? Or, is there a different option to calculate IRR on a singular Quickbase record through a pipeline?------------------------------MICHAEL SARGENT------------------------------
I'm trying to create a formula to decipher which shipping company the tracking number scanned relates to. Once it's scanned, a field would auto-populate to the courier that relates to the tracking info. For example, I know UPS utilizes '1Z' in their tracking information, however it doesn't always contain '1Z'. They sometimes use 12 characters. Fedex also utilizes 12 characters. Is there a way to decipher which courier the tracking number relates to, or do I have to have the user manually choose from another field if it's UPS or FedEx?------------------------------Ziyad Elabady------------------------------
Hi everyone, I hope this is a simple question. I have a check-in button that works (yay), but I want it to refresh the table report that it's in, and not open the record. Is that possible? My code is: URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" & "&rid=" & [Record ID#] & "&apptoken=ye9hbxcau45itjjdkhccw9ccsg" & "&_fid_28=1" & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]) and it Does work and do exactly what I want it to, I'm just hoping to keep the table report open, so a person can quickly just go down the list and click 'check in' for each. (Note - while the button is just changing a check box from unchecked to checked, my end users who will be completing this action will not be opening the report in 'grid edit' mode - I realize there are options for this, but I just want to give them this one table report and have them click 'che
This looks like garbage. I don't care about gauge charts personally, but management loves them. Is there any way to get rid of the legend? ------------------------------Michael Rose------------------------------
Good morning everyone. I've been having an issue with seeing field properties in the GANTT Template App in the Quickbase Exchange. I'm trying to replicate fields and it's just being a pain because I can't see certain properties. I've run into this with many fields. I've had situations where it doesn't show the formulas for formula fields. I've tested before and after installing the plugin in the template app. I've redownloaded the template app. It's frustrating not having full control over an app in my realm. I'm a realm admin. I have the top permissions in the template app. Any ideas? GANTT Template App Projects Notes: My app Projects Notes: ------------------------------Dwight Munson------------------------------
1st let me apologize for the post if this answer has been provided in another post. I Just Cant Get It. (Head ban on wall)!!! Scenario: in default page allows users to select a list from a combobox. (List 1, List 2, etc)_. Each list has different records. Each record has a button that locks record x to the user that clied it and keeps others from editing that same record Regardless of the list/record in the list that is selected, the default .Form is displayed. Form contains Formula URL field displayed as a button [Add Record] containing the following formula. If(="List 1",URLRoot() & "db/" & [_DBID_TABLE_B] & "?a=API_GenAddRecordForm&_fid_29=" & URLEncode ([CID])& "&z=" & Rurl(),"") When clicked 's default form is opened, CID is populated into that form, and other fields are displayed. When saved, user is redirected back to .Dafault Form where the [Add Record] button was clicked. What I want is for the user to be redirected to t
Hi QB Friends, I've been waiting for help from Tech Support all week; now it's a long weekend in the US and I need try and figure this out before Monday afternoon. I'm wondering if any of you have experienced anything like this, and if so, how did you resolve it? Quick explanation: I'm building a workshop registration system - each workshop has between 2 and 4 sessions. I want our facilitators of the workshop to oversee the registration of our guests. They login to Quickbase and complete this form: Registrant information is populated from another table in the database. So far so good. This information works just fine with every registration record. Our team select their hospital and their community of residence and moves to section 2. Section 2 - Registration information This information is populated by sub-tables - I have a Workshops table, a separate Sessions table that lists every single session (like a calendar of upcoming events kind of
I am currently having an issue where my custom buttons return me back to the previous page instead of advancing me where they need to go. This only seems to occur on the mobile version and works fine on the web version. Here is the formula for one of my buttons below, any help is appreciated URLRoot() & "db/" & [_DBID_PERSONNEL] & "?a=er&rid=" & URLEncode([PersonnelRecordCopy])&"&dfid=2" & "&z=" & Rurl() ------------------------------Sean W------------------------------
I have been working on email notification on a Feedback post. I then setup my email address to the three notifications for AHL App. The two subscription notifications I receive. However, when I put my email address in for the notificaition for new and changed threads on the Feedback table, I get the Notificaiton Error, that I'm not verified? On the user list I am an Administer and also registered. ------------------------------Bob T.------------------------------
Hi - Is there a 'ToEmail' function of some form? I have a list of email addresses, but it's the Key field from a sync'd table (not editable) and it's 'text' format. I want to create a formula email field where it looks at the key field and converts it to a more usable 'email' format. Is this possible? Thanks folks!!------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------
Does anyone know how to display child records on the form using the new form builder that is in beta testing? I don't see the option anywhere.Current forms option:New form builder in beta:I hope I am just overlooking this option or that it will be added soon. My organization uses this feature on many forms. I tried using the add report option, but the embedded reports from relationships are not available as options.------------------------------Adam Keever------------------------------
Hi everyone, Is it possible to be more granular with emails and have them scheduled 'an hour' after or before the start time of a date/time field? Thank you!!------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------
I need to create a report that shows the number of active employees by month. I have a checkbox field that denotes if an employee is active or not. I can create a report to get the total of active employees for a single month Here is an example of the filters for employees active on Jan 2023: active = yes and start date is before Feb 1 2023 or active = no and termed date is after Jan 31, 2023. I would like to be able to display every month in a single report for the current year but am just not sure how to go about it. The fields active, start date, and termed date all exist on the same table.------------------------------Brad Johnson------------------------------
Hi all, I'm hoping this is not a QB limitation. I want to have a notification email sent to an email address listed in a field and not necessarily a user. For example, our team has registered a guest or client for a workshop, I want an email notification sent to the guest or client listed in that registration record to say 'You are confirmed to attend XX workshop' Is this possible, or is this a limitation in QB? Could I accomplish this using a pipeline rather than a table notification? Thank you! Jen------------------------------Jennifer Juhasz FamilySmartBC, Canada------------------------------
How do I view a log of activity on a specific field in a specific record?------------------------------BuildPro------------------------------
Howdy all. Does anyone know any tricks to accomplish the following as seen in the attached image? The child records to this parent come in sets of 3, each one has a field called "Run-Time". I need to combined the run-time of a set of 3 child records, then I need to summarize those totals up to the parent. This would give me an average run time per group of 3. ------------------------------John Ross------------------------------
Struggling just a big here. So I made a javascript codepage for clock in/out, but when I am trying to pass certain parameters in the clock in section of the code it will only let me pass them as a text, although, they are date/time fields or related record fields. Could someone assist me in the formatting here? Code Page: function showModalMessage(message, title, url) { $('#modalmessage').empty(); $('#modaltitle').empty(); if (title === undefined || title === null) { title = 'Alert!'; } $('#modaltitle').append(title); $('#modalmessage').append('<p>' + message + '</p>'); $('#mymodal').modal('show'); $('#closediv').click(function() { window.location.href = url; }); } function closeModalMessage() { $('#mymodal').modal('hide'); } var fieldValue = function(field) { return $(fiel
Hi Team I am looking at options for sending email from QB. I have found 2 x youtube videos from Kirk Trachy Using mailto: send emails out of Quickbase - https://www.youtube.com/watch?v=15GfNnvJd4w Sending Outlook Email from Quickbase - https://www.youtube.com/watch?v=qML8_n6n6r4 Looking for advice here before diving into the expense of Pipelines ($250usd per pipeline) For those using MailTo - Pros / Cons For those using Pipelines - Pros / Cons Have tried to search for answers but really couldn't find any. We don't require mails automatically coming back so as far as I am aware, do not require any email parsing. Thanks for your feedback or expert experience.------------------------------Jessica Matenga------------------------------
How do we copy an address field like "Project Address" from a table in one app to another table in another app through pipelines? I've been trying all methods but it still isn't working. Need urgent help with this. I've even tried the using [] brackets as well {{a['Project Address_project_address_project_address_project_address_street_1']}} I inherited the entire QB Application setup and hence I am not sure why the address fields have the Project address being repeated multiple times. That's how it looks even in the fields list view. Need help in getting a pipeline to transfer this address from "Project Address" field in the Projects table (Production App) to "Home Address" field in the Data table (Customer Table). ------------------------------Rahul MathewHead - Data Intelligence & TechnologyIllumine Industries Inc.------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.