Filemaker Help me plz

Discussion in 'Mac Apps and Mac App Store' started by xelos, May 3, 2006.

  1. xelos macrumors newbie

    May 3, 2006

    I just started working with FM pro and i need some help.

    I have made a database but have a problem figuring out some stuff.

    I'd like to make a dropdown-list which shows custom values in different colours.

    do i have to make a separate db with values there?

    or maybe there is a script which will generate a colour for custom values

    plz help me out
  2. ahunter3 macrumors 6502

    Oct 15, 2003
    Do you mean you want to be able to click on a field and have a dropdown list appear with the values in the dropdown list showing up in different colors? (see screen shot)

    That is not a FileMaker native feature. (In fact, native dropdown lists appear in the formatting of the field to which they are attached, so you can't display different values in different fonts, font sizes, font styles, colors, or anything of the sort)

    If it is of sufficient importance to you, you can create such an interface but you'll have to create your own replacement for the native dropdown value list in order to do so.

    Quick -n- dirty example: Create a duplicate of the layout on which you wish to have the value list operate. On the duplicate layout, superimpose a set of global text fields — as many fields as your actual valuelist (is likely to) have values, placed in a vertical stack so as to look like a value list is dropping down from the field to which the valuelist would be attached. Remove all fields from the tab order except the global fields I just described. Create a script that sets the colors and contents of the global fields to the values of the applicable value list plus the colors you want to use. e.g. —

    Set Variable [ $ValueListItems; Value:"¶"&ValueListItems ( Get(FileName) ; "MyValueList" )&"¶" ]
    Set Variable [ $Rep; Value:1 ]
    Go to Layout [ original layout ]
    Go to Field [ ]
    Exit Loop If [ IsEmpty(Middle($ValueListItems; Position($ValueListItems; "¶"; 1; $Rep)+1; Position($ValueListItems; "¶"; 1; $Rep
    +1)-Position($ValueListItems; "¶"; 1; $Rep)-1)) or not IsValid(Middle($ValueListItems; Position($ValueListItems; "¶"; 1; $Rep)
    +1; Position($ValueListItems; "¶"; 1; $Rep+1)-Position($ValueListItems; "¶"; 1; $Rep)-1)) or $Rep > 10 ]
    Set Variable [ $Red; Value:Case($Rep=1; 244;
    $Rep=2; 245;
    $Rep=3; 0;
    $Rep=4; 0;
    $Rep=5; 255;
    $Rep=6; 120;
    $Rep=7; 255;
    $Rep=8; 0;
    $Rep=9; 120;
    $Rep=10; 255) ]
    Set Variable [ $Green; Value:Case($Rep=1; 11;
    $Rep=2; 245;
    $Rep=3; 254;
    $Rep=4; 5;
    $Rep=5; 5;
    $Rep=6; 75;
    $Rep=7; 75;
    $Rep=8; 255;
    $Rep=9; 120;
    $Rep=10; 120) ]
    Set Variable [ $Blue; Value:Case($Rep=1; 5;
    $Rep=2; 0;
    $Rep=3; 0;
    $Rep=4; 255;
    $Rep=5; 255;
    $Rep=6; 120;
    $Rep=7; 120;
    $Rep=8; 255;
    $Rep=9; 0;
    $Rep=10; 0) ]
    Set Field [ TextColor ( Middle($ValueListItems; Position($ValueListItems; "¶"; 1; $Rep)+1; Position($ValueListItems; "¶"; 1; $Rep
    +1)-Position($ValueListItems; "¶"; 1; $Rep)-1) ; RGB ( $red ; $green ; $blue ) ) ]
    Go to Next Field
    Set Variable [ $Rep; Value:$Rep + 1 ]
    End Loop
    (code text assumes FileMaker 8; you can do this in FileMaker 7 but you'll need global fields to substitute for all the variables as Fm7 didn't have "Set Variable" as a script option; code text assumes Value List is limited to 10 items max, adjust accordingly for a longer possible VL)

    Then, for each global field, create a script that sets the original field to the value clicked on and return the user to the original layout, and attach those scripts to the applicable global field as buttons.

    Now, if you just want a valuelist consisting of color NAMES, which, upon being selected, changes the color of the field as displayed, etc.,. that's easier and more natively supported.

    Attached Files:

  3. ahunter3 macrumors 6502

    Oct 15, 2003
  4. xelos thread starter macrumors newbie

    May 3, 2006
    I did

    Thank you for helping me out... this helped me a lot tho i didnt get back at you, plz dont think i am not gratefull.

    thnx for your time and effort
  5. ahunter3 macrumors 6502

    Oct 15, 2003

Share This Page