Google Sheets - App Script - Add unique code based on new row entry on form submission
Budget: $10 – $30 USD
I am looking for a Google Sheets expert who can help me with an App Script that will add a unique code based on new row entry on form submission. The purpose of the unique code is for tracking purposes. The data in the new rows will contain both text and numbers. I do not need any additional functionality besides adding the unique code to a cell.
Ideal skills and experience for this job include:
- Proficiency in Google Sheets and App Script
- Previous experience with adding unique codes based on form submissions
- Strong understanding of tracking purposes and how to implement them in Google Sheets
- Attention to detail to ensure the unique codes are accurate and consistent
- Ability to communicate effectively and provide updates throughout the project.
For example, if we were running a campaign for a single track but are activating multiple services - here’s how it would impact the campaign code:
Sample Entry:
Song: Poker Face
Artist: Lady Gaga
Services: TrueView, In-Feed, TikTok Spark, Meta Out Now
TrueView ID: 00001-06-003
In-Feed ID: 00001-06-004
TikTok Spark ID: 00001-05-001
Meta Out Now ID: 00001-01-001
So these are all associated with the same overall marketing campaign (00001), with each different platform having its own codes, and then each service within those platforms also has a unique ID (003 being trueview, 004 being in-feed, and 001 being Spark and Out Now)
One-time project with a few tweaks if needed after testing. I appreciate your consideration.
Ideal skills and experience for this job include:
- Proficiency in Google Sheets and App Script
- Previous experience with adding unique codes based on form submissions
- Strong understanding of tracking purposes and how to implement them in Google Sheets
- Attention to detail to ensure the unique codes are accurate and consistent
- Ability to communicate effectively and provide updates throughout the project.
For example, if we were running a campaign for a single track but are activating multiple services - here’s how it would impact the campaign code:
Sample Entry:
Song: Poker Face
Artist: Lady Gaga
Services: TrueView, In-Feed, TikTok Spark, Meta Out Now
TrueView ID: 00001-06-003
In-Feed ID: 00001-06-004
TikTok Spark ID: 00001-05-001
Meta Out Now ID: 00001-01-001
So these are all associated with the same overall marketing campaign (00001), with each different platform having its own codes, and then each service within those platforms also has a unique ID (003 being trueview, 004 being in-feed, and 001 being Spark and Out Now)
One-time project with a few tweaks if needed after testing. I appreciate your consideration.