AnsweredAssumed Answered

Caculation based on a value list or total number of records

Question asked by mdphillips on Apr 20, 2014
Latest reply on Apr 23, 2014 by mdphillips

Title

Caculation based on a value list or total number of records

Post

     I have 2 somewhat similar questions. I'm working on a solution to track lodging for our group. I have set up 3 related tables - Lodging, Hotel Rooms and Occupant and using portals to display everything in one layout. In the Lodging table I have fields to track the total rooms, rooms occupied and rooms available. 

     Is it possible to have the total rooms field be auto calculated based on the total number of records from the Hotel Rooms table?

     Some events require us to share rooms so in the Hotel Rooms table I have fields for the # of beds per room and a male/female value list if we are sharing.  On the Lodging table I also have fields for for total number of beds by gender.

     Is it possible to have the total beds fields be auto calculated based on the assigned value of male or female?

      

     Thanks!

      

Outcomes