Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Hi all,Could anyone point me in the right direction for information on creating and formatting a basic check ledger table (i.e. to track credits and debits to/from a checking account)?I have a parent table "Clients" with many children tables. Each Client has one checking account with many transactions, so I want to create an "Account Transactions" child table. The issue is that I'm relatively new to QuickBase and have never set-up a table that uses formulas in such a way that an account balance can be tracked across records with the same parent.I'd like to be able to run a report for a given Client and see a classic-style check ledger with payee/payor, description, amount, confirmation #, date, balance, etc.Any pointers would be an immense help.Thanks,Max------------------------------Max DeGenova------------------------------
Not sure if this is known, but I just realized that if you are in the new report style, and set your column heading to a space, it will make the column heading blank (previously you had to use a period or something small to 'trick' QB).Even better, when you switch to the old report style, it seems to keep the column heading blank.Anyone else discover this, or find any issues? I am wondering if at some point when using the old report style the column heading will suddenly fill in.------------------------------Mike Tamoush------------------------------
Are there any pipeline interfaces that I can use to pull data from Microsoft Todo?------------------------------Jeffrey Thompson------------------------------
Hi everyone,I have a field called "City" which appears in 7 reports on a Page.Rather than creating a new Page for each of 15 Cities, with 7 filtered reports each, ... is there a way to action all filters from a single Page, i.e. selecting by City?Thanks,Rick------------------------------Rick Satenstein------------------------------
I just noticed the option to create a new table based on a field that was in the previous report view is not available in the options for the new style reports(obviously It's not something I do often). Do I have to go back to the previous report style or is the functionality just moved somewhere else in the new style report?------------------------------Paul Peterson------------------------------
Because, if you are like me and are really tired of getting linked to the virtual event site only... Here is their super hidden IN PERSON event in Boston. Quickbase Empower Boston 2022 Quickbaseempowerboston remove preview Quickbase Empower Boston 2022 Join us live for Empower Boston 2022, an exclusive, invite only opportunity! Last year we moved forward together. We've learned to expect the unexpected, and we grew in new ways, at speeds and to a scale never done before. In 2022 we are continuing that momentum and are prepared to Build the Future.... View this on Quickbaseempowerboston > https://www.quickbaseempowerboston.com/2022------------------------------Meredith Moore------------------------------
I have a pipeline that I need to run every other Sunday. Is there a way to schedule Pipelines to run on relative dates, like bi-weekly?------------------------------Kiel Berry------------------------------
I have a summary field (Multi-select text) in a table. I then want to create another Formula Multi-Select Text field based on the summary Field. I basically want to do something like the below, but not sure what the proper operators are for TextList fieldsSplit(List(";",If([Channel Summary] = "Retail Sales and Distibution"), "Retail"),If (Contains([Channel Summary],"Retail Sales and Distribution", "Tech Care - Mobility"), "Omni")If(Does not contain([Channel Summary], "Retail Sales and Distribution", "Centers"))I know how the Contains works but i'm not sure how to write "equals" or "does not contain"Thanks,Michael------------------------------MICHAEL SARGENT------------------------------
Now without any Javascript , is it possible to do any confirmation popup of any kind before any rich text button ??------------------------------Prashant Maheshwari------------------------------
Is there a way to recreate something similar the the Excel-like chart shown below with the different boxes and such within a form? Short of it being a child table obviously.------------------------------Chris Swirtz------------------------------
Hey everyone, I have a pipeline that's performing a document merge with Formstack, and I just tried a merge with a large amount of child records (more than 100) and got this error. I haven't played around much with bulk record steps, so I don't really know what to do here.------------------------------Elena Larrabee------------------------------
Hi,We are transitioning one of our QuickBase tools and want to redirect the user to either the Home page or an external SharePoint when they select any table, instead of disabling the user's access to the table altogether.Is this possible? And if so, how can we do it?Thanks,Deepak------------------------------Deepak Agarwal------------------------------
Hi we have several files csv files on our network which we need to automatically ingest into different tables in quickbase. I have reviewed pipelines and believe this is the way to go. The problem is the only examples are utilizing box, dropbox etc. How do we simply ingest a file from a shared drive on our network into quickbase using automations.Any help is appreciated.------------------------------Michael Malchiodi------------------------------
I'm attempting to write a formula where it looks for a date in "Date 1" and if there is a date, then do a calculation. If there is no date in "Date 1", then use "Date 2" and calculate.I want the AdjustMonth to look in [I-INDOC Continuing Qual Date] first. If no date is found, then use the [I-INDOC Qualification Date].------------------------------Tony Miller------------------------------
How can I stop a user from entering a new vacation request if he doesn't have any available?I have employee directory in one tableVacation requests in another tableIn employee directory I have fields for Total Hours eligible Vacation Time remainingand a lookup from vacation request table called total time requested In vacation requests I have a summary field of # of vacation request (total time)Time requested and lookup fields for total time eligible, total time remainingThe the vacation request table, I want to stop the user from entering another request for paid time off if his eligible time is zero. He can still request unpaid time that would need to be approved. ------------------------------Rhonda Parriet------------------------------
I need to calculate the vacation time requested but the date range is always May 1st through April 30th of each year.Each new year on May 1st, the calculation would reset.My fields are"total time available" that is the time allowed each year"Total time requested" its either 4, 5, 8 or 10"total time approved" its the sum I need to calculate. (see above)for salary: the calculation is easy; its always the current year; for hourly, their time is May 1 - April 30. So every May 1st, the calculation would start back at 0"total time remaining" is formula for Time available - time approved.------------------------------Rhonda Parriet------------------------------
Trying to edit pipelines this AM and they are just spinning. Anyone else experiencing the same issue?------------------------------George Bramhall------------------------------
Can someone tell me what this formula is trying to achieve, currently it takes me to a page that doesn't exist. (I put the x's in place of the actual domain name)"<a href=\"https://xxxxxxxxxxxxxxxx.quickbase.com/db/bh5b2m9ax?a=dr&ifv=20&key=" & [Lease Number] & "&dfid=25"&"\"target=\"_blank\">" & [Lease Number] & "</a>"------------------------------Chris Swirtz------------------------------
Does anyone have experience using Workato or Zapier to integrate with Quickbase?Wondering if one is easier to use than the other, or if one works better with Quickbase? Any recommendations?------------------------------Michael Tamoush------------------------------
Hello!I am trying to create a record within pipelines and add a specific account using the record id or the specific account name and link it to a field so that every time a new record is created, it will be created linked to the same account every time. I am just unsure how to write it into the field, Any tips would be appreciated ,thank you!------------------------------Magaly Reyes------------------------------
My thumbnail pictures created with this:If(Length([Attachment File])=0,"","<img width=\"30\" src=\""&URLRoot()&"up/"&Dbid()&"/a/r"&[Attachment ID#]&"/e7/v0\"/>")refresh unbearably slowly. When I create a new record or create the first [Attachment File] in the record, there is no problem. Contrary to that if i edit a record already having an Attached file and i change the file to another, it takes more than minutes for the thumbnail image to refresh.Especially on a mobile device i need the thumbnails for the user to review the pictures taken in a report, so if an attachment file is changed, the report shall follow. But it - practically - doesn't.In my tests so far there are not more than 6 or 8 recoerd with thumbnails in a report, so i am not querying hundreds of them...Can I do anything to make the thumbnail refresh faster after edits? Am I creating the thumbnail picture the good way? Interested in any workaround if all else fails!Thank You!---------------
I am trying to create a called pipeline where the pipeline formula takes a date field, and then I am querying to find all the records after that date in a specific table. The output from the called table shows the field (q1_start) is in this form:q1_start:"2022-04-25 00:00:00+00:00"but when I try to query the table for any records with dates after q1_start, this is the pipeline output: If I try using jinja to alter it to datetime, it still does not fetch any records.------------------------------Emily Wise------------------------------
I have a formula in excel that performs the task I need. When I build it in QuickBase I'm not getting the same results. I stripped it down to the basics, here are the two results. I need to return a value that is a significant figure of 2.Excel (the way I want it to work)Returns 30=ROUND(26.6,-1)QuickBase Returns 27=ROUND(26.6,-1)Any help would be greatly appreciated.------------------------------Andrew Konopacki------------------------------
Hey everyone, I'm in need of some help formatting a pipeline to create/update Sharepoint folders. Is there good documentation anywhere on it? I haven't found much more than general information on the channel yet. I'm trying to format the file path properly. Basically things are formatted in our sharepoint as proposals\year\client\job. So I need the pipeline to search folders to see if there's an existing folder for a year, then client, and then create itself a path and new folder if there aren't. I'm assuming that each layer of the file path is a separate step in the pipeline? Thank you!------------------------------Elena Larrabee------------------------------
Bureau Veritas offers dynamic, exciting employment opportunities with an attractive salary/benefit package and an opportunity to play a vital role with a global organization. If you would enjoy working in a dynamic environment and are looking for an opportunity to become part of a stellar team of professionals, we invite you to apply online today.SUMMARY: This person will be responsible for supporting and maintaining software applications and project development. Experience with QuickBase platform is required, in addition to other qualifications.To read specifics about the position and more about Bureau Veritas, follow the link below. If you decide to apply, please consider adding me a referral. Thanks!James Rawlshttps://careers.bureauveritas.com/UnitedStates/job/Owings-Mills-%28BAPM%29-Software-Developer-Nationwide-Mary/795389101/------------------------------James Rawls------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.