I really like the forms feature of Numbers that is on the iPad. But Apple still hasn't added that to the Mac version of Numbers. I don't think they ever will. So I came up with a script that will do it. This JavaScript (JXA) script in Script Editor will take the values from 4 cells on a second sheet and then use them to create a new row of data in a table on the first sheet. So it is basically like a data entry form. You can put scripts like this in a special Script menu bar icon, and then they only appear when the right app is open. I'll attach the script if you want to try it out.
Note: This is Club MacMost exclusive content. To view this video click the thumbnail below to go to the post as Patreon.com. Once there you will be able to view the video as long as you are logged into your Patreon account and a current supporter of MacMost at the "Club MacMost" or higher level.