Jump to content

  •  

UPGRADE DEADLINE - SEPTEMBER 26, 2014!
FileMaker Inc. has a deadline for users of version 10,11, 12 as Individual box or volume licenses (with expired maintenance).
If you don't renew your maintenance and upgrade to FMP 13 you will no longer be eligible to upgrade, at the discount pricing.

Volume Licensing upgrade pricing for FileMaker Pro 13, FileMaker Pro 13 Advanced and FileMaker Server 13 will be discontinued.
Individual upgrade pricing for FileMaker Pro 13 and FileMaker Pro 13 Advanced will increase after September 26, 2014.
As of 27-September-2014, FileMaker 10 products will no longer be available for purchase or support.

http://help.filemaker.com/app/answers/detail/a_id/13865


Photo

Auto-populate current month name in layout with FM13


  • Please log in to reply
1 reply to this topic

#1 bpwhistler  member

bpwhistler
  • Members
  • 8 posts
  • LocationUtah
  • FM Application:13 Advance
  • Platform:Mac OS X Mavericks
  • Skill Level:Beginner
  • Time Online: 54m 40s

Posted 31 January 2014 - 09:38 AM

I want to create a field that auto-populates the name of the current month (MonthName). I would also like to auto-populate a field with the current year. I copied fields from a starter solution I found them in… but can't seem to get the field to auto-populate in my layout.

 

I found a thread that addresses this (http://forums.filema...osts/ed41960dd2) exactly, but it suggests doing what I've already done.

 

For the month field, I created a field named "Current Month Name." It's a global text field that is supposed to auto-populate from this calculation: MonthName ( Get ( CurrentDate ) ). I placed this field in my layout, switched to browse mode… and it's just an empty field. 

 

Similar for the "Current Year" field…except the calculation is: Year (Get ( CurrentDate ) ). 

 

I am a NOOB... So any explanation as to why I can't get this to function would be greatly appreciated. Are


  • 0

#2 comment  consultant

comment
  • Members
  • 24,193 posts
  • Time Online: 329d 10h 52m 7s

Posted 31 January 2014 - 10:06 AM

For the month field, I created a field named "Current Month Name." It's a global text field that is supposed to auto-populate from this calculation: MonthName ( Get ( CurrentDate ) )

 

It's not supposed to be a global field, I think (you didn't tell us what is the purpose of having this field and its "Current Year" sibling).


  • 0




FMForum Advertisers