Rangoon

Hi Comment, RE" congratulations, you have discovered a bug I always new I had some developer genes in me somewhere. I'm sure that Filemaker will want to enrich my life with a check for "Services Rendered" and I want you to know whatever the amount, there will be a 60/40 split. Yes, you get the 60 as its only right to yield to brilliance!

Hi again Comment, I went back to my calculation after receiving your post but I can't figure out exactly what the "You must have a semicolon after each result inside the Choose() statement, except the last one." means or where I would put the semicolons. Since the calculation I have works, is there any reason to change it? Thanks again for your help.

Yes the percentages are constant and will not change over time. If that calculation was "quick and dirty" I don't think I want to see "slow and clean" wow!

Thanks so much Comment, I had figured out how to set up the conditional field prior to your post but the Calculation was a different thing. I tried to follow what you did and was getting nowhere but frustrated. I was just ready to come back and plead for more help when I dawned on me and here's it is. Let ( [ trigger = Extend ( Yr ) ; //this is optional; ensures refresh of conditional formatting when YEAR is modified. d = Choose ( Get ( CalculationRepetitionNumber ) - 1 ; 1 - .35 ; ( 1 - .35 ) * ( 1 - .18 ) ; ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) ; ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) ; ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) * (1 - .05) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) * (1 - .05) * (1 - .04) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) * (1 - .05) * (1 - .04) * (1 - .04) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) * (1 - .05) * (1 - .04) * (1 - .04) * (1 - .03) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) * (1 - .05) * (1 - .04) * (1 - .04) * (1 - .03) * (1 - .03) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) * (1 - .05) * (1 - .04) * (1 - .04) * (1 - .03) * (1 - .03) * (1 - .02) ( 1 - .35 ) * ( 1 - .18 ) * ( 1 - .1 ) * ( 1 - .07 ) * ( 1 - .06 ) * (1 - .06) * (1 - .05) * (1 - .05) * (1 - .04) * (1 - .04) * (1 - .03) * (1 - .03) * (1 - .02) * (1 - .02)) //... ] ; Extend ( MSRP ) * d ) I know this may be old hat for you guys but I must admit I did a little "Mexican Hat dance"! Thank you very much

Hi Comment, First let me thank you for your help. The calculation is working but of the 14 repetition Fields only repetition 1 thru 5 are filled in with the correct numbers, the repetition 6 thru 14 are empty. I don’t know where to “format the field conditionally to highlight”. Min ( Year ( Get ( CurrentDate ) ) - YourTable::YEAR + 1 ; 14 ) = Get ( CalculationRepetitionNumber ) Sorry about my math error on my earlier post, I should have double checked it. Am I correct that I do not need fields Yr1 through Yr13? Thank you

Hi Comment, I hope this helps. Year 2014 MSRP $365,700.00 SDISC $237,900.00 ($ 365,700.00 - 35% of MSRP $127,800.00) YR1 $195,078.00 (SDISC $237,900 - 18% of Yr1 $42,822.00) And the same basis is used for each proceeding year.

Hi Comment, Yes all of the percentages are constant for all records. The discount is the common discount applied to each unit regardless of MSRP. I'll post a worked-out example as you requested. Thank you for your hep.

I’ve been trying to figure this out and not ending up where I want to be. Here’s my dilemma. I need to set up a depreciation schedule based on known percentages that look like this. YEAR = Entry field of year MSRP = Entry field of $ MSRP (this field and all following fields are $ amounts) SDISC = This is a 35% automatic discount off of MSRP YR1 = This is an 18% depreciation the 1st year YR2 = This is a 10% depreciation the 2nd year YR3 = This is a 7% depreciation the 3rd year YR4 = This is a 6% depreciation the 4th year YR5 = This is a 6% depreciation the 5th year YR6 = This is a 5% depreciation the 6th year YR7 = This is a 5% depreciation the 7th year YR8 = This is a 4% depreciation the 8th year YR9 = This is a 4% depreciation the 9th year YR10 = This is a 3% depreciation the 10th year YR11 = This is a 3% depreciation the 11th year YR12 = This is a 2% depreciation the 12th year YR13 = This is a 2% depreciation the 13th year And here’s a kicker, Whatever the current year is on the depreciation schedule the $ amounts in the field needs to be in Yellow. So if 2014 is in the “YEAR” field and the current year is 2016, the $ amount shown in YR2 needs to be in yellow for ease of viewing. Any help will be appreciated

Thank you Levi, I appreciate that very much. HJ

Hi Levi, Getting a little frustrated I think is true, but I think its more of a recognition that i'm over my head at this stage in my development process. I know there is a given "logic" to the how and way of Filemaker and I accept that will take time. I know I'll figure it out eventually and hopefully can help others as you've been good enough to help me. Harry

Hi Levi, RE: Are you making headway on the script or do you need more help? Thank you but i"m a long way off from understanding this. Thats why I said earlier I should not have asked the question because I new the answer is just way out of my wheelhouse. To let you know how bad things are I barley know what a wheelhouse is, just enough to know i'm out of it! I've been looking at some other scripts from solutions I've downloaded in hopes to understand better but as you said earlier, it will take awhile. HJ

Hi Levi, I just ordered "Filemaker and me" and any work I do or changes I make are always done in a copy, I learned that early on! As for being overwhelmed, thats the easiest part but Filemaker has allowed me to do a lot of things i"m confident I could not have done in any other database. Thanks again Levi, HJ

Hi Levi, it's good to hear from you again. When I wrote my post I was concerned that I would not understand the information once I received it and that has turned out to be the case. I got as far as setting the script to Set variable ( $FileName ; GetAsText ( container field ) ) but that was as far as I was able to get. I've been spending time reading about scripting and some of it is understandable and I've been able to write some simple scripts. The more sophisticated scripting is more like a foreign language and will take me a bit longer to muster! I try to wrap my brain around a lot of this and I'm happy to say I'm learning, albeit slowly. Worst of all is I feel as though I've wasted your time! I just want you to know that I appreciate your help and kindness. HJ

It is my understanding that a script can be set up to perform automatically what I’ve been performing manually. Can you give me some direction for the script. Let me begin at the beginning and I apologize if I'm giving too much information. I use a MacBook Pro running OSX 10.6.8 and FMP 12 Advanced. I use an Apple product called GarageBand. In GarageBand I import songs from iTunes and make what is called “Loops” which are selected parts of a given song. These song Loops are stored in; • Finder>Library>Audio>Apple Loops>User Loops> SingleFIles I go into the SingleFiles folder and copy the songs I want and paste them into Word. The Song Loops look like this; • Toby Keith How Do You Like Me Now7.aif In Word I do a "find and replace" so the above is changed like this, adding an * and deleting .aif; Toby Keith*How Do You Like Me Now7 I then convert the Word dock into a Plain Text (txt) document and import it into FMP. The Plain Text doc is imported into FMP using the field “Import_String” and the following fields perform the necessary separation into “Band_Name”, “Song_Name” and “Song_Number” etc. Here are the FMP fields; Import_String: Text field Band_Name: Calc field with Text result: Let([ Pos=Position(ImportString;"*";1;1)]; Trim(Left(ImportString;pos-1)) ) Song_Name: Calc field with Text result Let([ Len=Length(ImportString); Pos=Position(ImportString;"*";1;1)]; Trim(Middle ( ImportString ; pos+1 ; len-pos-number length )) ) Song_Number: Calc field with number result Right(ImportString;number length) Number_Length: Calc field with number result Let([num= GetAsNumber(Right(Bands::ImportString;2)); len=Length(Num)]; len) Song_Data: Calc field with Text result GetAsText ( Song Loop ) The information in this field looks like this; remote:Toby Keith How Do You Like7.aif AIFF:Secure/56/DE/9263CC8F/B6B79D97/02BF7C8C/550B Song_Loop: Container field External (Secure) This field holds the actual MP3 allowing playback of the Loop. Can you help me figure out how to set up a script for this. Thank you, HJ

Hi Levi I double checked the calcs and found that Band Name and Song Name are text fields but Song Number is a number field, should I change it to text? I actually like the calc fields, If I need to make a change I can do it through the ImportString that only I would have access to. That will keep folks, including me, from making changes I don't want to have made. Do you disagree? So there is not way to use ImportString for a search without the possibility of messing things up right? It would just be so great to perform a search from a scroll field showing all 3 fields, especially one that offers type ahead. But not at the expense of messing up information that is for sure. HJ