4 Replies Latest reply on Feb 26, 2014 11:14 AM by DavidR

    Merging Field Data

    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