QuickBaseCoachD
Qrew Captain
Joined 6 years ago
User Profile
User Widgets
Contributions
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 iPhone73Views0likes0CommentsRe: 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 ------------------------------94Views0likes1CommentRe: New App that vendors can log in and see there metrics
Quickbase 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 ------------------------------6Views0likes0CommentsRe: 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 ------------------------------170Views0likes0CommentsRe: 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 iPad49Views0likes1Comment