2 Replies Latest reply on Oct 28, 2014 1:48 PM by perk

    Calculate multiple dates for a single record

    perk

      Title

      Calculate multiple dates for a single record

      Post

      I am a real estate agent looking to track the activity of my listings, including number of days I held an open house at a given property. Is there a way to create one record for a specific property (i.e. 123 Maple Street) and include a field that allows me to input a date every time I host the property without create a new record for the property? My goal is to have a single record, with a field that calculate the total number of dates I hosted the open house. The fields I am looking to populate are shown below. To clarify, date field is the one that has me perplexed, as I do not know how to add multiple dates without creating an entire new record and date field, as I want it to calculate the number of days hosted. I also want to do the same for number of visitors each day.

      Date - Address - City - Price - # Days Hosted - # visitors

      Thanks.