I have a form to enter my patient details. Can I create a unique code for each patient based on their DOB and Name combination?

I have a form to enter my patient details. Can I create a unique code for each patient based on their DOB and Name combination?

To create a unique code based on the Date of Birth (DOB) and Name combination, add a Formula field with formula expression as given below,

((((DOB.getMonth())) + Name) + (DOB.getDay())) + (DOB.getYear())

where,

- DOB.getMonth, returns a number in the range (1 -12), representing the number of the month of the year, on which the date occurs.
- DOB.getDay(), returns a number in the range (1 - 31), representing the number of the day of the month on which the date occurs.
- DOB.getYear(), returns a number representing the year of the date.

For example, if DOB is specified as 07-Sep-1994, with Name as "Henry", the formula expression specified in the Code field, returns 9henry71994.


    • Related Articles

    • Form-based campaigns

      Form-based Campaigns Integrate your Zoho MarketingHub account with Zoho Forms. This is an in-house integration and does not require a separate sign in to Zoho Forms. With this integration, you can access the forms created in Zoho Forms and reach out ...

    • Form-based Campaigns

      Integrate your Zoho Campaigns account with Zoho Forms. This is an in-house integration and does not require a separate sign in to Zoho Forms. With this integration, you can access the forms created in Zoho Forms and reach out to your users by adding ...

    • Signup form reports

      You can view the number of visitors who have submitted and confirmed their subscription. The following data is represented in the form of a doughnut chart: Form Views - Number of visitors who have visited pages embedded with your signup form. ...

    • Signup Form Reports

      Signup form reports lets you view details of the various contacts who have signed up for your email newsletters through your signup forms. You can use this information to target your contacts with email campaigns best suiting their need. To view ...

    • Create Webforms

      Creating a web form involves three steps Building the form - Drag and drop fields to build a form and format it easily with the WYSIWYG editor. Specifying the form details - Add details such as form name, landing page URL (where the applicant needs ...