Hello community members,
This seems like such a basic operation that I'm surprised I could not find a solution in the Support pages or the Community.
I'm building a project request intake form. The client would like to have a unique Project ID number assigned for each submitted project, and would prefer it to be sequential. It could be as simple as assigning 1 to the first submitted project, 2 for the next, 3 for the third, etc. However, recognizing that there will be incomplete responses that are started but never submitted, the client might accept gaps in the project ID numbering scheme, as long as they are still in a relative order (that is, the highest number always represents the most recently submitted project, and each successive lower number is the one previously submitted).
I know that you can set a random number as Embedded Data in the Survey Flow, but I can't find any way to set consecutive, increasing numbers for each response. I'm probably overlooking something obvious. Is there some way to assign an increasingly larger number to each response as it is submitted that appears in the dataset?