Default value with calculation and parent values

✨ Feature Requests
1

In ‘Edit field’ it is possible to enter a default value. That is a hardcoded value.
What I need is a way to establish a default value dynamically.

a) The easy way would be to be able to enter a calculation. That would make it possible to use other record fields, dates, user name, etc. to establish a default value.

b) In my case, that would not be enough. We have Events that consists of multiple Meetings. The user first creates an Event, and then creates related Meetings. The user has to enter the Meeting Date and the Employee twice: once in the Event, and copy it in every Meeting in the Event. When creating the Event, I would like it to default those fields from the Event record.
So, the calculation should be able to look in the parent record as well.
(The Meetings can take place without an Event as well, that’s why those fields are in the Meetings record ánd in the Event record.)

2

You hide the fields when an event is linked. And then use automation to fill the fields with event details on submit.

This way users can fill the fields when no event is linked, and skip them when linked to an event.

This should get you the same functionality as a workaround if nothing less.

3

Thanks for this great idea. Sometimes an event is more than one day, with meetings In the course of those days. In that case they must be able to enter a day or two later than the event start date.
So hiding meeting date is no option. I could show a hint: “leave blank if the same as the event date” but a default value is more user friendly.

4

I don’t disagree. Default values for settings would be useful for some cases.

Out of curiosity, how would a user know if the event should be x or y days? If there a way to have a field that defines the the cadence, you could use that in the automation to set the date… Again, just thinking out loud here.