11 Replies Latest reply on Apr 8, 2009 11:33 AM by mgxdigital

    Changing Field Color

    mgxdigital

      Title

      Changing Field Color

      Post

      I have a field that changes colors when closing my database.

      It always goes back to the color it was the very first day I made it, and I keep changing it back everyday.  But still when I close my database and reopen it, it's back to the origional color.

       

      Does anyone know why this is happening and how to get it to stop?

        • 1. Re: Changing Field Color
          raybaudi
            

          Robin

           

          from another your post I saw that you are on FMP 10.

           

          Are you using conditional formatting to give a color to that field ?

           

          If yes, which is the formula ?

          • 2. Re: Changing Field Color
            mgxdigital
               Yes, I am using Filemaker 10, but it is not a conditional formula. It is actually a container field that I am inserting color blocks into because it has repetitions for different days of the week.
            • 3. Re: Changing Field Color
              raybaudi
                

              Is it a calculated container field ?

              Which is the calc ?

               

              • 4. Re: Changing Field Color
                mgxdigital
                  

                No it is not.

                It is a global container field with 7 repetitions.

                • 5. Re: Changing Field Color
                  raybaudi
                    

                  robin wrote:

                   

                  It is a global container field with 7 repetitions.


                  Is that DB hosted ?

                   

                  If yes, you need to avoid globals fields and to have a mono-record related table.


                  • 6. Re: Changing Field Color
                    mgxdigital
                      

                    What does hosted mean?

                    It is shared on a network?

                     

                     

                    If I make the container field not global, will it mess up everything that I have in it?

                    • 7. Re: Changing Field Color
                      raybaudi
                        

                      robin wrote:

                      What does hosted mean?

                      It is shared on a network?


                      Yes.

                       


                      robin wrote:

                       

                      If I make the container field not global, will it mess up everything that I have in it?


                       

                      Yes, everithing that is inside that global field willl mess up, so copy each repeatition into the new field before deleting it.

                      • 8. Re: Changing Field Color
                        mgxdigital
                           This did not work, because now I can not add a different color to each repition like I could before. I still need to be able to do this.
                        • 9. Re: Changing Field Color
                          raybaudi
                            

                          robin wrote:
                          This did not work, because now I can not add a different color to each repition like I could before. I still need to be able to do this.

                           

                          robin,

                           

                          the only difference from a global field and a 'normal' one is that the global can be seen from every records ( and every tables ) and the 'normal' is a property of the single record. 

                           

                          If you could insert different color into each repeatition of a global field, you'll be able to do the same thing with a 'normal' repeating field.

                           

                          BTW: I'm pretty sure that you can use the conditional formatting option.


                          • 10. Re: Changing Field Color
                            philmodjunk
                              

                            You can make global fields work for you when they are hosted. I use them all the time. You just have to keep in mind that global fields behave differently when hosted than when the database is used in single-user (unshared) situtations.

                             

                            Any client who accesses the database, can only make temporary changes to the contents of global fields. Other clients will not see these changes and vice versa. Each client works with a "virtual copy" of any global fields. To make a permanent change to the contents of a global field, open the file as the host and make the change.

                             

                            Example:

                             

                            1. Use FMServer to select and close the file.
                            2. Use Filemaker Pro to open the file.
                            3. Change the contents of the global file.
                            4. Quit filemaker Pro.
                            5. Use FMServer to re-open the file for serving.
                            6. Log On as a client and you'll see that the global field change made in step 3 now persists.

                             

                            • 11. Re: Changing Field Color
                              mgxdigital
                                 You're awesome Phil! Worked great!