Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
I am trying to set up a gauge report that displays % completion, to display on new dashboard as a single %.Numerical percent formula field:[# of Content Reviews Completed]/[# of Active Content]/100Gauge Report set up:Gauge measures: Numerical percent formula field (above), summarized by (summed)Start at 0Goal = 1Filter: Content Status = ActiveGauge Results: The total # completed, not the % completed.------------------------------Colleen Burch------------------------------
I have created a Qbase table report - and in the option section I have selected CSV as the format. When I click on the report it automatically downloads (which is great) --- I would like to know if it would be possible to connect to this report from Power BI (via Power Query)?I'm currently using the Quickbase Power BI connector -- this works fine -- but it takes a long time to load the data. My hope is that -- maybe I can leverage a Quickbase Report that is formatted as a CSV -- and import the report directly into power bi -- just as a csv or excel file is imported -- resulting in the data loading faster. Is this possible? Not sure if there is an API call via URL that would allow this --- Any suggestions are much appreciated. Thank you------------------------------Brad Elmore------------------------------
Greetings,I am building a new app and my SECTION HEADINGS are showing in black font instead of blue? Please advise.thank you------------------------------BuildPro------------------------------
is there any interest here from anyone in a public PHP composer library/wrapper for the newer QB REST api? uses the latest php ^8.2 features built with copmoser fullly oop/class based tables represented as backed enums built with the stable and updated guzzle, symfony components full unit testing typesafe arrays / illuminate collections (generics) easily transpose returned data as flat keyed arrays easily transpose flat keyed array to QB json methods for easily generating and working with qb jinja style queries ------------------------------shawn naquin------------------------------
I have a Text field that contains numeric account numbers that generally start with Zero (ie: 04201345). They show fine in Quickbase, but when i "Save as Spreadsheet", the account number field always erases the leading 0, (IE: 4201345)Is there a way to make sure those Zero's stay all the time?------------------------------Jamie Brown------------------------------
Hi QB Community,I need a pipeline where I can pull data from one quickbase table and at specific time it can generate .txt files at any shared location.We have such kind of functionality available in quickbase ?Present Table-Need the outcome in any shared location-Please help me out , if we have any solution available.Thanks in Advance !Anjali ------------------------------Anjali Sharma------------------------------
Anyone know if there is away to authenticate yourself on Google Chrome through Quickbase so that on an embedd URL Link it can authenticate you so you can have access? ------------------------------Ender Taylor------------------------------
Hello,I'm very new to API Buttons and could use a little bit of help. I'm trying to create a button on the parent table that, when pressed, will update specific fields in the associated child records and then return to the original parent record form. Basically when clickedGeneral Table Information: I have two tables I'm working with here. The Parent table is [LOCATIONS] and the Child table is [VEG___FLOWER_PLANTS]. So basically, a [LOCATION] has many [VEG___FLOWER_PLANTS].I've tried this a few ways and I keep getting an error. Here is what I have in my Formula URL: //edit the Child Recordvar text URLONE = URLRoot() & "db/" & [_DBID_VEG___FLOWER_PLANTS]& "?act=API_EditRecord" & "&rid=" & [Record ID#]& "&_fid_20=" & URLEncode([Abbreviation])& "&_fid_23=" & URLEncode("Flowering")& "&_fid_9=" & URLEncode(Today())& "&apptoken=b8bt467bv36g6icr3fmfgcwf4c42"; //return to original record and form (opens original record in
Quickbase documentation states that an 'Address' field type is supported in a connected field/table. I have a connected .csv with both a combined address field, and separated subfield components. How do I populate the Quickbase address field with the columns in my .csv?
Hello,I want to create a gmail connection to quickbase table. The format remains same for all the emails. The blocker is that I recieve a table in gmail with bunch of records. Few of these records are highlighted. I only want the highlight records to be moved in quickbase. Any ideas regarding the workaround.Thank you!------------------------------Ramesh SinghRamesh------------------------------
I'm researching my options for managing attachments in an App. The goal is to build an automated process that can locate all file attachments in a table (including revisions) and based upon criteria like age or another field on the record delete the attachment.Has anyone played with this and have experience to share? ------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
[The Quick Base Knowledge Base is your library of frequently-asked questions that help you better customize your apps to solve your business problems.] If everyone using a particular Quick Base table or application package sets their browser's character encoding (on Internet Explorer click on the "View" menu and select "Encoding") to the same setting then everything will be displayed and edited consistently whether the setting is a single byte character encoding like IS0-8559 or Western European (Windows) or a multi-byte character encoding like Unicode (UTF-8) or Big5, GB, HZ, Shift-JIS, JIS. Quick Base stores all characters as a sequence of bytes. Most character sets commonly used in Europe and the United States require only one byte per character to encode the entire character set. The most popular of these character encodings are called "ISO-8859-1" or "Western European (Windows)" or "ISO-LATIN-1". Under these circumstances each byte store by Quick Base represents a single characte
Does anyone know how to remove/delete an attachment from a field using a pipeline? I'm trying to use "update record" and am not seeing any option to remove an attachment. It looks like the attachment field isn't an update option in the "update record" UI.What I'm trying to do is have the user upload an attachment. The attachment gets added as a child record and then removed from the field where it was attached on the parent.Thanks,Jake------------------------------Jake Rattner------------------------------
I have a 2 part question: A) Does the Date Modified field value update if a record is simply "read" during an import, ie after a CSV import occurs, you see the screen that says "500 rows read, 100 records added, 100 records modified". Would those last 300 records in this example have their Date Last Modified value change or does it only change when a substantive data change occurs? B) if those records that are read do have their Date Last Modified value change, I'm trying to come up with a checkbox formula that says: If Date Last Modified is during the past 10 days, true, otherwise falseEssentially, I'll have a weekly automated import process, & I want to ensure any records that are included in the import are marked as active. Nothing about these records will change, the only way to determine if they're inactive is if they're no longer in one of the weekly imports. If the "read" records don't have their Date Last Modified value updated, do you have any recommendations fo
We have a form with multiple help field texts but they do not show up on the mobile app. Is there a way to get the help field texts to show up on mobile? If not, is there a creative work around? At this point, it seems the easiest but most tedious solution is to add a text field before each item or use Alternate Label on the form for each item, so any other suggestions or tips would be great.------------------------------Jamie Low------------------------------
I have created a report formula query field to show my actuals in a cumulative way for my primary y axis. (It is grouped by week in the x axis.) What would a query look like to create a goal line in the secondary y axis that shows an increase by 45 each week (goal is 45/week)? I do not have a field to summarize the goal. Is there another report formula query that could accomplish this?------------------------------Colleen Burch------------------------------
When refreshing a connected (sync) Box folder containing CSV file, Quickbase instructions offer to match my table csv file (overwrite) or keep all data, update changes and add new records. For our use, in the next refresh, some records listed may be unchanged, some records may not be on the list anymore and need to be removed from the connected table in Quickbase. Is there a way to compare and remove the parts that are no longer on the refresh file?------------------------------Bruce Basinger------------------------------
We have a requirement to upload files that are larger than 10 MB using the QuickBase API. It appears that the newer REST API is only allowing files up to 10 MB. The older XML API allows larger files (presumably up to the 100MB QB limit).Is there any way to upload larger files with the REST API?------------------------------Theo Pozzy------------------------------
I have seen a couple posts on this but no answers in those posts. We have a report where the text in one field does NOT wrap. Field setting has been reviewed and confirmed so we don't know why it won't wrap. This causes the report to go off the page. Is there a fix for this? ------------------------------Amy Gosz------------------------------
As we are three weeks out from Empower (register here!), we want to hear from our Community about the experience today. We're asking for Community members to take a few minutes to complete the following survey. Thank you in advance for your feedback! Community Survey------------------------------Ben Simon bsimon@quickbase.comDo you have Feedback on how to make Quickbase Community a better experience? Let's chat!------------------------------
Hi,I am trying to pull a metric from one app and put it in a field on another app. I created a formula query field that looks at all applicable records in the current year. All applicable records show this total % as a text value. I've created a pipeline to (A) search all records where that field Is Set. This search yields 12 records. I then have the pipeline (B) look up the specific metric record this value needs to go to. Then (C) update the "Actual" field with this value.The pipeline yields 12 records, when I really only need one. I don't care how this is accomplished; can be a max value, average of them all, or just pulling the data from the first value in the array (i've chose the latter which you will see in my YAML code.The issue I'm running into is Step C is skipping on my pipeline saying "skipped because set values are the same as in source object." I'm not sure why it is doing this. Hoping someone can help troubleshoot this or advise of a better solution. I didn't come up wit
Anyone have a quick fix for this problem? I'm trying to get percentages for each week on this stacked bar chart and if I change it to 'percent of series' it's giving me the percent of all green. What am I missing? ------------------------------Jeff Peterson------------------------------
Good morning,I'm hoping someone can help me with this real quick - I have a field that is a drop down and the selections for that drop down are from another table. It's been working fine until today, and now I am getting this error message: Does anyone know what this means? And how do I fix it? I checked the properties for both fields, and as far as I can tell nothing changed, but I must be missing something.Thanks in advance.------------------------------Allison Watson------------------------------
Hello Community,How would you find a text field where all records end with a dash? "-"Most fields do not end with a dash.I notice Quickbase does not offer the "ends with" as a filter, there is a "begins with" filter. Any ideas? Thanks,------------------------------Jim Harrisontransparency = knowledge + understanding : The Scrum Dudes------------------------------
As we are three weeks out from Empower (register here!), we want to hear from our Community about the experience today. We're asking for Community members to take a few minutes to complete the following survey. Thank you in advance for your feedback! Community Survey
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.