How do I count the number of times a form submission is made?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have an application that accepts nominations for an award. I want to be able to count the number of nominations submitted and when the number gets to ten I want to display a message that says something like, 'nominations for this category are closed'.  There are six different award categories, each on its own table. How would I do that?

Photo of Bruce

Bruce

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
No problem.

Make a single new table called Submission totals.
Add one record to it, even though it has no fields yet.
It will be [Record ID#] =1 as it's the first record.

Make a field on Submissions Category 1 called [Link to submission Totals] and make it a formula numeric field with a formula of just

1  (i.e. The same as the Record ID #1)

Now make a relationship back to the Submissions totals table based in this field being the reference field on the right side of the relationship.. One Submissions Total has many Submissions.

Finally, on the left side of that new relationship, make a summary field to count the goal submissions.  Then look that up down to the to the Sbmissions table 1.

That's it.  The Submissions table 1 now knows the count of the total submissions so you can have form rules or a formula text field to control what the users see.

Unfortunately, given your decision to have 6 tables for 6 awards instead of a better design of 1 table and the user choosing an award category at the top of the form, you will need to repeat this process for each award submissions process, although you still only need to have that single table to hold the totals.

It would be a better design to have a table of Award Categories, having many award submissions and then set the limit up on the Award Categories table and thus only have two tables.



Now mak
Photo of Bruce

Bruce

  • 0 Points
Making one table would definitely make things easier.  Unfortunately I use text on each form to explain the category requirements and such.  If you know of a way that information can be visible based on the type of nomination it would make this application easier.  Thanks!
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
Well in that able of categories you would have any extra explanation fields. Then do a lookup down to the Submission record.