Hi there, my name is Lucas, I'm developing a Filemaker database to help in the office and I hope you can help me to resolve this issue.
I have a field that I want to auto complete itself on creation like this: "016-08-01". This field should be made up with (year)+(month)+A number starting from 01 that does not skip numbers, and resets when the month changes. It is necessary that the field has the exact same format as shown on the example, as it is used in documentation.
What's the best way to go about this? Thanks for the help!