In this workflow we generate a student ID number that is used by a private postsecondary school. The school is small and does not have the budget for a dedicated student information system, and houses the information in ActiveCampaign. Therefore we needed a way to generate a student ID that was unique for every student because there is no built in way to handle this.

The zap is triggered from an ActiveCampaign workflow that runs once a student enrolls.

• A code step creates an ID and then checks against a table that contains all current student IDs to ensure the ID is unique.

• If there is a duplicate, it will run until the ID is unique.

• It then adds the ID to the table and to ActiveCampaign.

• The code was generated with the help of the Copilot AI.

• The code also built in some error catching to email us if the code fails to generate a unique id after 10 loops.