# Generate 'Name' field using formula

**URL:** <https://community.fibery.io/t/generate-name-field-using-formula/2377>\
**Category:** Get Help\
**Tags:** formulas\
**Created:** [January 13, 2022, 6:44am UTC](https://community.fibery.io/t/generate-name-field-using-formula/2377 "2022-01-13T06:44:15Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![anand](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/anand/32/4540_2.png) [@anand](https://community.fibery.io/u/anand)\
**Post date:** [January 13, 2022, 6:44am UTC](https://community.fibery.io/t/generate-name-field-using-formula/2377/1 "2022-01-13T06:44:15Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![Haslien](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/haslien/32/493_2.png) [@Haslien](https://community.fibery.io/u/Haslien)\
**Post date:** [January 13, 2022, 10:22am UTC](https://community.fibery.io/t/generate-name-field-using-formula/2377/2 "2022-01-13T10:22:51Z")

</div>

Hey, you can do this pretty easily 🙂

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

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

```

 ![image](https://us1.discourse-cdn.com/flex020/uploads/fibery/original/2X/9/944bd85d8f21f54a9a08211cf302b1eeff59bc24.png)

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

[https://i.thevirt.us/01/I1c89.mp4](https://i.thevirt.us/01/I1c89.mp4)

---

<div class="post-metadata">

**Author:** ![anand](https://sea2.discourse-cdn.com/flex020/user_avatar/community.fibery.io/anand/32/4540_2.png) [@anand](https://community.fibery.io/u/anand)\
**Post date:** [January 13, 2022, 11:19am UTC](https://community.fibery.io/t/generate-name-field-using-formula/2377/3 "2022-01-13T11:19:01Z")

</div>

Wow. You are awesome. Thank you. 👍