ContributionsMost RecentMost LikesSolutionsRe: App Category Limitations Mark Shnier Sent from my iPad Re: Syntax Error Correct, if you make the send letter,field, a multiple-choice, say with yes, and no as the choices, then that is a text result, and could be used in the formula. But you understand that the formula field itself will not be editable Mark Shnier sent from my iPhone Re: Is there a way to add a Custom Header to a report?I often make a Report Break Header Rich Text formula field and use that as my first Group By on a table report. Since the calculated result is the sae for each row, it looks like an extra header. But below the field names. But the HTML allows for a lot of formatting for size and color. List(" ", "<font color=red>Select for<font color=blue>" & " Door: " & "<font color=red>" & [Focus Outbound Load Door], "<font color=blue>" & [Focus Outbound Load Trailer Identification], "<font color=black>", " Weight: " & ToText(Round([Focus Outbound Load Total Weight (Lbs)])) ) ------------------------------ QuickBaseCoach Dev./Training ------------------------------ Re: New App that vendors can log in and see there metricsQuickbase allows EOTI access "Everyone On The Internet". I will post some links to help articlers. I suggest that you send each EOTI Vendor a link to a record and on that record include embedded report links of any reports they need. tell then to bookmark that link. There is also a technique to disguise the Record ID# so that users cant as easily guess into other clients records. here is an example of an emailable button which can be used in an email notification to the Vendors var text DisplayRecordWithObsureRID = URLRoot() & "db/" & Dbid() & "?a=dr&r=" & QB32Encode([Record ID#]); var text ButtonWords = "Click here to display your vendor Information"; var text URL = $DisplayRecordWithObsureRID; // Begin button style var text bgcolor = "#34A853"; // green var text txtcolor = "white"; var text style = "style=\"text-decoration: none; text-align: center; background:" & $bgcolor & "; border-radius: 5px; padding: 8px 10px; color: " & $txtcolor & "; display: inline-block; font-size: 150%; font: normal 700 24px/1 \"Calibri\", sans-serif; text-shadow: none;"; // End button style "<a " & $style & " href=" & $URL & ">" & $ButtonWords & "</a>" Here are links to some articles and discussions https://community.quickbase.com/communities/community-home/digestviewer/viewthread?MessageKey=0a68be86-7f1a-4d56-aa84-07396d86541f&CommunityKey=157a0aac-5622-4134-8b0a-ae35c9b68e53&tab=digestviewer#bm0a68be86-7f1a-4d56-aa84-07396d86541f https://community.quickbase.com/blogs/bree-mackey1/2021/03/26/eoti-but-make-it-s afe https://help.quickbase.com/user-assistance/share_with_everyone_on_internet.html ------------------------------ QuickBaseCoach Dev./Training ------------------------------ Re: Format text colors and backgrounds in Multi select field@Kelly Lyons if you post your current code and a screen shot of what is looks like on a record and explain the change in the formatting that you are looking for, I can have a look. ------------------------------ QuickBaseCoach Dev./Training ------------------------------ Re: Use Copy Master Detail Record and Data Validation I suggest making a formula checkbox field which will be true if the name of the project (your record) starts with "Copy of" Then have a form rule which will abort the save if that checkbox is true. Mark Shnier Sent from my iPad Re: If/Then Formula Statement - How to display an updated/corrected email address? Yes. That is where the functions are. Here us the IF help text. https://login.quickbase.com/db/6ewwzuuj?a=dr&rid=75&rl=d7 Mark Shnier sent from my iPhone 8 Re: Hour Calculation Please contact me directly by email using the email address on my signature and I will tell you how to invite me. Mark Shnier sent from my iPhone 8 Re: Automations/user Roles That is exactly why I had my Rules based on not being in the role manger or bring on the role manager. I assumed all managers were also in the Role submitter Mark Shnier sent from my iPhone 8 Re: Automations/user Roles Seems impossible. Are the automations definitely turned off. Mark Shnier sent from my iPhone 8