unique values in value list

[rkass068]

Hello,

 

I have created a database with a bunch of patients. Each patient has a unique hospital number put on their charts. This number is usually assigned to them once they are registered in hospital. In some cases we like to keep track of people who donate bone marrow to another patient and they want to remain anonymous. In this case, we would put a "dummy" number in the hospital number field. I would like to make a value list of a bunch of dummy numbers that would come up in a dropdown for patients with this case. 

 

This is very easy as I can make a value list but my problem is that I want the dummy numbers to be eliminated from the value list once used, that way they are unique. In other words, I want only the unused dummy numbers to show up in the value list.

 

If anyone can help me with this that would be great. Thank you!

 

[comment]

Wouldn't it be simpler to generate a dummy number on demand? I mean why would you want to pick a specific dummy number from a list? Is there a choice that is better than any other?

[rkass068]

I could do that too and if they have a hospital number they can replace it but can It be unique. For example, generate the number 0000001, next would be 0000002?

[comment]

Don't you already have your own, auto-generated serial number PatientID? Or you could just use Get ( UUID ).

[rkass068]

Yes I do already have an auto serial number, but the docs want everything to look streamlined. Since the format for the hospital number is #########, they want the dummy hospital numbers to be the same. Is it possible to do this? I know seems weird but I do what the boss says. hahah

[comment]

SerialIncrement ( "000000000" ; PatientID )

will get you there. Or, if you want to smarten it up, you could use:

Right ( Year ( Get (CurrentDate) ) ; 2 ) & SerialIncrement ( "000" ; DayOfYear ( Get (CurrentDate) ) ) & SerialIncrement ( "0000" ; PatientID )

Note: the target field must be of type Text.

[rkass068]

Thank you very much!