userID Pack

Explore

userID

Tommy Lambert

Last edited 209 days ago by Tommy Lambert

Why userID is essential?

⁠

Copy this doc

⁠

What’s userID Coda Pack?

This Coda pack is designed to generate a custom userID based on provided parameters. It can be used by Coda users to generate unique identifiers for users in their docs.

Read more...

The pack includes a single formula called "GenerateCustomUserID" that takes four parameters: "role", "year", "firstName", and "lastName".

The "role" parameter represents the role or position of the user, the "year" parameter represents the year of the user's registration, and the "firstName" and "lastName" parameters represent the user's first and last names, respectively.

When the formula is executed, it generates a custom userID by combining the provided parameters with randomly generated unique identifiers. The generated userID has the format "role-year-uniqueIdentifier1-uniqueIdentifier2". The "uniqueIdentifier1" and "uniqueIdentifier2" are generated using the generateUniqueIdentifier function, which generates a random string of alphanumeric characters of a specified length.

To use this Pack, Coda users can input their role, registration year, first name, and last name as parameters (in that order) when calling the "GenerateCustomUserID" formula. The formula will then generate a custom user ID by combining these parameters with randomly generated unique identifiers.

For example, if a user with the role "admin", registration year 2022, first name "John", and last name "Doe" calls the "GenerateCustomUserID" formula, it might return a custom userID like "admin-2022-ab3cd-efg45h67". This custom user ID can be used to uniquely identify the user in their Coda documents or other systems.

Coda users can use this pack in their Coda documents or applications to assign unique identifiers to users based on their roles, registration years, and names. This can be useful for user management, data tracking, or any other scenario where unique user identification is required.

By generating a custom userID, Coda users can create secure table architectures by using the userID as a unique identifier between tables. This helps in associating data related to a specific user while maintaining data privacy and security.

Additionally, Coda users can create separate environments within their documents to display anonymous data without revealing personal information. By utilizing the custom userID generated by the "GenerateCustomUserID" formula, users can anonymize and aggregate data while preserving privacy.

You can use a pre-configured table from the attached coda doc, or create your own custom table using the "GenerateCustomUserID" formula.

Data structure of the pack: Role + Year + First Name + Last Name = userID

userID Table

userID Table

User's Role

Year

First Name

Last Name

userID

Student

2023

Tommy

Lambert

Student-2023-5ipky-4s2fnmfg

Teacher

2023

Diane

Manoukian

Teacher-2023-9d7hk-dtkkck0c

Company

2023

Ninoushka

Klink

Company-2023-371bc-nagd0qm0

Employee

2023

Dominique

Delh

Employee-2023-f84uc-5i4yc29h

There are no rows in this table

⁠

Please visit my LinkedIn profile and contact me if you like my work.

⁠

My Linkedin Profile

⁠

Buy me a Ko-fi!

⁠

Buy me a coffee

⁠

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.