i am trying to create a form to record puppy growth weights with the following fields
Puppy (from pick list)
date (set as current date)
time (set as current time)
% growth against birth weight (calculation)
birth weight (this is the one I want to auto fill based on puppy name and can’t work out how to do it. I tried if(X;Y;Z) but could not get it to work. Is this the correct solution or is there a better way to do it )
I would create a second form: puppy_birth with the fields puppy name and birth weight. Maybe birthdate might be of interest as well.
Then you can create a picklist using the data from this puppy_birth form’s puppy name field. The two forms would be linked using a joined relationship using puppy name as the common field.
Using a calculation field, you can now easily retrieve the weight by referencing to the value in the puppy_birth form. Additionally, when you add a new puppy, your picklist is automatically updated too! Obviously, the puppy name field must be unique.