Maintaining a per-user count of form submissions

Ask for Help
1

Within my app, I provide a form to users, and I wish to maintain a column in my user table that tracks how many times each user has submitted the form. I cannot find any obvious way to do this within Glide. I know that it can be done quite trivially within my GSheet, but I need the count to be updated instantaneously, and so the sync delay creates a problem. I thought that a Rollup column may be the answer, but that gives me a count of all form submissions - and I need it broken down by user.

Would appreciate a steer in the right direction.

thanks,
Darren

1 Like
2

You can create a rollup on top of a relation column. Create a relation to link email in the user sheet to the email in the form sheet. Then create a rollup that uses that relation.

4 Likes
3

oooh, so simple. Thanks @Jeff_Hager!!

2 Likes