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?
