2 Replies Latest reply on May 7, 2016 1:06 PM by erolst

    Artist needs help making progress chart

    80tim

      Hello,

       

      I hate to come on here expecting help, but I haven't made progress on creating a chart based on radio buttons after spending the last week researching tutorials, looking through the forums at previous posts and trying to grasp how calculations work.

       

      I'm an artist that uses filemaker during the day at work for assets being assigned to me

       

      I downloaded the trial of filemaker at home, in hopes of it improving my ability to track individual art files (assets) and their current state of progress on my personal art projects.

       

      Example of art assets/records I'm tracking.
      CouchB
      CouchC
      TableA

       

      Each asset is at a different stage of progress. Here is my current list of stages:

       

      Not Created

      Proxy

      Model Scale

      Model

      UV

      Texture

      Rig

      Light

      Redshift Renders

      UE4 Integration

      Asset Complete

       

       

      What I've got so far:

      Created a field called TSH_Value. Type set to "text".

      Control Style: Radio Button Set
      Values from: Current Stage List


      Custom values of "Current Stage List":

      Not Created

      Proxy

      Model Scale

      Model

      UV

      Texture

      Rig

      Light

      Redshift Renders

      UE4 Integration

      Asset Complete
      RadioButtons_CouchC.jpg

       

      What I'd like to have is the ability to show a graph of all assets along with their Current Stage affecting the Percent Complete box.
      Based on which radio button is selected, I'd like the following percentages to be reflected in the Percent Complete box at the bottom of the image or more importantly, reflect the percentage on a graph (I'm a visual person and seeing which assets are furthest behind in progress is ideally what I'm looking for). Back in college I did a similar type of tracking by just color coding stages on an excel sheet. It was very archaic, but seeing a screen of colors representing the progress helped me stay on top of art assets that I was loosing track of mentally.

       

      The stages and their related percentage I want to associate them with:

       

      Not Created = 0%

      Proxy = 10%

      Model Scale = 20%

      Model = 30%

      UV = 40%

      Texture = 50%

      Rig = 60%

      Light = 70%

      Redshift Renders = 80%

      UE4 Integration = 90%

      Asset Complete = 100%

       

       

       

      I don't know where to start. I'm convinced I'm supposed to be making a calculation but then I don't know if I should be using an "If" statement, "Get"
      or what. I feel pretty lame coming on here and admitting that, but I naively thought the software would be more readily able to do this without needing to understand scripting. I've been meaning to get around to scripting, but my current projects don't require it so I've been waiting until the current projects die down.

       

      Any help would be greatly appreciated.

       

      Thank you,

       

      *Also, I've been meaning to get on CodeAcademy to learn scripting. Is there a language on there that would help me understand Filemakers calculation language?

        • 1. Re: Artist needs help making progress chart
          siplus

          It's just a calculation field using a choose or a case.

           

          please upload what you've done so far and I'll start from there, it's faster than explaining.

          • 2. Re: Artist needs help making progress chart
            erolst

            Try

             

            Let (

              status = TSH_Value ;

              Case (

                 not IsEmpty ( FilterValues ( status ; "Asset Complete" ) ) ; 100 ;

                 not IsEmpty ( FilterValues ( status ; "UE4 Integration" ) ) ; 90 ;

                 not IsEmpty ( FilterValues ( status ; "Redshift Renders" ) ) ; 80 ;

                 // fill in the blanks …

                 Not IsEmpty ( FilterValues ( status ; "Not Created" ) ) ; 0

              )

            )

             

            You could on the other hand do it in reverse: change your field to a number field, create a value list with values from 0 … 10, use that to format your radio button set, put the stage names as text objects next to the numbers and enter the percentage.

             

            Getting the correct stage name would then simply be

             

            GetValue (

              ValueListItems ( "" ; "Current Stage List" ) ;

              ( percentageField + 10 ) / 10

            )

             

            and there are some even simpler possibilities, but at your (no pun intended) stage, the above should do.