How to create a layout that will force the user to finish previous record?
Wondered if anyone could help me? Right now, I have a layout based on a table where if a person presses the "Submit" button, they commit the record and also start a new record.
In addition, I created a script trigger that when the layout is "OnRecordLoad" that a new record is created and the AccountName of the user is set to this record's foreign key.
The problem is that now I have way too many empty rows in my data. Whenever a user just loads the layout and exits out (even without entering any data), they end up leaving an empty row. However, without the script trigger on the layout which sets the AccountName to the record's foreign key, the user always sees the last entry of the last participant?