Skip to content
userID Pack
More
Share
Explore

icon picker
userID

Last edited 52 days ago by Tommy Lambert
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
0
User's Role
Year
First Name
Last Name
userID
1
Student
2023
Tommy
Lambert
Student-2023-5ipky-4s2fnmfg
2
Teacher
2023
Diane
Manoukian
Teacher-2023-9d7hk-dtkkck0c
3
Company
2023
Ninoushka
Klink
Company-2023-371bc-nagd0qm0
4
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.

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.