Mandatory fields in Google Sheets

Hi,

I would like to implement the following in Google Sheets:

I want to define certains fields in each row, that are mandatory. Whenever someone trys to type into any field in a row, this should only be possible when all mandatory fields in the row are filled in. There should also be a warning when this happens (typing in a field when the mandatory fields are empty).

is this at all possible?

one method would be to create a google form, and make the fields mandatory,
another option would be to create "onEdit" apps scripts.