Qrew EXCLUSIVE: 50% Off Camp Quickbase 🏕️
Get an answer to your question, or share something helpful to start a conversation.
Recently active
Is there an API that will show all the pages ids for an application, or get all pages? I see there is an API call for getting a specific page, API_GetDBPage, but that works only if you know the page ids beforehand. ------------------------------Jacek Lewandowski------------------------------
I have table A that has embedded table B. Once a new record is added to table A then a pipeline is ran and adds new records to table B. However with using pipelines the user needs to save and keep working on the form for table A and then refresh a few times for all the pipeline records to show up. Is there a better way to do this?
Okay, so this one is very basic, but I don't know if this is something that is in anyway native to QB. However, we have a dashboard, which can be seen below, with a filter on it. We will have multiple in field users utilizing this app, so the question is, is it possible to make a default in the filter of the last job accessed by each user. To be more clear if user 1 clocks in on job 4 last and user 2 clocks in on job 1 last, is it possible to make both of those user's filters default to jobs 4 and 1 respectively? ------------------------------William Hunter------------------------------
When linking to a new dashboard, I just view the dashboard and then copy the URL from the browser. However, I noticed that when viewing your pages, you can 'copy Dashboard ID to Clipboard'. This copies the end string to the clipboard. I am struggling to understand how to use this ID in a useful way, without simply copying the entire URL. Is there a clean, best practice shortcut to creating the URL utilizing the Dashbord ID you copy? Or is my way of simply viewing the board and copying the entire URL the way to do it?------------------------------Mike Tamoush------------------------------
Given the increased charges associated with Power BI reads I am looking to schedule nightly exports of selected tables and fields to a series of csv files. What would be the most straightforward, cost efficient way to do so? Thank you, Richard------------------------------Richard Love------------------------------
Greetings, I am trying to create a filter for a large report using "List-User" type field [BP.PM], but also allows other USERS (when they are logged in) to see the same report (using "List-User" type field[USER REPORT FILTERS]) that shows all records in the report.... I get a blank report when I add the filters: ------------------------------BuildPro------------------------------
Hi All!Can anyone advise on how I may need to change this formula to account for multiple names? My goal is to capitalize the first letter of each name. In most cases, there are only two names but there could be more than three as well... This is my current formula... Upper(Left([LAST_NAME],1)) & Lower(NotLeft([LAST_NAME],1)) Thanks so much for your help!------------------------------Laura Natal------------------------------
I have a form that has a embedded report from a different table. When viewing the form, it shows up just fine. But when attempting to print the form using quickbases print function, the embedded iframe which is a formula URL field, is only shown as a URL link. Is there a way around this? I have a button that takes you to the print page for the form like so: URLRoot() & "db/" & Dbid() & "?a=printr&dfid=16&rid=" & [Record ID#] -Thanks ------------------------------Dustin Johnson------------------------------
I need to add ~500 fields using the API and when creating a regular field you can add them to the form in the order they are created with a boolean in the JSON body, however about half of these fields are relational and I cannot figure how to add them in form as the JSON for relationships does not have this field. If it is not possible to add the field when creating the relationship can you update a field or a current relationship and connect fields to them that are already exist in the form? ------------------------------Chris Baker------------------------------
I have a date field that needs to count the number of days that have passed from the date entered AND also need to the field to stop counting when a status is changed to completed or completed previous plan - not sure how to set this up. fields are Date PoC Due (date field), PoC # of days past due (formula duration field Today()-[Date PoC Due]), Approval status (drop down field)------------------------------Lorrie------------------------------
I feel as if this is an easy fix, but I can not figure out how to do it to save my life. I have a dashboard with gauge widgets on it, but when I click the widget it opens the reports in alternate windows leaving me with several opened. Isn't there a way to make these reports populate in the same window when the widget is clicked? If so how, please? ------------------------------William Hunter------------------------------
I have a Quickbase table with data. I have a .csv file that contains 2 fields (fields A and B): Field A in the .csv is common to Field A in the table Field B in the .csv is common to Field B in the table, but Field B in the table is currently <blank> For every .csv entry, I want to find the record in the table that matches Field A. For every match, I want to insert Field B from the .csv to Field B in the table/record. I tried to do this with with the "Import with CSV" pipeline but can't get the "Merge Field" to look at Field A. It only allows me to choose a field that is not common to both the .csv file and the Table. Any suggestions on which pipeline logic/channels/steps to use will be appreciated. ------------------------------Aaron Bab1692@att.com------------------------------
I have two applications both with the same type of field [ID Number] I want to update records in one application [App 2] only when there is a matching ID numbers in both apps. For example, If john smith has ID Number "123" and there is a John smith with the same ID "123" in the other app, then update ...------------------------------Phelan Sanders------------------------------
Hello, I am trying to use a formula rich text field to display a message. Has anyone had success in doing so? For instance, I want to display a note saying "Only the 1st DO is shown. To see the additional DO, open the Agreement." I then need to apply a Field Condition so the note only shows if a specific field is checked. Thanks!------------------------------Colin Fox------------------------------
Quickbase Customer Support has just confirmed that there is a bug where mobile users cannot view files from a rich text link, when that link is on a table report. Previously, if you had a table of say, safety documents, you could make a Rich Text link to the file, and put that on a table report. A mobile user could scroll through that report, and click on the file they needed. This functionality is now bugged, and in 3.5 years I have never seen QB fix a mobile bug, so I suspect this will be the same. Question is - can anyone think of a work around? You cannot put the actual file link in the table, as that does not appear on mobile. My only thoughts are to try different types of coding for the Rich Text link? Interestingly, if you click on the rich text link in a form, it works just fine. Something happens when clicked from the table. Maybe someone else is able to understand what is happening, and come up with a work around. Hopefully someone knows a way, as it is unfortunate that a use
Has anyone tried to view a pdf on mobile lately? Both android and ios would either view or download pdfs. Now I get a message that preview isn't available. Can others confirm? ------------------------------Mike Tamoush------------------------------
I have two text fields I need to duplicate and change the name of incrementally (Total 001, Total 002, Total 003). One of the fields I can use the save and next option to go through the copies I just made and am able to change the names quickly. The other field I can only save and it takes me back to the fields list page and I have to scroll down to find the next copy. From my understanding these fields are identical in everything except name. The name of field one is Attendees 001 and the other is Total 001. I was able to use save and next for attendees but not total. When you duplicate these fields you get Total 001_copy, ...,Total 001_copy 10. ------------------------------Bob Jones------------------------------
Upload multiple files at once with our new File Manager You can quickly have your app users begin to save hours of time by dragging and dropping multiple files at once using desktop or the mobile app for so many uses such as asset management, sales, installation, service, projects, or audits and assessments. Our beta users have shared how quick and easy it is to install and setup File Manager. You can get started by making sure your account admin has turned plugins on for your account with a few quick steps below: First, your account admin will need to enable plugin installation permissions for app admins under Admin Console. Next, create or find one of your existing apps that has a parent with a child table relationship, where the child table is your file storage table having an attachment field. You can use an existing set of tables or create them before installing the plugin. After permissions and tables are all set, complete the easy two step installation by simply navigating
We have a table that includes the fields "Name (ASCII/Latin)" and "Name (Arabic)". The "Name (Arabic)" field was created as a rich-text field. Which, IIRC, was because, when the app was created, QuickBase didn't support UNICODE in plain-text fields. Having this field as a rich-text field prevents using it when creating a filter on the new dashboard pages. To test, I created a formula text field with the formula: ToText([Name(Arabic)]) and then created a report with both fields to compare. The Arabic text now displays in the plain-text field, but ,any of the transformed-to-text names in the plain-text version have HTML tags. This prevents me from even thinking about simply changing the field type of the existing rich-text field to plain text. Does anyone have any handy formulas that will strip out all HTML when copying from a rich-text to plain text field? The HTML is also there when I export to CSV. I can clean up the export outside of QB, but
I'm trying to filter a pie chart to only show where there is more than one instance. The pie chart shows the number of articles that appear in each journal, but I want to exclude journals where # of articles is 1 (or less than 2) Journal is a field Article is a field The pie chart is using # of articles for data values. ------------------------------Michael Buller------------------------------
I have two tables employees and callouts where employees can report multiple callouts. I need to create a report that shows callouts if they fall within 5 consecutive dates. Need help in figuring this out. Thanks !------------------------------JAW WA------------------------------
Hi Team, Like everybody else i have been equally excited by the new forms and coming across issues. I currently use the &ifv=0 at the end of the URL formula buttons to lose all of the QB 'stuff' for some EOTI data entry elements. This doesn't appear to work for me with the new forms. Any clues? This is a URL that currently works for me, from a Dashboard that is EOTI. https://zzzz.quickbase.com/db/databaseid?a=nwr&nexturl=%2Fdb%2Fdatabaseid%44F%3Dshowpage%26pageid%3D101%20&ifv=0 WHen i try a similar URL with a 'new form' the web page just doesn't render. Anybody else come across this issue yet and/or have a suggestion? Thanks Gerome ------------------------------Gerome Rich------------------------------
Good Afternoon Everyone If a person has access to the QB environment without having access to any apps they will see the familiar blank screen (see screenshot) I was wondering if there was a way to post a message of some kind into this space saying please contact XXX for access. If this is not possible my backup solution (not yet suggested) is to create a 1 table AOTI app with no access called "click on me" and add the msg to that dashboard. Seem sensible?? Its Friday and it's been a rough week so please be gentle :) :) :) Have a great weekend Paul ------------------------------Paul Johnson------------------------------
Hello, Does anyone know how to access the current user (userID or email) via JavaScript in a Custom Page without passing that parameter in the URL? Like gReqUID or gReqUserEmail in native QB pages. Thanks, Chris------------------------------Chris Wheatley------------------------------
Am new to Pipelines and hoping someone may be able to assist.Trying to create a pipeline that checks inbound outlook emails, then based on certain critera of email update a record.Have connected Outlook.Email subject line contains the QB record ID, and the body just contains the text I wish to push into a blanks field.Am using the Triggerd Pipeline, and Workflow is Trigger email, then update record.I set the trigger to search for something specific, but i can't seem to have the 2nd part of the workflow (QB update record) as it suggest there is nothing to search even though imn theory the record ID is being pulled from the email...Any assistance appreciated.------------------------------damien page------------------------------
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.