RubyKapil
Qrew Trainee
Joined 6 years ago
User Profile
User Widgets
Contributions
Re: Using asterisk * at the end of field name
For the field name itself - when creating or updating the field name, I want to add an asterisk to the end of the field name. If field name was called ABC, I want to rename to ABC*. ------------------------------ Ruby Kapil ------------------------------5Views0likes1CommentRe: Pie Pieces as Buttons on Dashboard Assistance
Mark and Adam, I am so grateful for your expert advice. I will test out the two methods. Both solutions open up the door to greater creative options for dashboard. Thanks for taking the time to help me. I'll let you know how it goes. ------------------------------ Ruby Kapil ------------------------------2Views0likes0CommentsRe: Filter Across Similar Fields only shows Field 1 values
Mark and Don, thanks for the help - here's some additional info -- Record 1: Company 1=Red, Company 2 = Green, Company 3 is blank, Company 4 is blank Record 2: Company 1=Yellow, Company 2 = Red, Company 3 is Yellow, Company 4 is blank Record 3: Company 1=Yellow, Company 2 = Green, Company 3 is Blue, Company 4 is blank The formula field will be used as a Dynamic Filter in a Table Report. The filter choices will look like this: Blue Green Red Yellow In the Dynamic Filters on the left side of my Table report, If I select Blue, it will filter the report to show Record 3. If I select Green, it will filter the report to show Record 1 and Record 3 If I select Red, it will filter the report to show Record 1 and Record 2 If I select Yellow, it will filter the report to show Record 2 and Record 3. All the solutions I have tried have resulted in showing me only the value that is found in Company 1, so if I select Red, it will only show me Record 1, and not Record 2. ------------------------------ Ruby Kapil ------------------------------1View0likes4CommentsRe: Filter Across Similar Fields only shows Field 1 values
Thanks Don. It will filter to a single value, but the filter is only capturing those records where Company 1 is Yellow. If Company 2 is Yellow, it will not show up in the list of records for Filter = Yellow. ------------------------------ Ruby Kapil ------------------------------1View0likes6CommentsRe: Filter Across Similar Fields only shows Field 1 values
Thanks Mark. The result I want is a Single value to show in the filter result, Green if any of the 4 companies have Green, Red if any of the 4 companies have Red. Blue, Green Red Yellow The List formula above is similar to my Company1234 field in that the filter results are: Green Green, Red Red Red, Yellow ------------------------------ Ruby Kapil ------------------------------1View0likes1CommentFilter Across Similar Fields only shows Field 1 values
Need some formula help -- 4 Multi-Choice fields in same table: Company 1, Company 2, Company 3, Company 4. Each of these 4 fields has the same set of Choices: Red, Blue, Green, Yellow. Each record can have 0-4 Company fields filled in. I need a filter to identify if any of the 4 fields has "Yellow", then filter will show word "Yellow". Or if any of the 4 has "Red", show the word "Red". a. I created concatenated field Company1234 and then created a Formula Text field If (Contains([Company1234, "Yellow")=true, "Yellow", Contains([Company1234, "Red")=true, "Red", Contains([Company1234, "Blue")=true, "Blue", Contains([Company1234, "Green")=true, "Green","") Doesn't work the way I need it to - seems to only filter to show if Company 1 is the value. b. I tried another Formula Text field If((Contains([Company 1], "Yellow")=true or Contains([Company 2, "Yellow")=true or Contains([Company 3], "Yellow")=true or Contains([Company 4], "Yellow")=true), "Yellow", (Contains([Company 1], "Red")=true or Contains([Company 2, "Red")=true or Contains([Company 3], "Red")=true or Contains([Company 4], "Red")=true), "Red", etc This also filters if Company 1 has the value. This is part of an older app which was setup as a large flat file and I am trying to create some filters to check data while I transition it to Parent Child structure. ------------------------------ Ruby Kapil ------------------------------1View0likes11Comments