RossonLong1
Qrew Cadet
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Seeking interim quickbase support
Hi s_rfor our team at Discover NoCode can take on some work! Feel free to email me directly or message me here on the Khoros platform. There are lots of little vendors out there you could also reach out to. If our team isn’t a good fit we ought to be able to get you in touch with someone who is. 💪🙌 rosson@discover-nocode.com88Views1like0CommentsRe: The Discord Qrew - What's It All About?
Lets gooooo!!! This community of people on Discord has actually changed my life. I've made friends, found solutions to problems, started coaching people on Quickbase and found multiple new clients and job opportunities. For people looking for real-time back and fourth with amazing members of the community, without needing to wait for an email or refresh your screen to see if someone has responded, this is the place for you.97Views1like0CommentsRE: Multiselect field values with customized bullet colors
Answering this question here: https://discord.com/channels/996480210075660380/1049980076990681199/1090644325047730229 To see the answer in Quickbase Community Discord join the Community and ask questions there whenever you'd like as well through this invite link: https://discord.gg/GEZ42k9qe4 ------------------------------ Rosson Long ------------------------------2Views0likes0CommentsRe: Code Pages: Creating Printable ID Badges.
I don't know why I hadn't thought of building the HTML into a formula field in the first place! This is a brilliant idea! The only math I would need to do for that is formulas looking to see if the Employee ID# is divisible by 8 or has a trailing decimal of .875 (7/8) for page breaks and divisible by 2 for rows. Eventually they will want to remove employees that are no longer part of their company, so the challenging part will be actually just be "numbering" the employee records with a second numeric variable that populates the pages without employees who have been let go. Thanks for sending over all this stuff! Super helpful! I'll try it all out and come back here and post the results later. ------------------------------ Rosson Long ------------------------------7Views0likes0CommentsCode Pages: Creating Printable ID Badges.
Hello! I am working on a code page that will allow our users to quickly design and print all of their employee ID badges. The formatting is done, I am now in the process of learning how to: 1. Repeat the HTML structure over and over until every employee ID badge is listed. 2. Connect the data in the HTML structure to the employee's table to draw upon the QB data to generate the content on the badges. Here is a link to the code page I have been working on with dummy data/content to help visualize what I am working on: http://old2.lztek.io/tests/codepage.html Linked in the attachment is the codepage itself with comments on what divs and tables need to be repeated. Here is an example of a single badge ID: <table style="width:100%;"> <tr> <td class="left"> <img class="logo" src="company-logo.png" alt="Company Logo"> <br> <div class="name">John Doe</div> <div class="job">IT Director of Constant caring and health.</div> <div class="empid">ID#:120</div> <br> <img class="qr" src="qr-code.jpg" alt="QR Code"> </td> <td class="right"> <div class="company-name">LZTEK, LLC</div> <br> <img class="portrait" src="portrait.jpg" alt="John Doe Portrait"> </td> </tr> </table> Any help is appreciated! Thank you! ------------------------------ Rosson Long ------------------------------31Views0likes3CommentsMulti-Select Text filtering based on user permissions
We have a table that is filtered based on your role and a Multi-Select Text that is grabbing it's drop-down data from the filtered table. However, rather than being a filtered drop down based on your role the Multi-Select Text field is acting like an administrator in the sense that it shows every possible option from the filtered table that it is pulling from. Example of expected results: John visits the table "Tags." He can see "OLD" and "NEW" Tim visits the table "Tags." He can see "Fresh" and "Expired" In a separate table when John makes a record we have a multi-select text field that is pulling from the filtered table. John should only see "OLD" and "NEW" and when Tim makes a record he should only be able to see "Fresh" and "Expired" Problem & actual results: Currently the Multi-Select Text drop-down box does not filter based on the permissions in the table it is pulling from based on the user creating the record. Tim and John both see "OLD", "NEW", "FRESH", and "EXPIRED" in the Multi-Select Text field rather than only seeing the results based on their filtered permissions. Is there any way to make sure that those multi-select text fields filter themselves based on what the user has access to in the table that it is pulling its information from? ------------------------------ Rosson Long ------------------------------Filtering User List Formulas
Hi! I am trying to find a way to filter a user list. Fields: User (single user field) User-List (multiple users field) Filtered User-List (multiple users field) Example: User has: U1 User-List has: U1;U2;U3 Goal: Filtered User-List has: U2;U3 Problem: I've tried stuff like ToUserList( Left([User-List],[User]) Right([User-List],[User]) ) But User-Lists don't have the same rules as normal text fields and therefor I can't modify them like I would a text field. I also can't figure out a way to turn them into text fields, filter them, and then back into QuickBase Users. (If that's even possible). Any thoughts on how to filter these User-Lists in the way I presented above? ------------------------------ Rosson Long ------------------------------22Views0likes3CommentsRe: Creating a URL to grid edit children. (Like a report link but grid edit rather than view).
Making them editable in the form looks like the best solution. In fact, it's probably better than what we were doing before. Makes way more sense. Very good call. Thank you Mark!! ------------------------------ Rosson Long ------------------------------13Views0likes0Comments