Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
How do I setup notifications from Quickbase for Timecard Approvals, Meal Break infractions etc. ------------------------------Angela Vinson------------------------------
I want to remove some tables from the menu bar at the top, because I want to force usage through one table. Is there a way to Hide the tables from the menu, but keep the visibility of the data for the user?------------------------------Renee Hansen------------------------------
Would anyone in higher education with Ellucian/Ethos integration to Quickbase experience be willing to provide guidance and share their process?------------------------------Roula Habbal------------------------------
I have a duration formula below: Currently it shows the results in hrs or days. Anyway to have it show hours only and not days? var datetime CheckIn = ToTimestamp([Resource Check In Date], [Resource Check In Time]);var datetime CheckOut = ToTimestamp([Resource Check Out Date], [Resource Check Out Time]);$CheckOut - $CheckIn ------------------------------Dell Delemar------------------------------
I'm trying to create a button that uses the API_EditRecord that will check a box in that record. I've been using the example URL in the Quickbase help section but I'm not sure on a few points. For reference here is the structure that I have so far: URLRoot() & "db/[DBID]?a=API_EditRecord&rid=" & [Record ID#] & "&_fid_1=true&update_id=[UPDATEID]&usertoken=[USERTOKEN]&apptoken=[APPTOKEN]" What do I put in for the correct update_id? By saying fid_1=true is that going to set the checkbox field to checked? Is putting in the field [Record ID#] going to work for specifying the record when the button is pushed? Thanks, ------------------------------Jordan Litwin------------------------------
Hello, I have a form I'm converting from legacy to new, we have a rule on a Noes field where when someone changes that Notes, the rule is triggered. Essentially what ultimately happens is that the users name and the time and date the not was updated is added to the end of the note. I don't seem to be able to replicate this on the new forms, there's no condition for when Notes is updated or similar. Does anyone know of a relatively simple workaround? Maybe in Pipelines, but if there's a formula that can check if the field has changed, that might help. Thanks in advance. Joe------------------------------Personal Tax Team------------------------------
I am trying to add the email domain for a client to view all their data, QuickBase articles says I can do this, but I am not having success in doing so. I have tried adding the email domain in the app itself and in the user list. How do I go about add the email domain?------------------------------Krista Sibery------------------------------
Hello all I need help does anybody know a formula for creating a group of 10 records and labeling those records as A, B etch based on levels 1, 2, 3, etc? Level 1, max 10 records = "A" level 1 Max 10 records = B, etc etc ------------------------------Data System Analyst (Administrator)------------------------------
Does anyone have issue getting Boolean field value from ServiceNow table through SN Channel? The Boolean value retrieved from SN into QB is always "True" and it is not easy to have QB Support to confirm this behavior. HMC------------------------------Hing Chan------------------------------
Did quickbase make an update in ltierally the last 24 hours? I have a table with a key field that is not the record id. I am importing a data file which has the record id but not that key field but it is saying I cannot use record id when it's not the key field. This despite the fact that when I choose the merge field, I select "record id" and not the actual key field. And even stranger, I literally just imported a similar file with the same exact record ids just yesterday and it worked fine. Do I have to vlookup in the actual key field? That's a hassle but not difficult.------------------------------Andrew Patricio------------------------------
I'm using Buckets to create a table and download a CSV. When I upload it to the google drive it's errors out if I make the Mime Type a Google Sheet. If I don't specify the Mime Type the file can't be read in the Google Drive. I can load the file from bucket step manually and convert it in the Google Drive manually to a gsheet so it doesn't seem the file itself. I have also tried adding the gheet extension and that doesn't help either. ------------------------------Scott Talarico------------------------------
I have embedded a Power BI report into a New Dashboard via web page widget -- however when I click on the Power BI "Sign In" --- A new window is launched BUT the Sign-In does not happen......(I have no Issues when embedding a power BI report into the Old Dashboard) --- In order to view the an embedded report within the New Dashboard -- I first have to view the Embedded Power BI report from a Qbase Code Page and sign Into Power BI from the Code Page -- and then go back to the New Dashboard -- then I'm able to view the report. Any suggestions on how to Sign into Power BI from the New Dashboard?------------------------------Brad Elmore------------------------------
I had a script ready earlier and it is working fine on one of the Remote Desktop and the script used to extract the XML content into CSV and upload it to one of the Quickbase site.However I was offered another remote desktop hosted by clients from Canada. And when I imported exactly the same SDK and script, it is failing. My data only has 13 columns. I even checked that cell and found nothing. I’m confused how the same script is running perfectly fine on one machine and showing error on the other. Could you please let me know what might be the cause and give a workaround?I'm getting below error. <?xml version="1.0" ?> <qdbapi> <action>API_ImportFromCSV</action> <errcode>11</errcode> <errtext>Could not parse XML input</errtext> &
Hi all and a Happy New Year. I have a personal question. I will be switching all of my content from this account to my 'sandbox' account in 2024. I have my record of classes taken and my university courses on here. However, I will continue in my personal account. Is there a way I can transfer my Zooms and other items to it? Happy New Year 2024------------------------------Bob T.------------------------------
I'm using a formula URL button to input the current time in a "Clock-in" field. I have another formula URL button to input the current time in a "Clock-out" field. It works, and we have the employees use the mobile app to clock in/out each workday. The issue we are having is that if the employee doesn't close out the app after clocking in, when they clock out, it will input the same time from when they clocked in. Does anyone know how I would modify this code so it will capture the current time, every time, no matter if the app has been closed or not? URLRoot() & "db/" & Dbid() & "?a=API_EditRecord&apptoken=MYAPPTOKEN" & "&rid=" & [Record ID#] & "&_fid_433=" & ToTimeOfDay(Now()) & "&rdr=" & URLEncode(URLRoot() & "db/" & Dbid() & "?a=dr&rid=" & [Record ID#]))------------------------------Barry Dolan------------------------------
Has anyone found a way to use the full site version of QB on a mobile device using the new forms or a workaround to enforce the legacy forms only on the full site version via Mobile? Current state: New forms being used for an app When I use a mobile device and request the Full Site Version (not mobile app) the form crashes and the system is inoperable. I have execs that do not / will not use the QB mobile app and only use the browser/full site version typically------------------------------Chayce Duncan------------------------------
If I have a database where my tables are events and audits and I want to be able to have many events and many audits that can be related both ways, I know that there is an intermediary table required, which i have set up. How do I bring the existing data into the intermediary table without creating a new record. The goal is to list certain events that are related to the audit on the audit form. Any help is appreciated very much.------------------------------Tonya Jacques------------------------------
I am trying to copy a value from one field to another through pipeline. There are 2 scenarios:When the value in first field is non-blank the value is getting copied form one field to 2nd field successfully.But when the value of first field is blank or null, the null value is not getting copied from 1st to 2nd field. Regards------------------------------Aanokhi Gupta------------------------------
Anyone else getting the 'Invalid Application' error when trying to use the manage billing account function? QB made a recent change, and now if I try to manage billing account, it fails in many scenarios. It fails from new dashboards. It fails from reports now that it has added the /tablereport to the URL (without that, it works) I can tell, what it is doing is adding the application ID into the URL, which causes it to fail. I can work around my manually removing the app ID, but when I report this to customer support they say they cannot replicate. Everyone in my org that has admin access is getting the same error. I get the error on every browser, even when cache is cleared, so it is very surprising to me they cannot replicate. Is anyone else getting this error?------------------------------Mike Tamoush------------------------------
This is in the NEW FORMS:When entering an address using the Full Address search it keeps putting the number AFTER the street:After choosing the top address in the list, it puts this into the address fields:This is a new bug and is causing us a bunch of problems. Anyone else experiencing this? ------------------------------Jeff Peterson------------------------------
I have a connected table that I want to access the data in either pipelines or Zapier. The table sources details on the products being purchased. Ideally I would like to know the easiest way to export the table through a pipeline automation or into Zapier were it could add all the table data into a google template. In the past I used Workato and created a loop that would hold all the data in a list and then I would source the entire list. Looking to see if there is an easier solution to the problem. ------------------------------Scott Talarico------------------------------
Hello, I have created a plugin that allows you to create PDF files from a rich text (formula), let me know if you think this can help you or serve your projects, my software development services are at your service(see video). No third-party services, no subscriptions marbentor@gmail.com ------------------------------Marcelo Benavides------------------------------
how can I show a report on a form without it being filtered? ------------------------------Shawn Akins------------------------------
Hi all! Updating - I answered my own question on part 1 (and apparently can't delete this thread haha). So I suppose the part 2, which was just a "nice to have" but not necessary is the only outstanding question. _____________________________________________________________ When building my app, I deliberated whether we wanted to maintain "defunct" hospitals versus just deleting them as closures/mergers happened, and have historically chosen to just delete, but today decided yes, it's helpful moving forward. But now I have some cleanup and wonder if you can help: Reports cleanup: Is there a way in one fell swoop to now go through all or several reports, and tell it I want it to be filtering out hospitals that aren't defunct? Or is the only way to go through manually to make this adjustment? Thanks very much! ------------------------------Christine Kirk------------------------------
Hello, I am trying to use the Copy Master Record button but I would like to be able to only copy select child records based on a field within the child records. As an example, Copy a project and only copy task records that are not marked as completed. This would not have to use the copyMaster function specifically if there is an easier way via pipeline etc.------------------------------Mark Strassel------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.