February 25, 200322 yr Hi All I'm relatively new to filemaker, and now I have to pull it out of the bag. I want to have either a pull down menu or radio buttons, with 5 entries. I have designed a layout, and upon choosing/selecting 1 of the 5 choices I would like to link that to a client logo, so the logo will automatically be shown on my layout... why can't I seem to get this to work? apart from a complete lack of common sense! All help greatly recieved. Az
February 25, 200322 yr First create an repeated container field gLogos. Put each logo img in proper repetition. Now define calculated field cLogo rsult container as case ( choice=choice1, GetRepetition(gLogos,1), choice=choice2, GetRepetition(gLogos,2), choice=choice3, GetRepetition(gLogos,3), choice=choice4, GetRepetition(gLogos,4), choice=choice5, GetRepetition(gLogos,5), ) dj
February 25, 200322 yr Author Thanks dj I'm so new, that I don't understand... where does the field "choice" come from? Az Pulling my hair out....
February 25, 200322 yr As you said: I want to have either a pull down menu or radio buttons, with 5 entries. Well choice should be the name of the above field. Dj
February 25, 200322 yr Author Ok I got that, I tought filemaker was simple -) I can't get this working Case ( logo_selecta=logo_selecta1, GetRepetition(gLogos,1), logo_selecta=logo_selecta2, GetRepetition(gLogos,2), logo_selecta=logo_selecta3, GetRepetition(gLogos,3), logo_selecta=logo_selecta4, GetRepetition(gLogos,4), logo_selecta=logo_selecta5, GetRepetition(gLogos,5), ) logo_selecta is the name of the field I use for selecting the logo "Either an operator was omited, this function cannot be found or "(" was not expected here." Any clues?
February 25, 200322 yr Hi , You had a couple of errors in you calculation. One, you need to put your text logo_selecta1, etc. in quotes as shown below and to, you had one too many commas in your calc at the bottom after gLogos,t) Case( logo_selecta="logo_selecta1", GetRepetition(gLogos,1), logo_selecta="logo_selecta2", GetRepetition(gLogos,2), logo_selecta="logo_selecta3", GetRepetition(gLogos,3), logo_selecta="logo_selecta4", GetRepetition(gLogos,4), logo_selecta="logo_selecta5", GetRepetition(gLogos,5) ) HTH Lee
February 25, 200322 yr Also, I should have said, just copy my calculation and replace your own, as it should be what you need. Lee
February 25, 200322 yr Author Hi Lee God only knows, I've made the corrections, but keep getting the same error. Az -|
February 25, 200322 yr Hi Wilse, This may be stupid, but.... What is the result of your calc ? Text, number, Image,...
February 25, 200322 yr Author Hi DI LUCA I would like it to be an image... I wanted to create A field with 5 radio/checkboxes, that represent my 5 clients. Once selected, say button 4, this would tell my layout to use "clients4" logo. I have stored these logos in a repeating container, so far so good. I have defined my "logo_selecta" field with radio buttons and made it a member of a value list (not sure if this is right?) where I have defined a value list, with the names of my five clients.... with me so far? What I can't get right is the calculation to use "client4's" logo after clicking the radio button. I think I may have bitten off more than I can proverbially chew!.. oops I have tried the scripts above, but none of them work properly... or maybe it's me? Is this enough detail? Az :-(
February 25, 200322 yr You want it to be an image, but did you define your calc to be "image". Don't take me for a fool. It happens...
February 25, 200322 yr Hi Az, Here is a little sample file (I tried to use your field names and descriptions), HTH Lee Sample4AZ.fp5.zip
February 25, 200322 yr Author ..."calculation result is a container" is this the correct thing to do? Az
February 25, 200322 yr Author And the winner is ...... . . . . . . . . . Lee Smith, c'mon down It works at treat!, same time tomorrow, for my next project? Thanks everyone, djgogi, DI LUCA
February 26, 200322 yr Author ooops... The problem was, I hadn't correctly specified the value list name. As for the prize, well you get the chance to answer this questions... lol Is it possible to have a radio button, that will carry it's selection through to 1 of 5 layouts? ie I have the a radio button allowing logos 1-5 to be choosen. I would then like another radio button, with "choice" 1-5. When I have finished entering other fields in the record, I currently click a button, that then goes to a "layout". The button uses "go to layout" command, how can I control this so that if "choice" 3 is selected on the radio button, I can steer the user to "layout 3" instead of "go to layout"? Is this possible easily, or is this like "pushing water uphill"? Sorry for imposing.... again!
February 26, 200322 yr Author me again Please ignore my last post, as I've managed with the help of this forum to sort this out.! A surprise to even myself, my learning curve, has just got One step smaller!! Thanks again everyone!
Create an account or sign in to comment