Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Using Count to Calculate # of transactions

Solved
Jump to Solution
1729 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Lost-Merovingia
7 - App Architect
7 - App Architect

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)?

Capture.PNG

13 Replies 13

I understand thanks.

This is the contacts Table
image

This is the reservations Table
image

there are a lot of columns … would you like me to try to get them all?

I can’t change the {guestEmail}, cause it’s coming from the API … and it won’t populate automaticlly if I change it

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}.

OMG!!! It worked! You are a God!

Steps:

  1. Create new column (forumla: guestEmail) which just copies that column in to this one
  2. I hid the first guestEmail (cause I know I’ll forget about the automation with the API one day, and edit it
  3. I already had a column that linked to the guest email in the contacts table, so I just copied the entire column and pasted it into the new column

Thanks for your help.