9 Replies Latest reply on Aug 24, 2012 4:09 PM by schamblee

    How to split one cell into subgroups

    AnnetteVillarreal

      Title

      How to split one cell into subgroups

      Post

      I would like to split one cell into three different sections with titles. Is this possible?

        • 1. Re: How to split one cell into subgroups
          philmodjunk

          Like this?

          You have these records (each row is a record):

          Fruit    apple
          Fruit    Kiwi
          Veg     Carrot
          Fruit    Peach
          Veg     Beet

          and you want to see something like this?

          Fruit
             apple
             kiwi
             peach

          Vegetable
             carrot
             beet

          In FileMaker, we call a 'cell' a "field" or a "column".

          • 2. Re: How to split one cell into subgroups
            AnnetteVillarreal

            More like I have a field that I want split into three sections per record: see picture

            • 3. Re: How to split one cell into subgroups
              philmodjunk

              Why is the data in one field in the first place?

              Do you want the data in three different fields of the same record or in separate records in a related table? (a related table is much more flexible)

              What does this data look like in other records? Is there a consistent format that can be used to identify which part of the data goes into each 'sub group'?

              It would help to know a lot more about your database, the data and exactly what you want to do with this data that you want to split up.

              • 4. Re: How to split one cell into subgroups
                AnnetteVillarreal

                The data is all in one field because it's all contact information but from different types of companies. In each record, it is split into three types and follows this consistent format so that you can easily identify which sub group it belongs to. It would be nice to split into three sections within one recrod to keep the table condensed. Within each subgroup - there can be autofill settings so that if I already have entered in Production Company "A", I can see all the different records under the same Production Company.

                • 5. Re: How to split one cell into subgroups
                  philmodjunk

                  It still seems simpler to put this data into separate fields in the first place rather than have to make this special effort to separate them out after the fact.

                  It looks like you have 3 sets of data separated by two returns between each item. Does this mean that you want three fields with data like this?

                  Production Company  | Agent  |   Misc.  (vertical lines mean separate the fields)

                  Or is the section 1:, Section 2: and Section 3: data also to be included in the separate fields?

                  Or have you just shown the "header" info and the contact info is what is not shown in your example and would be located in the blank space between the text shown?

                  And apologies but I don't follow what you mean by "keep the table condensed" nor do I yet see any advantages to using separate fields in the same record while I do see some possible disadvantages to doing so when compared to using a related table for this info.

                  What you want can be done and fairly easily. It's just that there is a large number of variables to parse to figure out the best implementation that both does what you want and that also handles all the specific details of how the data is stored in this field.

                  • 6. Re: How to split one cell into subgroups
                    AnnetteVillarreal

                    As of now, the table fits perfectly on one page when printed - that's what I mean by keeping the table condensed. Adding more fields would compromise space because we print this out constantly. 

                    I have shown the "header" info and the contact info is not shown but would be located in the blank space.

                    • 7. Re: How to split one cell into subgroups
                      philmodjunk

                      Yet it's much easier and less prone to problems due to data entry errors if you enter the data into separate fields and then use a calcualtion field to combine them for printing purposes. The calculation for combining the data would be quite simple.

                      Define your three separate fields, put the data into them and then use this calculation for your print layout:

                      List ( "Section 1: Productioncompany" ; ProductionCompany ; "Sectoin 2: Agent" ; Agent ; "Section 3: Misc." ; Misc )

                      This puts each "header" on it's own line and the data that goes with it on the next line. There are many other possible variations to this.

                      If you still decide you want to keep your data combined like this,

                      GetValue ( Contact ; 2 )

                      Will return the production Company contact.

                      GetValue ( Contact : 4 )

                      returns the agent

                      and

                      GetValue ( Contact ; 6 )

                      returns miscellaneous

                      But if someone leaves out a return or hits it an extra time while entering the data, you won't get correct results.

                      • 9. Re: How to split one cell into subgroups
                        schamblee

                        GetValue() is the name of the function to get the value that you wanted.  Contact is the field. The # is the number of the item you want.

                         

                        GetValue(“London¶Paris¶Hong Kong”;2) returns
                        Paris