"Modified by" history list

[jlf]

I'm trying to create a list that will track a history of users that have modified any particular record.

I've got a set of working fields now that display username, date and time after modification.

Problem is, they update each time in the first repeating field only.

How do I save the last user then move down the list?

[AHunter3]

a) Ditch the repeating-fields approach. Repeating fields are an abomination in the eyes of God and are responsible for social corruption and bad breath and stuff like that. You should never store actual data that you're going to need to manipulare or search on or sort within repeating fields. I'm not kidding.

 

 

b) I assume you have a Modification TimeStamp field. If not, make one.

 

Then...

 

Create a text field, let's call it "Modification History", with an auto-enter option like this:

 

Let (pilcrow = "¶";

Evaluate ("Modification History & pilcrow & Get(AccountName)" [Modification TimeStamp])

)

 

 

Set the field's auto-enter option so that it *DOES* replace existing field values.

 

 

That handles your names.

 

Repeat for "Mod History TimeStamps", deploying a similar Evaluate() formula except inserting Get(CurrentHostTimeStamp) in lieu of Get(AccountName).

 

That handles when it was modified, and the timestamp of a given modification will appear alongside of the modifier when you position the fields next to each other.

[sujat]

Let (pilcrow = "¶";

Evaluate ("Modification History & pilcrow & Get(AccountName)" [Modification TimeStamp])

)

 

Set the field's auto-enter option so that it *DOES* replace existing field values.

 

When I copy and paste the formula it is saying " an operator is expected here"

[AHunter3]

My error. Left out a comma.

 

Let (pilcrow = "¶";

Evaluate ("Modification History & pilcrow & Get(AccountName)", [Modification TimeStamp])

)

[sujat]

Thanks AHunter,

 

The result is showing a " ? "

[AHunter3]

This field is a text field?

[sujat]

Yes it is a text field

[AHunter3]

OK I will do some actual testing. I must have made some oddball error. I know it works, generically speaking.

 

EDIT: Ok I was having an off-day. Sheesh. sorry.

 

Use this formula in your auto-enter calc formula instead:

 

 

Case (Modification TimeStamp;Modification History & Left ("¶"; Length (Modification History)) & Get(AccountName))

 

 

 

as before, DO uncheck the "do not edit existing values" checkbox.

[sujat]

Thank you very much.

 

It is working perfectly.

 

Thanks.

[Jabert]

I ran across this solution, and tried to implement it into a DB I am developing for a Non-Prof in LA.

 

I created a Modification_History field as a text field with an auto enter value of

Case (Modification_TimeStamp;Modification_History & Left ("¶"; Length (Modification_History)) & Get(AccountName))

 

I also created a Modification_TimeStamp field

 

It does not work, and I have obviously done something incorrect. If I make a change the field remains empty.

 

You state that "as before, DO uncheck the "do not edit existing values" checkbox." but I cannot find a place that shows this option.

 

Can you help me?

 

TIA

 

John Chamberlain

[Josh Ormond]

You state that "as before, DO uncheck the "do not edit existing values" checkbox." but I cannot find a place that shows this option.

 

[rwsayles]

Jabert-

I know it's been over a year but in case anyone else checks this out in the future, the following worked for me with FM Pro 10:

 

1) mod_timestamp field (as explained above)

2) Mod_history text field with the following auto-enter calc:

 

mod_history & "¶" & mod_timestamp & " " & Get(AccountName)