Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Apr 17, 2021 12:43 PM
I have a small hotel, and I wanted to calculate the number of stays each guest had with us.
Is it possible that I can create a record like this and have the guest email and name as a variable for each column (see attached photo)?
Solved! Go to Solution.
Apr 18, 2021 12:26 PM
I understand thanks.
This is the contacts Table
This is the reservations Table
there are a lot of columns … would you like me to try to get them all?
Apr 18, 2021 12:28 PM
I can’t change the {guestEmail}, cause it’s coming from the API … and it won’t populate automaticlly if I change it
Apr 18, 2021 02:12 PM
In that case you’d leave {guestEmail}
alone and set up an Automation to copy the value from {guestEmail}
into your existing Link To Another Record
-type field which I believe would be {Contacts}
.
This will link all future Reservations records for you. For the existing ones, you could simply copy the entire {guestEmail}
column and paste it into the {Contacts}
.
Apr 19, 2021 07:16 AM
OMG!!! It worked! You are a God!
Steps:
Thanks for your help.