Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 3769 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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.

Posted

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.
Posted
Get ( CurrentDate ) & " " & Get ( CurrentTime )

=

Get ( CurrentTimestamp )

 

Yes – except for the two blanks …  :smile:

Posted

Yes – except for the two blanks …  :smile:

 

What two blanks?

 

 

Insert Current Date [Contacts::Notes Client]

Insert Text [" "] 

Insert Current Time [Contacts::Notes Client]

Posted

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 …

This topic is 3769 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.