Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Case: Weight loss program needs to auto-calculate a 4-week weight loss value.I need to be able to lookup the value in "Today's Weight" field for the same Patient's weekly tracker record dated 4 weeks prior. Here's the relationship between the tables. The recursive relationship looks up the previous week's weight to calculate the weight loss since last week. I just need the 4 week formula. Thanks in advance.------------------------------Sherry BlackburnSr. Applications Systems Analyst (Quickbase at PeaceHealth)PeaceHealth------------------------------
Has anyone had any experience with connecting Quick Base to Google Data Studio?Thank You!Chris
Anyone else experiencing issues uploading docs to a file attachment field?It started for us today (May 26, 2023) around 11:00 AM Central.I've tried multiple apps in our realm plus multiple apps on a separate Builder Account realm, and no success.We all just keep getting this error message when attempting to upload anything:I wasn't even able to open a Support Case with QB, I just kept receiving error messages.I tried with and without attachments in the Support Case and just kept receiving the same error message.------------------------------Eric Evans Vargas------------------------------
Anyone good with code pages?Currently there is a promptandrefresh code page which prompts a user for input (on a non QB page) and then uses that input to update a QB field. This code page works on both desktop and mobile app.There is also a code page to get the longitude and latitude of the users device, and put those into QB fields. This only works on desktop, or mobile browser but NOT in mobile app. I am trying quite unsuccessfully to see what commands the promptandrefresh uses that allows it to function on mobile app, that the getlonglat is failing with. I do not code and am getting nowhere. I need someone to take the current code and modify to work on mobile app, or perhaps build from scratch? Please contact me mtamoush@bbch-llc.com if you think this is a project you could do.Thanks!------------------------------Mike Tamoush------------------------------
When I run a query I get the file name but I need to pull the link. How can I do this?
We have a need to build an integration with QuickBase that needs to include file attachments. In searching the QuickBase documentation, we have found an API call using XML for uploading attachments, but the REST API documentation only mentions API calls for downloading and deleting attachments.Is there a way to upload a file attachment using a JSON message and the REST API? If so, can someone point me to the documentation?------------------------------Theo Pozzy------------------------------
Hello, We're trying to create a mobile friendly form for a client and when testing the link, it's loading halfway down the page, the user has to scroll up to see the beginning of the form. Loads with this as the starting point/top of the screen. instead of this: Any suggestions?------------------------------Carrie Robb------------------------------
Hello. When someone looks at the mobile view of my reservation calendar by clicking, "view this facility's reservation calendar", the default view that comes up is the day view. The day view does not have the records on the calendar that they can then double tap on to create a reservation. They have to manually switch in the top left to month view. Is there a way to make the mobile calendar reports default to month view?------------------------------Coleman DuCharme------------------------------
Could you please assist me with adding date or text filters to a Quickbase dashboard?------------------------------manohar vankireddy------------------------------
There is parent table with duplicate records. I am trying to update the child table with reference field to fetch latest values of lookup fields of the latest duplicate record from parent table. But the pipeline is saying the source and destination are same, so no changes were made.------------------------------Naga Polimera------------------------------
Hi ExpertsI have created a BLANK form but there is a More link on the top right hand of the form with a drop down to Copy the form. How do I remove this from the Form please?------------------------------Jessica Matenga------------------------------
Hello!I'm having some trouble with a report link that's matching a text field from "this table" to a multi-select text field in another table. The problem is that if I select the box to "only include values if they match exactly in both fields," the report link won't catch records from the other table that have multiple selections. But, because some of the values in "this table" have common words/phrases, if I deselect the box, then the report link will grab records from the other table that include multi-select options that simply contain the value from "this table."eg -- the values in "this table" are "test" and "testing". If I deselect the box to match exactly, the "testing" records will get grabbed by the "test" report link. Of course, I'd rather do this with record ID #s, but this is a fairly old app with hundreds of thousands of records. The relationship wasn't created correctly and the number of records is usually too big for queries..Thanks in advance!-Harrison------------
I created a webhook pipeline endpoint (for use with paypal payflow link silent post to get me the results of a successful transaction). I am trying to capture the headers of the incoming request but putting "{{a.headers}}" is not working, presumably because it's an actual array. I want to loop through the headers, concat them into one string, and paste that into a text field when I call create record. How do I do this?------------------------------Andrew Patricio------------------------------
Is there anyway I can disable the display that pops up when I hover the cursor over a bar of a stacked bar graph? (pic included)Thanks------------------------------James Dalton------------------------------
So, I am trying to create a report for a specific user, does not matter if everyone else can see it, I just need it to show on their dashboard but no one else. should I create a new role per person? that just seems like a lot of work and that there must be another way ------------------------------Michelle Craig------------------------------
Hello fellow Quickbasers!I am using an image processing API to compress and resize images before uploading to Quickbase. I have _most_ of it working using a FetchJSON pipeline step .. the original image goes out, and I get the correct response back from the image processing service. The next step escapes me though -- the result is not an application/json content type, it's an image/jpg result. EG the below. HTTP/1.1 200 OK Compression-Count: 1 Image-Width: 530 Image-Height: 300 Content-Type: image/jpeg Content-Length: 46480 [binary] With just pipelines, not codepages, has anyone been able to process a result like this? The Iterate over JSON step doesn't seem to work because there's no JSON schema to reference (and it's the wrong content type) .. I'm thinking maybe a bucket step would work?Thanks in advance!M ------------------------------Malcolm McDonald------------------------------
Hello, Is there a way to obtain a chart report's output as an image, using a url? In another post I saw a reference to this endpoint https://www.quickbase.com/Chart/chart.aspx?realmhost=www.quickbase.com&dbid=DB_ID&qid=REPORT_ID&generate=image but it doesn't seem to work. Thanks! Dan------------------------------Dan C------------------------------
I am looking for help in making a report which will make nametags for the Contact, their spouse and any children associated with them -- each family size is different so some Contacts are single yet some are families of five. The Contact is saved in one table and the spouse & children are saved in another table. I've set it up so many spouse/children belong to one Contact.I thought I could easily combine this data into a third table. There I want to create a report which pulls the names of the Contacts and the names of the spouses/children and puts it all in one column, but I'm running into issues doing that.There should be a second column stating which Contact everyone belongs too, as well. Can someone please help me figure this out?Or let me know if there's a better way to organize this data?------------------------------Stephen Jackson------------------------------
I need to create a report to find all records where a 'multi-select text' field is not blank - something has to be checked. If I choose 'equal to <blank>, it still shows all records, not just the ones that have something checked in that field. There are many choices so I don't want to write a bunch of OR statements choosing each option. Any ideas?------------------------------Amy Gosz------------------------------
My Company (Inglett & Stubbs) has just joined Quickbase. We have used Sage 300 CRE for several years. I'm not super familiar with either platform. Sage 300 CRE is a pervasive database. I'd like to be able to automate data flow between Quickbase and Sage. Does anyone have experience with Sage? Were you able to automate the data flow, or you had to do manual uploads/downloads?------------------------------John CroslandSoftware DeveloperInglett & Stubbs------------------------------
Is it possible to use an IF/CASE statement within a Button to select a specific Form to open? I've been using 3 different forms for data entry, each with a lot of form rules, but I've run out of form rules so I think I need to create more forms to get around this limitation. My issue is how can I get from the previous data entry record/form to the right form. Right now, you get to those forms by clicking a button on another form from a different table that is the parent of the record created on my complicated table. I'm guessing instead of 3 forms with complicated dynamic rules, I really to use a lot more forms for data entry. However, I don't want to create more buttons. The data entered on the form before clicking the button should be sufficient to dictate the next step. Right now, one of my buttons that looks like this: URLRoot() & "db/" & [_DBID_SIZE_ANALYSIS_INSPECTIONS] & "?a=API_GenAddRecordForm&_fid_9=" & URLEncode ([Recor
It would save me and my team a ton of time if we were able to paste images from memory into a rich text field, rather than having to upload a file to a web server and insert an IMG tag into the editor. This is possible in the very rich text field I'm typing this comment into. It's strange that the Quick Base community wasn't built with Quick Base. Rather than improving the platform they sold us to build applications on, they hired Higher Logic to write a custom application instead. My confidence in this platform dwindles by the day. :(------------------------------Matt Makris------------------------------
Hello. I am using this formula to show the last comment in the report. However is there a way or a formula that will be able to show me last comment and date in the report? NotLeft(Right([AppendTightField],"]"),0)------------------------------Sunakshi Sethi------------------------------
Hello,I've been using QB for 15+ years. About 12 years ago I was working for an organization that made heavy use of QB. We had the idea to have a central hub of our core data that would feed to other team apps via cross app relationships. It was something like 10 apps connected to that central data hub app. When we did this, all the apps slowed to a crawl. Literally minutes to respond to clicks etc. We contacted technical support and they told us that each app runs on a single thread on a server and when you use a cross-app relationship, all the apps tied together like that run on that same single thread. Where I am now we are potentially looking to do something similar and I figured that 12 years later we hopefully wouldn't have the same issue. However, when I checked with tech support they said that though the engineers have made performance tweaks to the cross-app relationships, apps still run on a s
Anyone know of anyway to create a report on a parent table that lists records where a report for the child table that are associated with that record. (as opposed to the link option) Context: We have Tasks and Sub-Tasks where subtasks are the child records of the Tasks. We want to display the report of those subtasks within the report of the Tasks. I feel like this should be doable, but also maybe not. Thoughts??------------------------------Ender Taylor------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.