Groups > comp.databases.filemaker > #1377

FMPro 9 script won't work in FMPro 12

From	Bob M. <email55@domain.com>
Newsgroups	comp.databases.filemaker
Message-ID	<201309181004478188-email55@domaincom> (permalink)
Subject	FMPro 9 script won't work in FMPro 12
Organization	http://www.panic.com/unison/
Date	2013-09-18 10:04 -0700

Show all headers | View raw

[Multipart message — attachments visible in raw view] - view raw

I have an Auto-enter calculation in a field named Comments.

The ojective is to create a timestamp list of notes that I add from 
time to time with the latest note being on top.

Here is the Calculation I was using in 9 that doesn't work in 12:

Let(
[
_Notes = Comments;
_Prompt = " " ;
_Char = "• " ;
_Divider  = TextColor 
("¶––––––––––––––––––––––––––––––––––––––––––––––----–––––––––––––-----–––¶" 
; RGB (150 ; 150 ; 150));
_Tag = TextStyleAdd ( TextColor ( Get( CurrentTimeStamp ) & ¶ ; RGB ( 
150 ; 150 ; 150 ) ) ; Bold );
_Editing = Left( _Notes; Length( _Prompt )) = _Prompt or Left ( _Notes 
; Length( _Char ) ) = _Char

];
If( _Editing; _Notes;
_Char &  _Tag & _Notes & _Divider  & Middle ( $$NoteLog ; Length( 
_Prompt) ; 1000000 )) 

)

The data should look like this:

• 7/27/2009 1:29:45 PM
Left message for re: Battery Needing service
––––––––––––––––––––––––––––––––––––––––––––––----–––––––––––––-----–––
• 11/15/2007 11:22:13 AM
Talked with Stephanie about door bell. Jim will be out to switch door 
bells tomorrow at 9:00 to 11:00 am.

Can anyone help me with why this doesn't work in FMPro 12?

TIA,

Bob

Back to comp.databases.filemaker | Previous | Next — Next in thread | Find similar | Unroll thread

Thread

FMPro 9 script won't work in FMPro 12 Bob M. <email55@domain.com> - 2013-09-18 10:04 -0700
  Re: FMPro 9 script won't work in FMPro 12 John Hanson <crayz9000@gmail.com> - 2013-09-18 11:02 -0700
  Re: FMPro 9 script won't work in FMPro 12 Howard Schlossberg <howard@nospam.fmprosolutions.com> - 2013-09-18 21:07 -0700
    Re: FMPro 9 script won't work in FMPro 12 Bob M. <email@domain.com> - 2013-09-26 15:12 -0700
      Re: FMPro 9 script won't work in FMPro 12 Howard - FM Pro Solutions <fmprosolutions@gmail.com> - 2013-09-26 20:27 -0700
        Re: FMPro 9 script won't work in FMPro 12 Bob Meador <email@domain.com> - 2014-01-24 10:34 -0700

csiph-web