Thanks to everyone for the help! I was able to get the 6 fields to update separately with a timestamp and user.
In the end, I used the calculate option in field auto-enter tab, based on Richard's suggestion. Have a great weekend! Kendall On Fri, Apr 10, 2015 at 12:12 PM, Richard DESHONG <[email protected]> wrote: > Hi Kendall, > So it sounds like you want a user ID and a timestamp. You could use the > auto-enter calc I posted and just replace the "grade dash timestamp" with > "UserID dash timestamp". And then since you only want the latest, just > don't wrap it in the List() command. > > Your mention of 6 fields was a bit unclear: Did you want a User-Timestamp > for each one, or single User-Timestamp for when any of the 6 fields changed? > > In my examples, I'm presuming you have user ID field named "UserID". > > If the latter, (any of the 6 changed), use: > Let( trigger = Evaluate( ""; [Field1; Field2; Field3; Field4; Field5; > Field6] ); > UserID & " - " & Get( CurrentTimeStamp ) > ) > > If the former, (one for each), then create a "log" or "changed" text field > for each of the 6 fields and use the same auto-enter calc (but with just > the one field). > > > > > On Fri, Apr 10, 2015 at 12:02 PM, Kendall MOALEM <[email protected]> > wrote: > >> Hi Richard, thank you. >> >> I'll need to see on any of 6 fields in my database the date/time/user who >> made the change. It doesn't need to be a log, but just the most recent >> touch. A log would work though. >> >> I'm not on Filemaker Server though, but Filemaker Pro Advanced. >> >> >> >> On Fri, Apr 10, 2015 at 11:48 AM, Richard DESHONG <[email protected]> >> wrote: >> >>> Hi Kendall, >>> Are you looking to create a log (1 or more entries) for when a field has >>> changed? >>> >>> If so, you can create a field and use the following auto-enter calc: >>> >>> The field I'm wanting to watch: Grade >>> >>> My log field: GradeLog >>> >>> Auto-Enter calc: >>> Let( trigger = Evaluate( ""; Grade ); >>> List( GradeLog; Case( IsEmpty( Grade ); "{}"; Grade ) & " - " & Get( >>> CurrentTimeStamp ) ) >>> ) >>> >>> This produces test such as: >>> B - 3/5/2015 2:54:18 PM >>> >>> On Fri, Apr 10, 2015 at 10:57 AM, Kendall MOALEM <[email protected]> >>> wrote: >>> >>>> Any Filemaker gurus out there? >>>> >>>> I'm rather new to Filemaker. I've been working to create a number of >>>> timestamped *fields*, that record date change based on a field touch, >>>> rather than to update the entire record based on a field touch (which is >>>> how the Modification>timestamp works). >>>> >>>> I've found this reference which I've followed >>>> >>>> >>>> http://help.filemaker.com/app/answers/detail/a_id/4876/kw/modification%20date%20on%20each%20field >>>> >>>> >>>> but I get stuck at the 'Import' step #8 because it only allows me to >>>> link to another database. What I really want to do is link to the other >>>> table's data within the same database. >>>> >>>> Any suggestions about creating timestamps specific to the field? >>>> >>>> -- >>>> >>>> *Kendall Moalem* >>>> >>>> *Business Analyst* >>>> >>>> *Campus Shared Services,Team 2 (ERSO)* >>>> >>>> *413 O'Brien Hall, Berkeley, CA 94720* >>>> *p: 510/643-8424 <510%2F643-8424> f: 510/*664-7120 >>>> *www.erso.berkeley.edu <http://www.erso.berkeley.edu>* >>>> >>> >>> >>> >>> -- >>> Richard DeShong, Systems Analyst, Athletic Study Center, U.C.Berkeley >>> 164 Chavez Student Center, Berkeley, CA, 94720-4220 >>> 510-642-5123 asc.berkeley.edu >>> >> >> >> >> -- >> >> *Kendall Moalem* >> >> *Business Analyst* >> >> *Campus Shared Services,Team 2 (ERSO)* >> >> *413 O'Brien Hall, Berkeley, CA 94720* >> *p: 510/643-8424 <510%2F643-8424> f: 510/*664-7120 >> *www.erso.berkeley.edu <http://www.erso.berkeley.edu>* >> > > > > -- > Richard DeShong, Systems Analyst, Athletic Study Center, U.C.Berkeley > 164 Chavez Student Center, Berkeley, CA, 94720-4220 > 510-642-5123 asc.berkeley.edu > -- *Kendall Moalem* *Business Analyst* *Campus Shared Services,Team 2 (ERSO)* *413 O'Brien Hall, Berkeley, CA 94720* *p: 510/643-8424 f: 510/*664-7120 *www.erso.berkeley.edu <http://www.erso.berkeley.edu>*
------------------------------------------------------------------------- The following was automatically added to this message by the list server: To learn more about Micronet, including how to subscribe to or unsubscribe from its mailing list and how to find out about upcoming meetings, please visit the Micronet Web site: http://micronet.berkeley.edu Messages you send to this mailing list are public and world-viewable, and the list's archives can be browsed and searched on the Internet. This means these messages can be viewed by (among others) your bosses, prospective employers, and people who have known you in the past. ANNOUNCEMENTS: To send announcements to the Micronet list, please use the [email protected] list.
