Skip to main content
Question

Understanding data entry forms vs. exact forms & how to create a client recordID field by combining partial data from other fields.

  • January 20, 2019
  • 0 replies
  • 118 views

This is probably a pretty basic concept but I'm very new to this. I'm trying to create a medical record ID# which is a combination of the client's first name 1st initial + first 3 letters of last name + last 4 digits of Medicaid ins ID, but have this field autmatically populate on all my medical record forms. So like if my name was John Smith Med ID= 23458373987849, then I'd like to enter that data into my clients parent table during the admissions intake appointment & have the record ID# field populate JSmi7849 automatically into the top right corner of each of my exact forms (admissions documents), & other client clinical documentation (i.e. progress notes, assessment report, Individualilzed service plan, discharge summary, etc.) Also, am I correct that the best way to produce these records is by using the "exact forms" & designing the custom templates in word or is there a better way to publish the information into an offical medical record document, which can be signed by the clniician. If I'm understanding Quickbase correctly, there are 2 types of forms: data entry forms (used to put the data into tables for storage) & exact forms (used to publish data into a formalized document after it's been entered. Is this correct?
This topic has been closed for replies.

The medical ID formula is easy and I will post it if you need it.

To generate. Real document attachment on docs or pdf format, I recommend this product add on from a Juiced.

https://www.juicedtech.com/exact-form... All my clients use it as it generates an actual document and not just an exactly formatted html page.

The formula for the medical ID, but not tested, so post back if any problems, would be

var text Inital = left ([First Name],1);

var text LastThree = left([Last name],3);

var text Med = Right([medical ID]);

$Initial & $LastThree & $Med

Now, you asked if that could be the Record ID. The Te odd Id is a built in automatic field which is a number wheel which sequentially counts up as records are added.

If you want to make a field in that format to actually be the Key field to the table, then typically tha is done by having a field calculated, and then a form rule to copy that to the key field of the table. There is also an advanced technique which can be used in some circumstances to make they key field be a formula field.

Btw, I suggest that the Medical ID field be a text field as opposed to a numeric field as it�s a very large number. I will need to recheck my notes, but I think that the largest number that Quick Base can hold is 14 digits, which is the length of your field in your example. A Text field can be any length.

.. I checked my notes and the maximum digits is 13 for a numeric field.

KeithJusas
Forum|alt.badge.img+7
  • Registered
  • January 21, 2019
Hi Alex,
(and thank you Mark!)

This is Keith from Juiced Technologies.

Our demo app is here and from that app you can also create a quote for EF+ so you understand the pricing.
https://juicedtech.quickbase.com/db/bknf8jnuy

We have an automated setup wizard that will create the necessary tables for EF+ so no need to create those until you are ready to try EF+.

Any questions, please let me know.

Keith