AnsweredAssumed Answered

Merging Field Data

Question asked by DavidR on Feb 26, 2014
Latest reply on Feb 26, 2014 by DavidR

Title

Merging Field Data

Post

     I currently have 3 fields, Lot, Block, Subdivision, and I am trying to merge them into one brand new modifiable field named Legal. However this is proving more difficult for me then expected because it needs to carry over the field name with the data but only if there is data in that field... 

     Example 1

                                                                                                                                                                                                                                   
                    

                         Field Name

               
                    

                         Data

               
                    

                         Lot

               
                    

                         1

               
                    

                         Block

               
                    

                         2

               
                    

                         Subdivision

               
                    

                         X

               

     Should Display in the new field as:  Lot 1, Block 2, X

     Example 2

                                                                                                                                                                                                                                   
                    

                         Field Name

               
                    

                         Data

               
                    

                         Lot

               
                    

                         1

               
                    

                         Block

               
                    

                          

               
                    

                         Subdivision

               
                    

                         X

               

     Should Display in the new field as:  Lot 1, X

      

      

     But I can only get example one to display as 1 2 X when I use

     Legal = Lot & " " & Block & " " & Subdivision

     I think I need to use an if rule but im not sure how it works. Hope this makes since, I would greatly appreciate any help

Outcomes