I have a list of 24 unique items in a table. I would like to create a form that lists all 24 items with a blank entry field alongside each one. I would like to be able to enter a value in these blank entry fields for any number of the 24 items, and have each item name and the value I entered be stored as a single entry in a new table. For example: I enter a value for 15 of the 24 items. I click a button and 15 new records are made to a table consisting of the item name and the value that corresponds to it.
Is there a way for me to create a data entry form this way?
For more context, I'm tracking my daily habits. I've made a table listing all the habits I want to track. I'd like to be able to record values for multiple habits at once and store them in table (along with the date and time that they were entered).
Thanks in advance for your help!