Brian Dunning's FileMaker Custom Functions

CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )

List every table names of current file followed by count of records which modified within StartTimestamp and EndTimestamp.

  Average rating: 3.0 (1 vote) Log in to vote

Koji Takeuchi   Koji Takeuchi
TonicNote, Inc.
https://tonic-note.com

Share on Facebook Share on Twitter

  Sample input:
CountModifiedRecords ( "za_timestampModified" ; "2018/5/1 15:00:00" ; "2018/5/3 9:00:00" )
  Sample output:
140 OrderItem
32 Order
2 Customer
0 Products

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

CountModifiedRecords ( NameTimestampField ; StartTimestamp ; EndTimestamp )
2018.05.28, Koji Takeuchi


description:
List every table names of current file followed by count of records which modified within StartTimestamp and EndTimestamp.
ex1:
CountModifiedRecords ( "za_timestampModified" ; "2018/5/1 15:00:00" ; "2018/5/3 9:00:00" )
-> "140OrderItem¶32Order¶2Customer¶0Products"
ex2:
CountModifiedRecords ( "za_timestampModified" ; GetAsTimestamp ( Get ( CurrentDate ) - 10 ) ; GetAsTimestamp ( Get ( CurrentDate ) ) )
-> "521OrderItem¶340Order¶83Products¶45Customer"
# It returns -1 as count if the table does not have the field which specified.

 

Comments

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Under construction. Email me your wish list for improvements.