I’d like to show days since last race for a horse where the first race returns 0. I played around with ‘last’ and ‘GetNthRecord’ but something went wrong. I had some problems with races where the horse was scratched, but I can live with that.
Hi, I am using this calculation in portal which calculates days in portal Date - (GetNthRecord ( Date ; Get ( RecordNumber ) - 1 ) )
how can i modify or do something else to avoid (?) in the first row. Sample file attached for any modification/help.
Thanks for any help
So there's probably something simple, but do you guys know of a way to automate dates from one record to the next? Each record date needs to be seven days after the previous one, and I'd like for my client not to have to enter it manually. I tried doing
Let ( Today = ( ReleaseDate ) ;
Date ( Month ( Today ) ; Day ( Today ) + 7 ; Year ( Today ) )
and some others, but none appear to automatically fill in. Help!
My solution is build according to the 'separation model', so I would like to keep control of the local file containing the layout and presentation of the data hosted in the server.
I wonder if I could have a script to control wether the local file gets its structure, layout or scripting modified, so I need a function to control when a change to the file has been made before giving it a version number. When the file gets open only to work with the hosted data it's not a new version.
Here is a custom function that I found on Briandunning.com. The problem is when I try to create a new function with this code, Filemaker refuses it saying
The "here" above is situated before the parentheses after "WordWrap" and before "UnprocessedText". Would someone be kind enough to tell what I'm missing here to get this up and running?
Let ([ TruncatedText = Left ( Text ; Size + 1 ) ; CountOfSpaces = PatternCount ( TruncatedText ; " " ) ; CountOfReturns = PatternCount ( TruncatedText ; "¶" ) ; PositionOfLastSpace = If ( CountOfReturns > 0 ; Position ( TruncatedText ; "¶" ; 1 ; 1 ) ; Position ( TruncatedText ; " " ; 1 ; CountOfSpaces ) ); AddReturn = If ( CountOfReturns > 0 ; "" ; " ¶" ); ThisLine = Trim ( Left ( TruncatedText ; PositionOfLastSpace ) ) ; UnprocessedText = Right ( Text ; Length ( Text ) - PositionOfLastSpace ) ; Result = If ( Length ( Text ) ≤ Size ; Text; ThisLine & AddReturn & WordWrap ( UnprocessedText ; Size ) ) ]; Result ) Sorry everyone. Please dismiss my post. I just realised that I was trying to include "WordWrap" as a function parameter and as the function name. All's well.
Who Viewed the Topic60 members have viewed this topic:Nico Kobes pchinchilla Robin Penfold email@example.com Hee fileman922 Edward Yuen carlosv75 sh2658 Helder Moreira Jack90 Miczabat CHawk mr_vodka bhamm bucko Şemsi Saracoğlu OlgerDiekstra comment moriya0238 renovante drjonesx Dr.Gopala krishnam raju AMBATI Gabriel Mellado Paul Baker stubbers tv_kid mariomoroder Agentshevy Warren Franco Pagano villeglad doughemi Lee Smith rwoods Tom Assia macjos infoweb camacorp AlesD marsau vinsg Jeroen de Haan Ed@ jorfasan Ville Glad mmcmanus alexdubov Martin@T43 RyanESmith7 asterix Ron Cates firstname.lastname@example.org Lola MikeKD ggt667 Josh Ormond Dan Mitchell _ian JDW