Check a box while opening a new record
I would like to mark the parent record assigned at the same time a new child record is created, in one scenario. So what can I add to the existing 'Add Record' formula to do that? URLRoot() & "db/...
Forum Discussion
Fr the first one, I suggest that you consider an alternative approach. If the "definition" of a parent record being assigned is that it has a child record, how about adding a summary field for the [# of children]
Then make the checkbox field for [Parent Record assigned?] can be
[# of children] >0
or if you prefer to be needlessly verbose,
IF([# of children] >0, true, false)
As for the second question, are you saying that whenever the record is manually edited you want to set a date/time field to now()? If that is the case, why not just use the built in [date modified] field as it will be auto populated with the date/time of the last edit.
Then make the checkbox field for [Parent Record assigned?] can be
[# of children] >0
or if you prefer to be needlessly verbose,
IF([# of children] >0, true, false)
As for the second question, are you saying that whenever the record is manually edited you want to set a date/time field to now()? If that is the case, why not just use the built in [date modified] field as it will be auto populated with the date/time of the last edit.