Forum Widgets
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!
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?
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.
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?
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!
