Designating Text Fields as "Rx Fields"

[mdeyedoc]

You can now automate the formatting of the data in your CL and Spec Rx fields by designating those text fields in your medical records as Rx Fields of the type Sph, Cyl, Axis or Add.

Designate a text field as an Rx Field (see attached screen grab for example)

• Select the text field you want to change
• Check Field is RX Field under Additional Options at the bottom of the edit field box
• Select Sph, Cyl, Axis or Add from the drop down box that appears
• Save
  

This may save you some time in not having to enter some signs, decimal points or the zeros after the decimal point but it makes some assumptions and has some quirks that may affect other functions in your template.

Sph data formatting

• The + prefix will be added unless you enter it as a neg number. EG 1.00 -> +1.00
• It tacks a .00 onto 1 or 2 digit numbers. EG 2 -> +2.00;  -32 -> -32.00
• It puts a decimal point in the hundredth position if you enter a number with 3 or more digits. EG 125 -> +1.25, -1575 -> -15.75
• Any form of zero (0, 0.0, 0.00) will change to "Plano".
  
• It displays combos of letters, numbers and/or characters as entered UNLESS it includes a number in decimal form.
  
• If letters and/or characters are combined a number in decimal form (as some people do with bitorics) it converts to "Plano".  EG 2/3 is unchanged but -2.00/-3.00, -2.0/-3.0 or 2/3.00) will convert to "Plano".

Cyl data formatting

• Converts all numbers to - cyl, even if entered it as plus
• Same rules apply for adding .00 to 1 or 2 digit numbers and adding the hundredth decimal place if 3 or more and alphanumeric data
  
• Any form of zero converts to 0.00
  
• The combos with a decimal place (EG -2.00/-3.00, -2.0/-3.0 or 2/3.00) will all convert to 0.00 instead of Plano.

Axis data formatting

• Leading zeros are added to 1 and 2 digit numbers to make it 3 digits
• Any other entry seems to be displayed as entered including alphanumeric, signs, decimals and "/".
  

Add data formatting

• Converts all numbers to +, even if you entered as minus
• Same rules apply for adding .00 to 1 or 2 digit numbers and adding the hundredth decimal place if 3 or more and alphanumeric data
• Any form of zero converts to +0.00
• The combos with a decimal place (EG +1.00 D) will convert to +0.00. This could be a problem when entering adds for SCL.
  

Also note that if you convert to Rx Fields, the text boxes will have the F9 buttons which, in a compact template like mine, take up a lot of space.

I just discovered that there is a setting under EHR Settings/Page Options/Fix Rx Format that makes the Rx fields on the Rx Tab work the same way (except no F9 buttons).

Calculating Alternate Rxs
If you have buttons that calculate alternate Rxs, designating the destination fields as Rx Fields does solve the problem of missing + signs and decimal places. However the formatting occurs when you leave the field by hitting Tab or Enter which doesn't happen when a field is calculated. You will have to add commands at the end to move the "focus" through all the fields, ending with the field you want the cursor to land (after the last Rx Field). That has the same effect as tabbing through the fields.  I have attached a screen grab showing how to move the focus through the Rx Fields. The 4 command lines under the button settings are moving the focus to FID 538, 539, 544 and 545, all on Tab 3. Below that you can see the settings you would use to create a command that moves the focus to FID 545 on Tab 3. 

Also, if you change the fields used in the calculations to Rx Fields you will have to add commands to handle Plano Sph since equations require numeric fields. Add an If/Then command to convert Plano to 0.00 before the command lines that calculate the Rx.  If FID # (of the Sph field)  equals Plano, Set FID# (the same Sph field) to Value 0.00 . 

This may all sound like Greek to you but, hopefully, it will make sense to the people that are using equations to calculate Rxs.

Marcia



 

Attachments: