Since it is almost impossible to prevent users to create emtpy records, I have made an automation to delete rows in certain databases if specific fields are empty. That works pretty good, but since you are not sure when the automation acts, it is also a bit unpredictable - sometimes a record gets deleted just because you were not quick enough to fill some (required) fields.
A table option for this cleanup work would be nice. The parameters would be:
- active/not active
- rows to check (if no rows are entered, it applies to a completely empty row - but when formulas/default values are defined to fill cells in new rows you need a row check, otherwise an ‘unintended’ record would never be deleted as some fields will be always be filled).
- Time to live for ‘empty rows’ (to allow for some time to enter something in all the required fields)