# Reference several rows to create an event title in Google Calendar

**URL:** <https://connect.superhuman.com/t/reference-several-rows-to-create-an-event-title-in-google-calendar/8996>\
**Category:** Ask the Community\
**Created:** [July 6, 2019, 9:40am UTC](https://connect.superhuman.com/t/reference-several-rows-to-create-an-event-title-in-google-calendar/8996 "2019-07-06T09:40:11Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jose\_Ruy\_Sa\_Ribeiro](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jose_ruy_sa_ribeiro/32/7933_2.png) [@Jose\_Ruy\_Sa\_Ribeiro](https://connect.superhuman.com/u/Jose_Ruy_Sa_Ribeiro)\
**Post date:** [July 6, 2019, 9:40am UTC](https://connect.superhuman.com/t/reference-several-rows-to-create-an-event-title-in-google-calendar/8996/1 "2019-07-06T09:40:11Z")

</div>

Hi everyone,

Looked it up for a while now and can’t seem to find it.

Here is what I have: a table where I am organizing my Airbnb business. I create new guests with a button where I insert each data individually (say check in date, check out, name, number of people and the apartment they are staying in, for example) and I added a button to automagically add it to my Google Calendar. So far so good. I would like the title of the event to be the name of the apartment, the name of the guest and the number of people by automatically pulling that information from the row but can’t seem to find how to do it.

Am I missing something?

Thanks in advance!

edit: typos.

---

<div class="post-metadata">

**Author:** ![Jean\_Pierre\_Traets](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jean_pierre_traets/32/16275_2.png) [@Jean\_Pierre\_Traets](https://connect.superhuman.com/u/Jean_Pierre_Traets)\
**Post date:** [July 6, 2019, 9:43am UTC](https://connect.superhuman.com/t/reference-several-rows-to-create-an-event-title-in-google-calendar/8996/2 "2019-07-06T09:43:17Z")

</div>

Dear @Jose_Ruy_Sa_Ribeiro,

This formula will do the job for you:

> **[Coda | Formula library](https://coda.io/formulas#Concatenate)**
>
> A.k.a. the official book of Coda spells. Our formula library is a comprehensive list of everything cool that comes after "=" in Coda.

---

<div class="post-metadata">

**Author:** ![Jose\_Ruy\_Sa\_Ribeiro](https://yyz1.discourse-cdn.com/coda1/user_avatar/connect.superhuman.com/jose_ruy_sa_ribeiro/32/7933_2.png) [@Jose\_Ruy\_Sa\_Ribeiro](https://connect.superhuman.com/u/Jose_Ruy_Sa_Ribeiro)\
**Post date:** [July 6, 2019, 9:44am UTC](https://connect.superhuman.com/t/reference-several-rows-to-create-an-event-title-in-google-calendar/8996/3 "2019-07-06T09:44:48Z")

</div>

Yes! That is it! I was missing the vocabulary.

Thank you @Jean_Pierre_Traets. Have a great weekend.