Generate 'Name' field using formula

Hi All,

I have created ‘Vacation’ template space.

For that I want to setup ‘Name’ field based formula as below:
Name = ‘Emp Name’ + ‘Start Date’

  • Where Emp Name is a reference field from another space for Employees
  • And Start Date is Vacation start date from the current Vacation space.

Thank you in advance.

Hey, you can do this pretty easily :slight_smile:

Here’s an example with a formula to get the image below:

Employee.Name + "-" + ToText(Vacation.Start())

Here’s a demonstration of me setting up the Vacation database from scratch:

1 Like

Wow. You are awesome. Thank you. :+1: