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.
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