Recent Discussions
How to Calculate Completion Percentage Using Multi-Select Boxes
I’m trying to create a formula that calculates the completion percentage based on a series of multi-select checkboxes. For example, if there are four checkboxes and three of them are selected, I’d like the formula to return 75%. Is there a way to achieve this in Quickbase? Any help would be greatly appreciated! Thank you in advance!
How to fetch all apps across the Admin user account and their share permission data through APIs?
Hi Team, While exploring the Quickbase application i want to fetch the application data across the Admin User account including all the applications that are created by other users of the account. Being Super Admin I am able to see the applications of the other users from UI in the Admin console. I want to fetch this information through the API, while I am unable to find the REST API that fetches this data, is there any REST API available that fetches list of all application across the user account including the other user's apps. I tried using the XML based API and found that the API_GrantedDBs gives the apps created by the Super Admin user but was unable to give the other user's application in the list. How can I find the list of all applications across the user account including the other user's app. I am using the authorization ticket that is required to call the API. Please guide me for the same. I also require to find the users and groups that have access to the apps through the APIs. Please help me in finding the above points, if the APIs are not available is there any another workaround to get this data? Thanks.
How to manage HTTP "accounts" in Pipelines
I'm using the HTTP "Make Request" step in several pipelines to make HTTP calls from Quickbase to my applications API. The way you configure the URL and authentication information for that API is via the "Connection" where you configure an "HTTP account". I can see how to create a new "account" there, but I can't figure out where to update or delete those accounts. I've searched the Quickbase UI and couldn't find anything, and the docs didn't contain anything that I could find. I considered using "variables" to try to specify my URL and reference the variable in the "HTTP account", but that context doesn't seem to support variables, which seem like they were built for use in formulas, not pipelines. Can anyone tell me how to manage (edit, delete) my HTTP accounts used in my pipelines? Thanks!
User list fields in Pipeline
Good afternoon, I've created a pipeline that searches Table A for criteria and if it matches it will copy a User List field from Table B to another User List field in Table A. Both User Lists fields could have multiple Users selected when the pipeline runs. My first attempt wiped out any information already listed in Table A's field with the information copied from Table B, but it listed all Users that were selected. When trying to figure out how to keep the information in Table A's field while adding the information from Table B, I then found the community thread which is similar to what I'm trying to do: https://community.quickbase.com/discussions/getting-started/using-multi-select-field-in-pipelines/18991 However, when I enter {{table B User List field}} ; {{table A User List Field}} Table A's information remains, but the new information copied are placeholders rather than the User name. So it looks like When I've attempted to use the ID or Email from the User List (as found recommended in other threads) It keeps Table A's information but only lists the first User from Table B. Any other User is not copied over. Any suggestions on how to get the placeholders to actual show the User Names?
Add barcodes to PDF templates
We have an app for tracking form internal processes. There is a paper printout that will travel with a part throughout the plant. I want to add a barcode to that printout so when someone needs to update the record, they can just scan the barcode (we already have USB barcode scanners at all the computers). Is there a way to take the value of a field and create a barcode?Document Generation - Filename
I started playing with the Document Generation in Quickbase this week which is amazing! I am curious to know if there is a way to set the filename of a Document that is generated in a custom email notification from a Quickbase application? I know that when you use the Generate Document code to create the document for a record in the application, it does allow you to set the title/name of the document specifically. However, using the same option as a part of the custom email notification sends the notification with the PDF attached and named Document 1, rather than any name you specify in the code that is attached the Formula URL field.
Minimum role permission level needed to toggle/adjust notifications
Is there a way to give permission to users who are not app administrators to create and update notifications? I'd like to have my future-anticipated team be able to create and manage notifications, however it seems that my current end users who have nearly universal access to my app but are not administrators can not get to that section. If it's not possible, I'd love to suggest that to be incorporated if possible since it would not interfere with the app's architecture in any way!
