Creating unique participant IDs

Hi all,

I am looking for a way to generate unique IDs for individuals filling out forms. We have a number of events for which we have made registration forms. When a person fills out a form, we would like to have the corresponding sheet automatically generate a unique ID for each person that is de-identified. Is there a way to do this?

Additionally, is there a way to keep such a unique ID consistent across multiple forms/sheets if the same person registers for more than one event?

Thanks!

Find more posts tagged with

Forms

Sheets

Formulas

Cell linking

Data Shuttle

Accepted answers

All comments

Paul Newcome

You would insert an auto-number column which will assign a unique id to every row. You can also insert a text/number column for users to manually enter an id if they have already been assigned one.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.