Forms table automatic ID

Copper Contributor



A query was created via forms, which automatically records the answers in an Excel. Before distribution to the area, a few test runs were started. As it has now turned out, the ID also counts the deleted test attempts. Although there have only been 350 real replies so far, the ID counter in the Excel is at 384.


What can I do to make the Excel count correctly?

  • I deleted the test attempts in Excel
  • I deleted the test attempts in Form

I'm not brave enough to create a new Excel, because I don't want to mess up everything.


Many thanks and sunny greetings



0 Replies