Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I've asked this before but cannot find the thread.1. Does anyone actively archive (data dump) their data to an outside location? If so, how do you do it? Native or third party?2. Does anyone use API calls from QB to other programs (that are not in pipelines)? If so, what do you use?------------------------------Mike Tamoush------------------------------
When creating a pipeline to look up and update a row in a google sheet, the only query option is labeled "Id". What is this and how do I get the id for the row I want to look up?------------------------------Kiel Berry------------------------------
Is there a way to do a two way sync between google sheets and a QB table? When the QB table is updated, update the google sheet, and vice versa. I found some documentation on how to create a pipeline but not on how to actually use it.------------------------------Danny Fortier------------------------------
Is it possible to use the Cron feature in the pipeline scheduling to send a report several times per day. For example, suppose I want to sent a report out M-F at 9:00, 1:00 and 5:00, can that be accomplished using Cron------------------------------Paul Peterson------------------------------
November Community Newsletter November means that for many of us the weather is starting to cool off but here at Quickbase we are warming up for a whole lot of exciting events and announcements. Events Hosted by Customer Success With November and December being busy months we are combining our November and December Release Review webinars into one on December 8th. Come hang with Customer Adoption Managers Manny De La Cruz and Matthew Brisch as they demonstrate how to take advantage of the newest Notifications enhancement, the new Timeline report, the new customer feedback workflow, and more! Register Here Looking to connect with others in your industry? If you’re a Quickbase builder looking to collaborate with other builders who share your passions and challenges, we are excited to announce our new Customer Networks. Customer Networks are a place to meet with and get to know others in the fields of Construction, Education, Healthcare, and Manufacturing. Sign up here Preparing for
what coding language should i learn to work with quickbase API and pages? please suggest
Is there an afterhours support function when applications are critical to your operations?------------------------------John Baker------------------------------
Hi all, is there a more flexible way of defining CSV outputs for reports? (Changing the separator, enclosing strings to avoid confusion with the separator)I'd like to use the report subscription via email function, but it only provides CSV using comma as a separator and text fields are not enclosed by quotes so I have to take care of not having commas in the content, right?Is there a more error prone way of exporting data using pipelines? Or do I have to write custom code using the API for this requirement?Best regards,Martin------------------------------Martin Suske------------------------------
Hello, I have an app that is building a scope of work based on several variables. I currently have four tables. Inventory Items Scope of Work Rooms Materials Inventory Items Table holds information about materials that can be selected such as pricing, check boxes for which rooms the inventory items can be present in a project, description, units of measure, internal accounting codes, etc. The Scope of Work Table holds information regarding each project and can have several rooms created within it from the Rooms table. The Rooms Table is rather basic and mostly functions as a bridge of information to be bundled and siloed. It is important to note, on this table a "Room Type" is selected (bath, bed, living room, etc). The Materials Table is mainly a child of the Rooms Table, allowing for individual items from the Inventory Table to be added into individual Rooms that are built on the Room Table. Now we come to the issue I am having, all 600+ materials h
Hello,I would like to write a formula for a input field that only allows input of an IP address. What is the best field type to use for this?Thanks!------------------------------Phil Heron------------------------------
I was able to add the Save and Keep Working function on the desktop, but it does not show it on the mobile version. I need to be able to create the record ID so we can write it on the punch list tag when we enter a punch list item. Save and keep working does not show up on the QB mobile App. Any suggestions?------------------------------Brett Sanderson------------------------------
I have a Formula Rich Text button, that when clicked, checks a box that triggers a pipeline and launches a code page while a the pipeline creates child records in two other tables. All of that works fine except for the fact that it will not link the parent to the child records if i select the button in Edit mode. I'm trying to Save the record first and then trigger the pipeline/code page. My formula is below. Hoping someone can offer guidance with the Save Before Navigating portion. Any thoughts would be greatly appreciated! Rich Text Button:var text OGURL = URLRoot() & "db/" & Dbid() & "?a=API_EditRecord" &"&rid=" & [Record ID#] &"&apptoken=dtu36fpy5drric3na9jkc2hufbe" &"&_fid_123=" & URLEncode("true") &"&_fid_151=" & URLEncode("false") &"&_fid_103=" & URLEncode("false") &"&_fid_104=" & URLEncode("false") &"&rdr=" &URLEncode(URLRoot() & "db/" & Dbid() & "?act=dr&rid=" &
I have seen a lot of posts that partially answer elements I want to do, and I am relatively new to QuickBase (not necessarily databases or analytics, though). I am trying to calculate the distance between a worksite and a contractor's address to determine reimbursed mileage. So a couple of questions/asks to help:1) It appears there is not a function or API plug-in to do actual driving mileage. Is that correct?1)a) If there is a function/API, I have not found it. Does anyone have a good resource for it?2) If there is not a function/API, I noticed a few posts on JavaScript formulas to calculate a Haversine distance formula. I just need approximates for budgeting purposes, not actual reimbursements (since they do this through their contractor payroll and screenshots).2)a) Is the Haversine relative accurate to driving mileage from anyone that has used it in the past?2)b) How do you pull Latitude/Longitude from address fields to do the Haversine calculation? I think I am just missing how to
Hi there, everyone. Not used to the nuances of dates and times in QB yet. From our client, we get requests for a date, time, and duration to work a site we will work. I have these items in my current scheduler, but I was hoping to auto-generate iCal for staff using the iCal function in QB using data. For the Start and End time fields in the iCal, it needs a Date/Time field. So, is there a way to:1) Combine the Date and Arrival time to create a start time field &2) Combine the Date, Arrival time, and Duration (in hours) to create an end time field------------------------------Jeffrey Weide------------------------------
HiI trying to build with the new dashboards and am wondering about how QB orders the items in the filter for my chart. I thought it would be alphabetical or numerical, but that does not appear to be the case. It is filtering a text field.I checked to see that there were no extra spaces that could have thrown things off. I also considered it might be sorting the items by their create date, but that doesn't appear to be the case either. Does anyone know how the order is set? Can I do anything to change it? I'd really like it to be sequential.Thanks for your insight!Regards,------------------------------Kim G------------------------------
I have this formula but I'm getting errors. I'm not sure if it's just a syntax issue or something else.If (IsNull ([Date Closed]),WeekdaySub(Today()-[NWS Date Received]-[Total pending First Open],[Date Closed]-[NWS Date Received]-[Total pending First Open]))I have this in a Numeric Formula field. Both the Date Closed and NWS Date Received are date fields but the Total Pending First Open is a Formula Duration Field.As the formula is, I'm getting the error "Expecting Date but found duration" on this section "WeekdaySub(Today()-[NWS Date Received]-[Total pending First Open]"I appreciate any assistance.------------------------------Carol Mcconnell------------------------------
Hello,Is it possible to make it a default that new tables are hidden from roles instead of always visible to all roles? Often tables we dont want all roles to see it, it would be easier if the default was that new tables were hidden until granted access, not automatically grant access. Thanks!------------------------------Mackenzie Phillips------------------------------
Has anyone else tried using the QuickBase API from within a page embedded in a form using the new "Embed as iframe in forms" option on URL fields? I have a code page that works to upload a file when I access it directly. But when it's embedded, none of my API calls work?I believe this is being caused because the URL is being re-written when it's embedded as an iFrame: instead of [mydomain].quickbase.com is located in [mydomain].ui.quickbase.com.Anyone have ideas on how to get around this?--------------------------------Nick MangineThe Link GroupIT Systems Architectnmangine@tlg.com919-903-7269------------------------------
Guys, this beta update is probably one of the worst UI changes I've ever seen. Almost no color, no contrast, and the general flow to your eyes is totally disrupted. All this is going to do it cause a loss of overall speed and productively for no reason. There is no reason to do this when there are tons of other items that actually need change. A better form creation UI to name one.Everything about it just goes against the user: Color highlighting is basically useless. If I want light colors, I will code in light colors. What is the point of this? I just cannot get my head behind this. Might as well remove color coding. The header bar looks horrible. It's light gray and almost blends into everything. The strong contrast on the old view makes your eyes snap right to it. The text is no longer vertically centered in the middle as it should be, and is smaller. Why? Again, the loss of contrast cripples things and
Hello Quickbase Community,We are seeing delays in Webhooks to external services and wondering if anyone else is seeing this? Started yesterday - ish? Things seem to eventually run but not as quickly as we were experiencing before. Any input is appreciated.------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
Hi, I'm fairly new to using Quickbase and have limited programming knowledge. I'm trying to color code lines in a report by date. I have two fields, "Days Till Closing", and "Est Closing Date". Est closing date is our estimated closing date and Days till closing is a countdown based on our est closing date. I want to color code a line in the report red if Days till closing is less than or equal to a certain number and green if its not. Not sure the best way to do this. Thank you!------------------------------Jared Harless------------------------------
There must be an easy way to populate a formula checkbox when a date field is not null. Every time I try to use Nz formula I keep getting errors that it is looking for duration. Help?------------------------------Annetta Coleman------------------------------
Hi,I have relationship between to tables. A is on one side and B on many side.On the form for record in table A I have attached grid edit report from table B to allow users to create multiple child records at once. Is it possible to restrict user to create only up to 5 child records on this form using grid edit report? Is it possible to require at least one entry in this grid edit report and don't allow user to save the A record until at least one child record is created in grid edit report? ------------------------------Piotr Kryszkiewicz------------------------------
Hi -Having some challenges with Radio Buttons. I'm aware I can just make everything drop-down fields, but radio buttons are prettier for a linear scale-style question (I'd also love to figure out how to display horizontally, rather than vertically)I don't want to make the questions 'required' to remove the 'none of the above' option.The only options I can find in the forums here refer back to Javascript, which doesn't work any longer, right? Suggestions on how to make this happen?Thank you!Jen------------------------------Jennifer Juhasz------------------------------
Got this lovely message from QB Customer support:"Reviewing the case notes, it seems you are out of steps, or are close to running out. If you need additional steps, you will need to work with your account manager to discuss options as additional steps typically come at cost, even if the step were consumer by user error."Anyone know what the quota period is? Plan is to wait to the next quota period rather than cough up $$ for a mistake.------------------------------George Bramhall------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.