This is a follow-on from the "Insert Blue Date Before Comment" posting as it was suggested that I start again with my questions....

I have to contact potential new clients as part of my job and all details are recorded in the database I'm developing. The action is recorded so that I can generate various reports.

What I want to do is add new action to the action log without losing previous actions listed.

I've attached the basics of what I'm working on with the hope someone can help with the final bit to make it work.

As you can see, I complete an action in [action log::latest action] and enter the date in [action log::date of latest action]. I will be using CalSnap to select the date but it comes out looking like the date format shown. The action remains there for report and clarity purposes.

Then, when new action is undertaken, I click the "ADD" button and the entry is added to [action log::action log] at the top of the field (i.e. latest entry first). The script (FMForum Add Entry Test) then clears the date and entry so new information can be entered.

What I cannot manage to do is get the new information to be added above the old. I know that repeating values and substitution comes in somewhere which is why the [action log::action in limbo] field is there - in case it needs to be used. I don't need to limit the number of entries in the [action log::action log] field but do require that existing entries can be edited.

Once this is done, my database will be almost finished!!

actionlog.zip

Change your script to appear as follows:

Set Field [action log::Action Log; TextColor( action log::Date of Latest Action; RGB( 0 ; 0 ; 255 ) ) & ": " & TextColor( action log::Latest Action; RGB( 0 ; 0 ; 0 ) ) &

Queue

I am your devoted slave!!! You ALWAYS help me out.

It works perfectly although, as usual, I don't really understand why.... I can see how close I was though to getting it right which does please this FMP illiterate female.

The only part I added was &