Use the auto enter options in field definitions. You can enter the modification name, timestamp, date, time etc.
Do you mean the username of the FileMaker file itself or the logon username for the computer? Also, is it a specific field within a record or is it any field in a record?
FileMaker file user name. It can be any field. Would the comment above yours work for this?
There's no such thing as the "file user name". The User Name is set as a preference in the FileMaker install. The login account name is the Account Name. So which one do you want?
Get(UserName) will return the FileMaker user for your file. Yes, the newer above could help too. You can create a field which would show 'Modified Date'. Set the field as 'Date' then in the Options there is a choice for 'Modified Date'. Try those two, that should help.
Not correct. Get ( UserName ) returns the user name set in the Preferences panel:
This setting is independent of the file in question. To return the name under which the user logged in, use Get ( AccountName ) or use the auto-enter option for Account Name:
Note that Get ( UserName ) is generally not a good idea, since users can alter it and spoof your setup.
Mike, can I suggest you take a step back and read before you hit 'Send' as your answers come across as one stop short of beginning with the words 'you're all idiots'. This is a community and we try to help each other out. Points are NOT scored on trying to make someone appear 'wrong' or stupid.
Do you know how I can have it to include fields from other tables?
Apologies if the answer came across as abrupt. However, given that these threads live on for a long time as searchable material, accuracy is important.
Being corrected doesn't make you "appear" to be wrong; your statement was wrong before you were corrected. It doesn't make you a bad person, and it doesn't make you stupid. It's happened to me on many occasions, and I came out the other side better for the experience. Nobody has infinite or flawless knowledge - me included (or especially). So being corrected is healthy.
Wanting to help is noble. You're right; that's why we all spend time here. But in the end, we're helping because we want the person being helped to have the right answer, not because of our own need to be "right", or some need to "score points". I really don't give a rip about that.
Cheers. And again, apologies for any abruptness in tone.
Use an auto-enter calculation equal to that field. If you want it to trigger on record modification, you can use something like:
Case ( not IsEmpty ( modificationTimestamp ) ; )
I understand the Auto Enter feature for a Time Stand, User etc.
But, when the field is modified the text disappears and is replaced with the Time Stamp.
Is it possible to do both?
For exmaple I have a Notes field. The users want to be able to enter text and have it Time Stamp. So, the next time a user enters that field from a device they can see the notes from previous users.
I've tried some of the script triggers as well. They seem to replace the text with the trigger commands.
I'm maybe just not entering the script steps correctly or the desired feature set is not possible in FM 14?
If I understand your question correctly, you want something like:
Joe called today. He wants to do lunch.
Entered by: Billy Bob 10/1/2015 10:52:13 AM
Joe stood me up. What a jerk.
Entered by: Billy Bob 10/1/2015 12:46:32 PM
and you want the "entered by" line with the user, date and time to be appended to the field after every user entry. Correct?
Yes! That's it exactly. The name is not a must but welcome for sure!
I'm creating a simple one table tabbed solution of doctor bio's for our managers.
When they attend medical conferences they want to enter text based on their intereaction with physicians. Then the other managers can see the notes so, they don't re-ask the same questions of the physicians.