So the title of this question may be deceiving. To start with, I attached the file I am working on so that you can follow along as I explain. So I have records under the Data layout which can contain multiple Mice, and for each Mouse I enter some data such as Date and Size. What I would like to do, ideally, is if I have multiple mice for a record, I would like the Dates from Mouse 1 to automatically appear for Mouse 2 and Mouse 3, etc. It would just save me a lot of time when entering data. I only want this for the Date, not the Size. Can anybody help with the easiest way to do this?
p.s. Full disclosure: I had help making the file up to this point. So I know as I add Mice it corresponds with another layout, but I am not sure how, sorry if that is an issue. I am sure you guys know better than me.
I read that as that, when you add the record for Mouse 1, you want the data in certain fields to become the default values for any subsequent new mouse records until/unless you enter new data. This raises a possibility that the data shouldn't be in that record in the first place as entering the data into a single related record would avoid the need to copy such data from record to record, but leaving that aside for the moment, here's an option that you can experiment with:
You can define such fields to auto-enter the value of some global variables (or global fields). Just update the values of these variables/fields each time you need a new default value and it will work.
So a Date field might have
$$Date
as it's auto-enter calculation
If you set up the OnObjectSave trigger on this same field to be this:
Set Variable [$$Date ; Mouse::Date ]
Then any new date that you enter into the field will update the value of $$Date to serve as a new default value.
There are also ways to auto-enter data from the "previous record" that can be useful options, especially if you enter data on a list view layout.