Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi all, I have created the print button and an old screen to display the content for print. But on the print screen, the record ID is displayed on top. How can I remove that ID from the print screen? Below is the screenshot for reference. Please help me to clear the issue. ------------------------------Nagarjuna Satya Srinivas Rompicharla------------------------------
Why do the new form rules only act as if only the first rule is present when it comes to hiding fields? I have a rule that hides fields when a certain state is present. When I add a subsequent rule with a different state, that is supposed to hide different fields, it acts as if only the first rule exists. It shows all the fields I want to hide when the first rule is not met, and does not access the second rule to hide the appropriate fields. Can someone please tell me why this is happening and if it can be fixed? I would rather make these rules than create all these other reports because of future maintenance time if fields or rules need to be added. The screen shot gives a gist of how I have the current rule structure. ------------------------------Mitch Detwiler------------------------------
Using the New Form Builder, inside a rich text box, using the insert link function, how do i get the link to open in a new tab i have tried the ?&target_blank and <a href="https://" & " target=_blank" & ">File Upload</a>" but it just has the text, not a link ------------------------------Nicholas Neilio------------------------------
Hello All, I hope everyone had a great weekend. Wanted to bring something up to the group and wondering if anyone else has seen something similar: I am currently taking a numeric field (Block Hours), using another field to convert it to a duration (Block Hours Duration), and then using a formatted text formula to convert it to HH:MM. Theoretically, if there's only one decimal place, every minute value should be a multiple of 6. However, I've noticed with only a few different values that it is coming out incorrect: 2.3 hours comes to 2hrs 17min, 4.1 hours comes to 4hrs 5min. This does not happen with every 0.3 or 0.1 value either, it only seems to occur on very specific values for some reason. Am I missing something here? Pic #1: Pic #2: ------------------------------Aidon Olligschlager |Flight Operations Technical SupportPentastar AviationWaterford MIaolligschlager@pentastaraviation.com | 248-202-9587------------------------------
I am trying to make the following work. If the check box PHQ follow-up is checked then this statement will appear and will have a clickable hyperlink to the URL(in yellow). I keep getting syntax error when I try to add the formula for the url in. If([PHQ Follow-up], "As Life Scan Wellness continues to enhance psychological testing and resources for mental health, we have screened and recommend for you to consider for fire service;" ;"<a href=" & $redlinerescue.com & ">" & $Redline Rescue & "</a>" & "or for law enforcement to gain access to resources through a partnership with UCF Restores. These links can provide accesses to culturally competent trained peer providers or therapists that can deliver sustainable healing." & "<br>","") &------------------------------Rebecca Knecht, MS, ACSM-CEP------------------------------
I am interested in using the Google Workspace channel to do the following:When the a field is checked in a Quickbase app, I would like to search a Google Gmail distro and if the email is not included, add to the group. Is this possible? Thanks!! Got it working, needed Admin access. thx ------------------------------Christine White------------------------------
I built a CRM in QuickBase a few years ago and enabled Log Entries to date stamp when my Sales Reps update the Status Update field (Text- Multiline). I now want to know if there's a way to use the date stamp and generate a report showing when they last updated this specific field. I appreciate any help to achieve the desired outcome.------------------------------Chris Collins------------------------------
Hello,I am having difficulty with the details display of my many-to-many connections. I'll provide screenshots because it is hard to explain. Basically, my connector table is called "Permissions" and when I first added a permission it showed up perfectly. But when I went to add permissions for subsequent employees it wouldn't show up. I figured out that, for some reason, it is because report filters are using the first employee I set a permission for. I can delete the second part of that filter that is using Meagan, but I have to delete it every time I add a new permission AND it then messes up my original employee (me) so that it doesn't display permissions anymore. I hope that makes sense. lol. What have I done wrong?Any help would be greatly appreciated! Thanks, ------------------------------Meagan McOlin------------------------------
Hello, I'm dipping my toe into formulas - to date, I've used form rules to accomplish what I think formulas can, in a way that feels like the long way around (and requires you to actually open a record/save it, to fire the changes - whereas I believe formulas will just always be current with no manual intervention needed - please tell me if I am wrong). My formula is complex with 4 choices - and each choice is a calculation of a couple of factors. TL;DR: How do I factor in 4 choices that each use an AND function (how do I write "AND" in quickbase.... this is something I'm struggling to Google) - and/or is there a way to use an OR function, to get to each choice? Detail: I'm looking to say, "If this AND that, OR the other, then say option 1; if not, then if this2 AND that2, then say option 2; if not, then if this3 AND that3 AND not this other thing, then say, option 3" How do I get the functionality of AND in this context? Alternatively, I think I c
I've been using pipelines to replace some synced tables that I need to be updated "live". Basically two nearly identical tables with the same primary key. I've created a pipeline for when a record is created in table A to create a record in table B. I've created a pipeline for when a record is modified in table A to update the record in table B. I've created a pipeline for when a record is deleted in table A to delete the record in table B. Now i'm working on a daily refresh pipeline to ensure the tables are synced in case of errors. The bulk upsert process is what I have been using for that, and it works great. My problem is I don't understand how to include the logic to delete records out of table B that no longer exist in table A as part of my daily refresh. Is there a way to do this within my daily refresh pipeline or another pipeline? ------------------------------Drew Voge------------------------------
Good afternoon, Is there a way to swap a field for another, in bulk, across an app? Like a "find and replace" but for a field. Thanks for your help!------------------------------julie mcclenic------------------------------
I have a table in a new mentoring app that grabs information from a separate app on employee separations. I basically want an Excel XLOOKUP function so there is notice when one of our mentors is separating from the company. I have the key set to the Employee ID, which is also the lookup field for the app to app connection. It does what it's supposed to in that regard. However, if I try to add a new mentor or mentee, I can only select an Employee ID from the list of separating employees, instead of adding a new value for the new entry. Is there a way to get around this restriction and still get the info I need from the other app?------------------------------Hannah Engelson------------------------------
Has anyone charted average durations before? I tried it with a pie chart, but when using averages, it is converting durations into decimals (I'm not even exactly sure what it is doing). Trying other charts, but wondering if anyone has already gone through the trial and error, and found any particular charts to be the most useful when trying to look at average durations.------------------------------Mike Tamoush------------------------------
I have multiple rules that have 'Conflicting Actions' error in QB, therefore they will not run. The rules aren't necessarily conflicting. They all have different when statements that will then hide/show or require/unrequire fields. They are hiding/showing or require/unrequiring some of the same fields but they are based on different when statements. In the old forms, it would let you do this and the rules would just run on the order they were listed. It doesn't seem to be this way with the new forms. Does anyone know a workaround for this? I need all these rules to run. ------------------------------Elizabeth Schlagel------------------------------
How in a search bar can I set it up to search for different words that would be in a field but not in the exact order. Let say I have a the following 3 records Grey Sun Glasses White Glasses Glasses Grey In my search bar I put "Glasses Grey" I want only to get the first and 3rd records ? ------------------------------Trevor Kent------------------------------
I have created a request form that I would like anyone in our organization to complete and save. I was under the impression that each person in the organization did NOT need quickbase app itself, just the link to complete the form. is that accurate? Any guidance would be helpful------------------------------Lynda Schutter------------------------------
Hello - I have an app with an Attachments table that utilizes the Attachment File field type in QB. This app has been live for a couple years and there are over 7,000 files in the table. We are looking for other storage options for a couples of reasons including direction from the business, and would like to store files in SharePoint and use the URL to the SharePoint file moving forward. My question is, is there a way to utilize the SharePoint channel in Pipelines to bulk upload all the current ~7,000 attachments to a SharePoint list so that we do not have to have migrate attachments 1 at a time? ------------------------------Thanks in advance,Jennifer Paschal------------------------------
Is there an efficient way to create an exportable report from info within multiple tables? ------------------------------LB------------------------------
Since a formula address field does not exist, I was trying to come up with a way to update a regular address field, with a table to table import, or...?? My situation is I have a 'Combined Table' that merges data from many different areas. There are about 6 address fields, but each record is guaranteed that only one of the address fields is filled in. I want to have a seventh 'Combined Address' field, and somehow fill that field from whichever address field is populated. However, on a table to table import, I am not allowed to choose each specific address field (street 1, 2, etc) and if I try to make a formula field for say, street 1, I cannot simply choose the street 1 field.... Anyone every try to do anything like this before?------------------------------Mike Tamoush------------------------------
I have two tables. One is a work record table and the other is a provider table. I want to create a work record and pick the providers on the provider table that are associated with that work record. There may be multiple work records that are associated to the same provider on the provider table. How should I set this one up?------------------------------Carol Mcconnell------------------------------
I'm trying to figure out a formula to calculate average productivity per day and nothing I do seems to work. I have a table with call reviews. Not every person who completes reviews works every single day of the month. I would like to determine their average daily productivity by taking the number of reviews they complete per month and dividing that by the number of days they actually worked. I can't seem to get the piece for the number of days that have productivity. I could use either the Monitor Stop Date/Time field or the Date Created field to establish the days that have reviews completed. Any assistance is greatly appreciated. Thanks,------------------------------Sheila Allas------------------------------
I have another interesting use case. The request is to send a report subscription to two sales people who do not have access to the app from which the report will come. The requester does not want these users to have access but does want them to see the results of said report. I couldn't think of how to trick Quickbase into sending a report subscription to non-users so I futilely tried to give them a role of None in the app and then setup a subscription to send the report. Not surprisingly, they didn't receive the test email I sent. I know it was sent because I included myself in the Deliver to: Has anyone else encountered this use case and found a solution?------------------------------Julie Bowers------------------------------
Hello, I've created a formula to make another field unique based on selections in another status field. I'm not sure how to end the formula or if I have the set up correct? The error I'm receiving says "expecting comma"? If([Referral Status] <> "Evaluation completed" , [Member ID],If([Referral Status] <> "Evaluation not completed" , [Member ID],If([Referral Status] <> "Member/legal guardian declined evaluation" , [Member ID],If([Referral Status] <> "Other reason why not completed" , [Member ID]) Thanks, LB------------------------------LB------------------------------
Anyone else have sync tables that refresh daily on a schedule? Each of our tables like this shifted the refresh hour to an hour earlier since daylight saving time ended over the weekend (ex. used to be set to refresh between 2am and 3am and now it's set to refresh between 1am and 2am). We've been using these for years and I don't recall this ever happening before. We had our timing set up so it would refresh after the source had the newest file (a scheduled daily file from an external system sends to our server, and QB picks it up from there). Because of the change to an earlier refresh, the file it should have refreshed wasn't available yet. I opened a support case and waiting to hear back if QB will update the schedules back to what they were or if I need to go in and change each of them back, but heads up you might want to check on your daily sync tables if the timing you chose was not arbitrary!------------------------------Emily Keskey------------------------------
Hi community! We have a table in one of our apps that stores help documents to help the people taking calls with certain call types or sub call types. The table has a text field for key words which is populated by the person responsible for the help document. The idea for this field is that it's a combination of words that a person would search for in order to find that document. The users have complained that this is not the best user experience. I noticed that whomever built the app (this was before I joined this org) had put a Search Articles button on the ticket form. As you can see from the formula below it doesn't tie to the call type/sub call type. I think it was built this way because some of the documents don't tie to a call/sub call type but rather are more general about a subject. URLRoot() & "db/" & [_DBID_SOPS___RESOURCES] & "?a=td" Has anyone ever stored help documents in one of their apps? I'm hoping for examples so that I can work on improving the user
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.