Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
How to find duplicate values in a report record set? I'm working with a product BOM (bill of material) table that is joined by Product ID. Each Product ID has its own BOM structure which includes part numbers. The BOM table will have duplicate part numbers. Example, a part number could be in the BOM table 14 times (used on 14 Product ID's). When I run a BOM comparison report, filters by "ask the user" for Product ID (#247) vs Product ID (#280). The report pulls all the records for both Product ID's, which includes duplicate value at times.How to identify if a part is a duplicate in this report only?ThxJim------------------------------James Blackford------------------------------
Hello,Can I get help with the below formula?If the field called "type" shows "Air Monitor" then add 90 days to the "Serviced/Inspection Date".I want the +90 days date to show up in a new field called "Inspection Required"Thank you------------------------------------------------------------
Hello QB SME's!!I need help - I have a date field in a record that I need to color code based off of.I need to color code records that are 45 days past the date in the record; AND I need to color code (in a different color) records when the date in that field is 30 days past TODAYS date!!Please help!!------------------------------Alan Tibor------------------------------
I use QR Codes in almost all of my apps. Of course I found out how to do that here! But I can not seem to change the size for printing using exact form. Would it be possible to add HTML formatting in that formula rich text field to the change the size of that generated code or possibly in another formula rich text field that calls the QR Code field. PS I am not a coder and have very little experience with HTML. Thanks in advance!------------------------------Julie Meeker------------------------------
I have a checkbox labeled "Tint Complete?" and a formula field labeled "VIN" which is a formula field with a relationship pulling the information from another table. I need to see if I can link the checkbox to this formula field so if the "VIN" is moved to another form the checkbox and the information in the box move with it. Attached is what the form looks like.------------------------------Joseph Istre------------------------------
Hi All,We have migrated the Pipelines and with a few of them we are constantly having an issue.Thus, we are not able to edit a few Pipelines whenever we are trying to edit it or even when we are trying to create a new one and selecting the table for Projects, an error appears.Please can you suggest how this issue can be corrected/checked?Thank you.------------------------------Iryna Pylypenko------------------------------
I would like to create a button that would save the record and then call the page for an exact form label to print. Is there an API call to save the current record?------------------------------Julie Meeker------------------------------
Has anyone successfully used code pages or other techniques to use native QB data to display a Polar Chart in a dashboard? A polar chart has basically the same data as a Bar Chart, just displayed radially in a circle.------------------------------Thanks, Jeff------------------------------
I have an 'add activity' button in a table listing different properties. When you click it you can add activities in the activity table and it is supposed to be linked to the property and you are supposed to see it in the property table, as well as the activity table. It is working on one property but none of the others. I have been using Quickbase for a long time and this makes no sense to me. It is shows up like this on the one property's table. Even when you add the activities the exact same way on the other properties they are entered in the activities table but they do not appear on the property. After entering through the property table it appears as No activities. I cannot figure out what is going on. Thanks. ------------------------------Beth Hill------------------------------
I am looking to retrieve status information on Docusign envelopes that are sent out. I am using the Docusign Channel in Pipelines, and referencing an app table that contains the Docusign ID.The only thing I seem to be missing is being able to retrieve information for multiple signers. Is there a way to get data on more than one signer? Please see attachment for how I am attempting to reference signer data. ------------------------------Jason Zeller------------------------------
Does anyone have any way to redirect on mobile? Not a standard redirect, but one that is equivalent to NextURL on desktop?How do people handle buttons on mobile? Any button that opens a record to edit, the only option i can see is for it to land on that record. I don't see any way to redirect after a user edit?------------------------------Mike Tamoush------------------------------
Does anyone know if there is a log of past email notifications sent? Thanks!------------------------------Heather Clark------------------------------
Hi,Using Formula Rich Text box as visual indicator - is it possible to incorporate text with the indicator.RgdsPatrick------------------------------Patrick O'Neill------------------------------
I need to be able to extract a user ID from a selected user.The process is as follows:When I select a user in a form, I would like to have a formula text field that populates the UserID from that user field. I have read a similar article:https://community.quickbase.com/quickbase/topics/extract-user-id-from-a-user-nameBut i need a bit of help with the formula that needs to be inputted into the field. Also, because its an API call, would I have to use a URL formula field and then run the script in that way?If I can just get all the user information into a field, I can then run the following formula in another field: Left(Right([User Field],"<"),">") to extract the ID onlyPlease can someone assist with the format of the API call formula: API_GetUserInfoThanks
Hi! I have created a notification that sends an email any time a record is added to a table called "instance." I want to include a report with this email. I've been able to include a link to this report, by adding the following HTML snippet in my custom email message:<a href="https://myCompany.quickbase.com/db/brckkkkkk?a=q&qid=5&nv=1&v0=[Related Subsystem]">Click here</a>Side note: The [Related Subsystem] marker makes sure this report filters records that share the same parent record in the Subsystem table.But what I really want to do is show this report, in the format of a table, in the notification email body itself. I tried using <iframe> to embed the webpage with the report into the email, but that didn't work. Just to be clear, I do not want to create a subscription -- the email needs to get sent when the trigger happens (new record created), not on a daily or weekly schedule.I would appreciate any advice, thank you!-----------------------------
Hi All,Does anyone know if I can use the '$' in the advanced query function to ask for the previous value of a field as a condition? I've tried:{$prev.10 .EX. 'Value'}{'$prev.10' .EX. 'Value'}{$prev10 .EX. 'Value'}{'$prev10' .EX. 'Value'}And none worked. I was assuming that since you could use it in the outputs that it could have been used in the advanced query step. Has anyone gotten this to work?(Updated at 10:47 AM EST to include missing 'prev' after '$'. Still not working.)Thanks,------------------------------Daniel Johnson------------------------------
Can anyone think of a work around for this?On mobile, when you have a child table and the 'Add Child' URL that is autocreated, the behavior works like this.1. If you are in VIEW mode and add a child, when you save the child it returns you to the parent.2. If you are in EDIT mode when you add a child, when you save the child, it lands you on the child you just created.Is there a way to make the button return you correctly from edit mode?NextUrl does not work on mobile, so I don't think I can rewrite the URL formula. I dont think SaveBeforeNavigating works, though I notice my record does save (I think due to the advanced table setting). Right now, I just added a return link on the child, but would much prefer it actually return itself. Perhaps, just add this to the infinite list of mobile issues?------------------------------Mike Tamoush------------------------------
Hello All,I have a table that is related to another. The parent table has a button ("Add record") to a URL formula field which will add a record to another (child table). When the "Add record" button is pressed a new window opens and I would like some of the related fields from the parent record to populate in the newly created child record. Can this be done?------------------------------Scott ------------------------------
add your votes if you want to see a column width lock for the new style table reports:Column Width Lock User Voice------------------------------Adam Keever------------------------------
Can you use User List in the (deliver to:) subscription report?In the deliver to: box the instructions are:"or type in email addresses, user names, or group names:"I tried the below & no one received the subscription.[Assigned IT Team Emails] - This is a Email List[Assigned IT Teams (User List)] - This is a User ListThose (2) fields are not User Names so maybe that is why they do not work.------------------------------Gabe Figueroa------------------------------
Hi All!New users happen to come to my app in form of email address list. Some emails are already users of my app, some are not, UserToEmail function makes the distinguishing. Now for emails not yet users I use API_ProvisionUser to establish a new user in the appropriate role, also I would like to immediately assign the new usersto their tasks. I mean users as established QB users, not just any text labels! To this end I decide if the email address is a user with this formula checkbox: If(ToText(ToUser([Technician Email]))="",false, true)Problem is when my pipeline finishes provisioning the new users, nothing seems to happen to my checkbox, in fact it takes hours to react!!! Funny thing is that after provisioning the new users immediately appear in the user list and are also available in the user pickers. Just the depending user-formulae are lazy as hell. However I tried to set the report caching the problem still persists!Questions:- am I missing here something, doing something wrongly
Hello - I'm creating a form and two of the fields in the form is manager name and manager email. From there, I'd like to create an automated email that sends to the manager's email when a new form is submitted. From what I understand, the field format would have to be "email" in order to send an automated email. Is there a way to create a multiple choice drop down for email addresses instead of text? I'm trying to avoid mistakes by having people type in email addresses. I'm also trying to not link to a table since our company has thousands of managers and we don't want to have to maintain that data. It would be best if we could have a handful of selected managers to choose from, with the ability for the person entering it to add a new manager as they need (like the multiple choice text field allows).Thank you------------------------------Valerie Wong------------------------------
I want to be able to send emails to records entered or chosen from a multi select text field.
I have the code below: var text QueryNotFS = "{16.EX.'" & [Sample Number] & "'} AND {10.XEX.'FS'}";var text QueryFS = "{16.EX.'" & [Sample Number] & "'} AND {10.EX.'FS'}";var text NotFSList = ToText(GetFieldValues(GetRecords($QueryNotFS,"bshhyhvh5"),8));var text FSList = ToText(GetFieldValues(GetRecords($QueryFS,"bshhyhvh5"),8));"<b>SGS Cooler:</b>" & SearchAndReplace($NotFSList," ; ", "<br>") & "<br>" &"<b>Vista Cooler:</b>" & SearchAndReplace($FSList," ; ", "<br>")This works fine on mobile. But I need a line break after SGS Cooler, like so: "<b>SGS Cooler:</b>" & "<br> & SearchAndReplace($NotFSList," ; ", "<br>") & "<br>" &"<b>Vista Cooler:</b>" & SearchAndReplace($FSList," ; ", "<br>")But when I do that, on Desktop it is fine, but on mobile it suddenly removes the entire second part (Vista Cooler). It has something to do with my Search an
I'm sure i'm overlooking the obvious, but here's what i'm trying to do.I have a field called Application NumberThere is a URL whereby the construct is always the same with the exception of the record it's looking for. So it would be like, "https://yada/bla?FirstTime=True&ApplicationNumber=[Application Number]" How do i call upon a field in the URL, and furthermore have the field also be the name the URL is using? I tried referencing the field in the URL and the URL is deciphering it as literal text, not the field value.------------------------------MICHAEL SARGENT------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.