I'm stuck on how to configure a script and I know I must be overlooking the obvious...

 

I use FilemakerPro as my CRM in a sales business.  I make notes each time I speak to my clients.  I have a script that will automatically begin a new note with a date/time/contact_method stamp notation in my notes field followed by a space and then the curser for me to begin typing the notes.  Simple so far.  

 

Currently each new note begins below where the last note left off.  

 

What I want to do is script the starting point for each new note to begin at the top of the field so as I add more notes I can always see the most recent notation without having to scroll to the bottom of the field. 

Therefore the notes will be listed in reverse order.   Any thoughts?  

 

Not that it's too relevant but below is the simple script that I'm using now - so if you have any steps that I could insert to begin at the top of the field please let me know.

 

Current Script:

Go to Field (Contact::Notes Client)

Enter Browse Mode []

Insert Current Date [Contacts::Notes Client]

Insert Text [" "] 

Insert Current Time [Contacts::Notes Client]

Insert Text [" "]

Insert Text ["- Phone Call:"]

 

Result is - 7/29/2014  12:10:27 PM: Phone Call: 

 

Thanks in advance for any help.

Try

Set Variable [ $newFirstLine ; Get ( CurrentDate ) & "  " & Get ( CurrentTime ) & " - Phone Call: " ]
Set Field [ Contacts::Notes Client ; List ( $newFirstLine ; Contacts::Notes Client ) ]

Note that you could also use a related table with fields for type, date, time, notes etc., sorted by date – or any other field, for that matter – and create a new, pre-set note record via script.

Automatic message

This topic has been moved from "FileMaker Resources" to "Managing Scripts".

Get ( CurrentDate ) & " " & Get ( CurrentTime )

=

Get ( CurrentTimestamp )

Get ( CurrentDate ) & " " & Get ( CurrentTime )

=

Get ( CurrentTimestamp )

 

Yes – except for the two blanks … 

Yes – except for the two blanks … 

 

What two blanks?

 

 

Insert Current Date [Contacts::Notes Client]

Insert Text [" "] 

Insert Current Time [Contacts::Notes Client]

What two blanks?

 

The two blanks I put into my sample code, being under the false impression that the OP had/wanted two. Forget it …