# Tracking each time a questionnaire is complete

**URL:** <https://community.glideapps.com/t/tracking-each-time-a-questionnaire-is-complete/73941>\
**Category:** Ask for Help\
**Created:** [June 6, 2024, 10:48pm UTC](https://community.glideapps.com/t/tracking-each-time-a-questionnaire-is-complete/73941 "2024-06-06T22:48:42Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![RyanC](https://avatars.discourse-cdn.com/v4/letter/r/a4c791/32.png) [@RyanC](https://community.glideapps.com/u/RyanC)\
**Post date:** [June 6, 2024, 10:48pm UTC](https://community.glideapps.com/t/tracking-each-time-a-questionnaire-is-complete/73941/1 "2024-06-06T22:48:42Z")

</div>

Background: I have created an app that has multiple questionnaires (i.e. Alpha, Beta, Charlie). Each questionnaire is filled out separately and the results are stored in a database. The database also includes a column that lets me know which questionnaire was filled out as well as a column that lists the name of the person who filled it out.

Question: I would like the database to automatically assign a number each time the same user fills out the same questionnaire. How can I do this (like in the following example)?

![example](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/5/5/554a32925974680aa9e0802cb69082f041d783ad.jpeg)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 6, 2024, 11:24pm UTC](https://community.glideapps.com/t/tracking-each-time-a-questionnaire-is-complete/73941/2 "2024-06-06T23:24:14Z")

</div>

Do you need to assign sequential numbers, or could you get away with using a Query column to find all matching Name/Questionnaires in each row, and then use a Rollup to count the matches.

---

<div class="post-metadata">

**Author:** ![RyanC](https://avatars.discourse-cdn.com/v4/letter/r/a4c791/32.png) [@RyanC](https://community.glideapps.com/u/RyanC)\
**Post date:** [June 7, 2024, 2:37pm UTC](https://community.glideapps.com/t/tracking-each-time-a-questionnaire-is-complete/73941/3 "2024-06-07T14:37:37Z")

</div>

I need sequential numbers.

---

<div class="post-metadata">

**Author:** ![RyanC](https://avatars.discourse-cdn.com/v4/letter/r/a4c791/32.png) [@RyanC](https://community.glideapps.com/u/RyanC)\
**Post date:** [June 7, 2024, 4:20pm UTC](https://community.glideapps.com/t/tracking-each-time-a-questionnaire-is-complete/73941/4 "2024-06-07T16:20:43Z")

</div>

sequential numbers

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [June 7, 2024, 4:59pm UTC](https://community.glideapps.com/t/tracking-each-time-a-questionnaire-is-complete/73941/5 "2024-06-07T16:59:21Z")

</div>

I think you can pretty much do what I mentioned in my previous post to get a Rollup count of all previous questionnaires, then create a Math column to add 1 to that number. Then pass that math value through your form to write it to your number completed column.