Jump to content

calculation


This topic is 5720 days old. Please don't post here. Open a new topic instead.

Recommended Posts

I am a physician and i am indexing the cases in my emr manually to 06-MM-###

so the last tripple digits will be starting from 0 every month. so the 5th patient in may of 2006 would be 06-05-005 and so forth. is there a script that i can use to automate the entry with that fashion so when the month revolves it will reset the last 3 digits to 000 and the month to 06.

thx for any help i can get

Link to comment
Share on other sites

can you help me with how automate the date entry, in the thread you referred me to, it seems that i need to enter the date to generate the invoice number in the zip example, i still need to enter the date, is it possible to script that to be generated when i hit new record button without manually entering the date?

it was a very helpful thread any way . thx for your time

Link to comment
Share on other sites

Replacing 'Date' with 'Get(CurrentDate)' should do it. However, if this file is being shared by multiple users, you may want to script setting the 'id' field, instead of using the auto-enter calculation, so that you do not end up with duplicates.

Link to comment
Share on other sites

This topic is 5720 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.