ContributionsMost RecentMost LikesSolutionsRe: Creating a summary report based on multiple columnsWe do not. Our assignments are just based on the users and not stored separately in a table. Three of the fields are set up like the below screenshot. The fourth is similar, but you can select more than one person. Creating a summary report based on multiple columnsIn our project management app, each team member can be assigned to a project as team 1 lead, team 2 lead, team 3 lead or additional team. I need to create a summary report that shows each team member and how many total projects they're assigned to. So basically "find each person and count the number of projects in which they are listed in field1, field2, field3 and field4." I have a table report that shows this per person, but I need the summary.Re: Formula URL Button in Email Produces Multiple ResponsesI would still need to be able to set the status (on one table) and add the log (would then be on another table) all from one formula URL. The secondary table wouldn't be much use for us because the approvals come from outside collaborators (non-QuickBase users), so they all get logged as "AnonymousFormula URL Button in Email Produces Multiple ResponsesIn our project management system, we have a project status combined with approval process. When we set a project to "With Collaborator," an email is sent to the external collaborator (non-QuickBase user) with a link to the proof and two links - "Proof Approved" or "Changes Requested." The "Proof Approved" and "Changes Requested" links are built from Formula - URL fields. If the user clicks "Proof Approved," it sets the project status to "Approved - Ready for Final Approval" and logs the approval in a text field with the current date and time. "Changes Requested" does the same thing, except the status is set back to "In Progress," the changes requested is logged and the user is directed to a special form requesting more information. This works great, except when the user clicks either link, the above actions happen anywhere from 1 to 4 times. So the log will show Approved Approved Approved. How do I prevent this behavior? It becomes confusing for our collaborators because they see the project was approved several times.Re: Remove disallowed characters from a text fieldThis is perfect! Thank you so much!Remove disallowed characters from a text fieldOur app has a [Project Name] field in which our users can input whatever project name they like. We then have a [Project ID] field that uses 9 Part([Project Name],1," ") formulas to combine the first words of the project name without spaces: Right(ToText(Year(ToDate([Date Created]))),2) & Right("0" & ToText(Month(ToDate([Date Created]))),2) & Right("0" & ToText(Day(ToDate([Date Created]))),2) & If(Length([Master Project Abbreviation]) > 0,"-" & [Master Project Abbreviation]) & "-" & If(Length([Department Abbreviation]) > 0,[Department Abbreviation],[Collaborator Department Abbreviation]) & "-" & Trim( Part([Project Name],1," ") & Part([Project Name],2," ") & Part([Project Name],3," ") & Part([Project Name],4," ") & Part([Project Name],5," ") & Part([Project Name],6," ") & Part([Project Name],7," ") & Part([Project Name],8," ") & Part([Project Name],9," ") ) This project ID also becomes a folder name in our file storage. However, our file storage can't handle characters like quotation marks, colons, semicolons, etc. Is there a way to strip disallowed characters when reading data from a text field?Show name instead of email address in notification We're sending notifications to external users who are more comfortable seeing a name instead of an email address in the From field. Is there a way to have QuickBase notifications show as: My Name (via QuickBase) instead of: myemail@domain.com (via QuickBase) ? Can I have my collaborators dropdown (comes from another table) in my projects form only show ones matching the specified department and don't have inactive checked? My collaborators table has all of the information about our "clients," including a checkbox to mark them inactive. Our projects form has two dropdowns... the first is for department (user selects first) and then the collaborators list changes to match only those who match the selected department. I want it to match collaborators in the selected department who do NOT have the inactive checkbox checked.