Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Is it possible to have QB store file uploads on a different server (Amazon/Sharepoint etc), but with a few catches:1. The data must never live in a QB server, not even cached momentarily while sending to the other server.2. When accessing the data on the other server, it must require each user to have an account (with amazon/sharepoint) and be logged in to their personal account (ie, not somehow be tied to a Realm Admin Account and be using those permissions to access the data)I think there may be some ways to utilize Pipelines and or 3rd parties like Juiced, but I am unclear how it technically works using these systems. Where the data resides in between the upload and it being sent to Amazon/Sharepoint.The ultimate goal is for security purposes. I need certain data to live only on specific servers with specific security requirements covered (which QB does not have).------------------------------Mike Tamoush------------------------------
I have several embedded reports (not Grid Edit Reports) that were designed to collapse by group. These reports properly allow rows to collapse within groups when the reports are opened in 'Full Report' mode. When these reports are embedded in a form, the collapsing check boxes are displayed but do not work. What setting controls whether or not rows on an embedded report collapse by group?Thanks in advance for your help!------------------------------Annetta Coleman------------------------------
I having issues trying to get my rich text filed to print as they appear:This is what I wantThis is what I get:Code Below:var text Bcolor= Case( [Blg ##],1,"#FF00FF",2,"Green",3,"F87A17",4,"#0000FF");//#4E9258var text tcolor= Case( [Blg ##],1,"#FFFF00",2,"#FFFF00",3,"FFFFFF",4,"#000000");var text STYLE = List(";","background:"& $Bcolor, //button color"color:"& $tcolor, //text color"text-align:center", //text alignment//"text-decoration:bold", //none, underline, line-through"font: 36px Calibri", //text size, font, style//"border: 2px solid #0000FF", //border width, style, & color//"border-radius: 80px", //roundness of button corners"width: 275px", //button width"padding: 60px 60px") //space between text & button;"<div style='" & $style & "'>BOX# "&[BOX ID#]&" <br /> TB-"& [Blg ##]&"</div>"Any Ideas?------------------------------Dan McLaughlin------------------------------
I have a lengthy grid edit report for updating project tasks. Updating Projected and Actual Start & End Dates, updating % complete, task comments, etc. The project managers need to come to this grid edit table and make numerous edits in one setting. So that they do not lose work, they are encouraged to Save & Keep Working at appropriate intervals or when they need to step away from their work space. Problem: When the user does a Save & Keep working from the Grid Edit of a Child Table, they are routed back to the Parent Record and must re-open the same Grid Edit Table they were previously working. (This is how I would expect Save & Close of the Grid Edit table should work.) How do I get the Save & Keep working from Grid Edit (of child table) to save the then re-position back to the Grid Edit Table so they can keep working in their grid edits of that child table?-----------------------------
Does anyone have to work with CUI? It can't be stored on QB servers, wondering how you handle this?------------------------------Mike Tamoush------------------------------
Hi Everyone, I've been able to clear date fields in a pipeline using the {{CLEAR}} option however I'm not clear as to how I would clear a multiple choice field in the Parent table using the update pipe. Using {{CLEAR}} does not work. The pipeline rejects the value when entered for mapping. Thanks for any thoughts on this.... Todd------------------------------Todd M------------------------------
Hello Everyone, Is there a way to create a search box in a dashboard that brings the record up in edit mode instead of view mode?The assumption is that only 1 record will be found and therefore QB redirects directly to the record itself (instead of displaying a report)------------------------------Francesco Spiga------------------------------
Hi All,I have a number an approval application that has a table of approvals, that is used for 4 or 5 different approvals. (Payment Requisition, Travel Requisition, etc.)I can do this two ways.1. Set Dynamic Forms, so that depending on the type of approval you select, the form adapts dynamically.2. Have four or five different forms, and have the correct form open, depending on which button is pressed.I would like, if possible to have 4 (or 5) different buttons on the home page. One for Payment Requisition, one for Travel Requisition, etc. And when pressed have an API_AddRecord with the dfid=12 field. But i can't get it to work.Any pointers.ThanksGerome------------------------------Gerome Rich------------------------------
I'm trying to create a conditional statement to hide a button based on one of two statements being true and the user role not being equal to the admin role (ID 12). When I run this in separate browsers, one using a role other than 12 and in the other browser logged in as role 12, the button is hidden in both cases. I'm using the Using formula - multi-select text fields documentation for the 'role' field since my variable is (var roles) a multi-select text field. var text roles = ToText(UserRoles("ID")); If ( // Is completed or voided ([Stage] = "Completed" or [Voided] = true) and // Role with ID 12 == "Administrator" // Not Administrator (Left($roles,3) <> "12 " or not Contains($roles,"; 12 ;") or Right($roles,3) <> " 12" or (not Contains($roles,"12") and Length($roles) = 2)) , // Show nothing null , // Else, the button should displ
Alternatives to common JavaScript Insertion techniques: information and resources Earlier this year, we announced changes to how Quickbase will handle custom code (like JavaScript) when it is placed outside of code pages. We outlined three key areas of the product where we need to close the loophole that allowed custom content like JavaScript to be inserted. Our plan included closing one area at a time, every two months starting in April 2021 and finishing in our August 2021 release. You can learn more about the full plan here. This page includes a collection of enhancements and features we have released to extend the options available to builders that can be used as alternatives in place of JavaScript Insertion techniques. We will also link to information on the feature, help pages, and examples where they exist. Table of Contents Using Code Pages instead of JS Insertion Using new formula functionality to replace JS Insertion Redirects Iframes Pop-Ups Save before navigat
Hey all,I replicate a SharePoint list in a Quickbase Table, using pipelines. For each of the lines from SharePoint list, I look in my QuickBase table if the record exists. If it does, I update the QB record, otherwise it creates a new record.This sounds very similar to what the 'upsert' method does, but until now I haven't been able to make it work. Is it because the bulk upsert works only from QB, to QB ?Thanks for your help!------------------------------Pierre Hamy------------------------------
I need to use a formula query to find the minimum and maximum date/time for a group of records (Flight Arrival Date/Time) in the same table. I know that there is currently no ability to find the min/max inside the formula query, but I'm trying to figure a way around that.I can get the query formula field to display "09-24-2021 01:45pm; 09-24-2021 4:00pm; 09-24-2021 12:24pm..." and so on.At the end of the day, I want a date/time field that will show me "09-24-2021 12:24pm" as the minimum (earliest) of the three date/times listed above.If I use this formula, it gives me a single date/time, but it's not the earliest one.Min(Part(ToText([FormulaQuery]),1,";"),Part(ToText([FormulaQuery]),2,";"),Part(ToText([FormulaQuery]),3,";"),Part(ToText([FormulaQuery]),4,";"))I can get it to work if I use only the time portion, as that can be converted to a numeric decimal, but that won't work for my purposes since a flight may come in at a later time but an earlier date.Doesn't seem I can take a textli
I'm wondering if it's possible to email out a link to a form (either a Quick Base form or a Google form, for instance) to someone who is not a user, they fill out the form and submit it, and it goes into a table...? The idea is for event registration - I email out a registration link, they register, and then their data shows up in my registrants table if that makes sense. OR some other way to automate this process. As it stands, we manually add event registrants. We send them a Google form and then we transfer the data into the table that tracks registrants.
I have heard Fedramp compliance is on the roadmap for QB. Does anyone know any more about this? Is there any literature or marketing materials that actually show this goal and timeline?@Evan Martinez?------------------------------Michael Tamoush------------------------------
Hi,I have a summary formula of a checkbox to give me a count, in the parent table. I am then taking that field and dividing it with itself. In turn trying to use the formula in a summary formula of a report. but if that particular person has a blank value, it does not work in the formula. I have figured out the error is occurring because it is not calculating the blank as zero. Any help with this formula would be greatly appreciated. I maybe think I need to do the blanks as zeros in the summary formula but not sure how to do it there. This is the formula field that I need to treat blanks as zeros - [Extensive Logged Report Types]/[Extensive Logged Report Types]This is the summary formula of the summary report - (((([Number of Charts]-[# of No Info/Search Fee (tot)]-([Extensive 1 Calculation (tot)]))/([Number of Charts])*0.03)*([Number of Charts])))thank you for your help------------------------------Zana ------------------------------
I have two tables in a relationship and need to check if the value in a field in the entered in the parent table exists in a column in the child table. The use case, the parent table contains order information and the child table contains verification data for some of the order data. A ticket is created in the child table by an automation (soon to be replaced with a pipeline) when a new order is created in the parent table. However, for various reasons the individuals doing the verification may not be able to find the ticket that was created by quickbase. If they cannot find the system generated ticket, they will manually create a ticket. The best I can hope for in this situation is to check if they project manager enters a valid ticket number in the parent table. By valid I mean that the ticket number entered in the parent table is actually in the ticket field in the child table. I hope that made sense and am looking forward to your suggestions.----
Hello,I have an email notification that sends out a link to the created record. Is it possible to have a print PDF link in the email instead of the record link.------------------------------Mackenzie Phillips------------------------------
Good Afternoon,Does anyone know if there is a capability if you are in a Slack Channel to create a record directly into QB? For example, if we have a team management channel and wanted to have a Tasks table so anytime we are in our Slack channel we could add a new Task Record to QB Task Table?------------------------------Ryan Locke------------------------------
Is it possible to have a button on a Home page (not a new Dashboard page) to download PDF attachments stored in a table?Thanks,------------------------------Tim Egerton------------------------------
I'm relatively new to formulas and having an issue with a nested case statement. The main thing I'm trying to accomplish is setting up a snapshot field for target profit margin. I created a new table, relationship, and snapshot field itself just fine, but the target profit margin is based on a Margin Category, which is based on two other criteria, Customer Type and Project Type. I've tried writing the formula for Margin Category in any number of ways but keep getting different errors. My latest try is below, and the current error is 'Expecting textlist but found text.' Any help is greatly appreciated!Case([Customer Type], "Corporate Coalition",Case([Project Type Rollup], "Audits", "Corporate Coalition-Audits", "Consulting", "Corporate Coalition-Consulting", "Desk Research", "Corporate Coalition-Desk Research","Guidebook", "Corporate Coalition-Guidebook","Training", "Corporate Coalition-Training","CUMULUS", "Corporate Coalition-CUMULUS","Other", "Corporate Coalition-Other"),Case([Custom
I am looking to create an Excel template of a Bill Of Lading utilizing info from fields in the Sales table on QuickBase. For instance I would like the Ship To address to transfer as well as other valid fields when hitting a button. I know a long time ago there used to be a Microsoft Word Add-on that I could never get to work but I have to believe there is a better option now, preferably without having to purchase an add-on?Also acceptable would be to create another form arranged in a way to look like a BOL that could have the company Logo on it and when hitting the button it would take the user to that form from the main form.------------------------------Chris Swirtz------------------------------
Is it possible to embed a sharepoint folder or number of folders in a form or dashboard? So that i can click on a file, from a dashboard? I know you can link specific files. Wasnt sure if there is a way to embed sharepoint folders itself.------------------------------Michael Tamoush------------------------------
There is a great blog here about the pros and cons of Cross App relationships, vs sync, vs table imports.Sharing Data Across Quick Base Apps: Part 1 Cross App Relationships, Table to Table Imports, and SyncI am aware that you want to avoid having 15 apps, somehow all intertwined with cross app relationships. I am trying to better understand the why.It seems that cross app relationships will create dependencies, so that all apps basically travel together and are forced to be run by a single QB server. Is that basically the explanation?For example, if I have 4 apps intertwined with cross app relationships, and then a 5th app has a single cross app relationship with one of those 4 apps, did I just lock that 5th app in with the rest of those? Not sure if someone is able to give a brief explanations in mildly technical and mildly layman's terms?------------------------------Michael Tamoush------------------------------
Hi All,Here's the formula I thought would work:todate(max(getfieldvalues(getrecords("{756.EX. '"&[Record ID#]&"'}", "abdc3n4ne"),1)))The logic is, find all records where fid 756 (related field) in table abdc3n4ne equals the record ID in the table where this formula is, then of those records tell me the values in the Date Created field, then just tell me the most recent of those dates (what I thought the max formula would do) then turn it into just the date.I'm getting a syntax error. The second ) after the 1 at the end is highlighted yellow and the error box says "Expecting," but that's for the max function, which I didn't think needed a comma.Thoughts?------------------------------Daniel Johnson------------------------------
I have three tables: a Grandparent table, a Parent table and a Child table. As you might expect, the Grandparent table is in a one-many relationship with the Parent table, and the Parent table is in a one-many relationship with the Child table. As an added complication, the Grandparent table is in its own one-many relationship with the Child table. I have a Report Link on the Parent form that I'm using as an embedded report. The behavior I want is to have that embedded report show child records both from the Parent and from that Parent's Grandparent. I do not want to show records from any other Parents under that same Grandparent. Is this possible? I've been tinkering with formula fields as the Report Link targets, but I haven't been able to figure out a way to do it.------------------------------Thanks in advance,Alex------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.