New Weight and date fields with related chart
I have to collect weights on random dates for specific studies. I am looking for a way that I can enter a new date and the corresponding weight and have it saved into a table format with a related chart. The problem I have is that I don't want to create a table with pre-selected dates or call them Weight 1, weight 2, weight 3...etc. Is there a format or calculation that will just add every new/modified date and weight to a list?
I am also, in the future, trying to connect this database to a telemetry chip reader and scale. So I want to set it up that the date the "chip" is scanned will auto populate and collect the weight from the scale. (Not really sure if all of that is possible)