video1.0<iframe src="https://www.loom.com/embed/42c7f8be9bbd4ca69165e01d6377dd01" frameborder="0" width="1356" height="1017" webkitallowfullscreen mozallowfullscreen allowfullscreen></iframe>10171356Loomhttps://www.loom.com10171356https://cdn.loom.com/sessions/thumbnails/42c7f8be9bbd4ca69165e01d6377dd01-00001.gif521.467IMPORTANT: Both the Unique Id and the Record Position columns must be Text data type, not Number data type as shown in the video. **Prompt to generate a unique Id (any name of preference for this value - replace variables accordingly): Generate a random number with at least 15 digits if {{column of choice}} is not empty. This will be a Unique ID for the record. Format as text, and call this column Unique ID. **Prompt to assign the Record Position: Only run if /{{Unique ID}} is not empty. Index the arrays below, and check where the ["Unique ID"] value matches /{{Unique ID}}. Return which position number corresponds to that record. For example if the first record's ["Unique ID"] value matches the variable then return 1, and if the second entry, if it exists, is matched then return 2, and so on. Check for the value in lower case (optional). If there's no match then return 2. Arrays to check: /insert_list_of_records