Form Submissions

Hello,

Use case:
We have a series forms that we are looking to have workspace members acknowledge → acknowledgement inserts a row into a central table and the form submission is limited to a single response in a given date period example 1/1/2026 we would reset the acknowledgements and require a submission again.

So:

  • Workspace members fill out and “acknowledge” a series of forms.
  • Each acknowledgement creates a new row in a central database table or is one needed for each?
  • Form access is limited so each member can only submit once during a defined period (e.g., calendar year 2025).
  • At the start of the next period (e.g., January 1, 2026), you clear or expire those acknowledgement records so everyone must submit again.

Implementation:
Is there a way to restrict that form submission button with some sort of filter?
Imagining like Disable If:

Acknowledgements.Filter(
  User = User() 
  AND Period = Year(Today())
).Count() > 0

Anyone done anything similar to the above general use case?

Hi Ian,

You had the right intuition, you just needed to use the formula in the validation options for Form fields.

Here you have a little example

Let me know if this helped!

Pablo

2 Likes