I was wondering if there is a way to access the User information page to obtain the Country and Title from that page, for people that are invited to an Event.
So, I created an Event and invited a number of USER/s. My intention is to access the USER's info pages of those that are part of the "Invite Other" section.
Is this something possible using a formula function?
Thanks on advanced!
I have a number formula, (total time) to obtain StartDate and EndDate duration in hours for every single event. Using the output of that formula I make some calculations.
First I access the event's owner user Country field. I do this to assign him a currency with something like this:
CASE($User.Country, "AUS", "Australian dollar", "US", "United States dollar", "No country assigned to user")
We have an hourly rate for some users and those rates are assign using this type of formulas, field name Hourly Rate :
IF(($User.Country = "CA" ),00.00, IF(($User.Country = "AUS" ),00.00, null))
All this is the output of a field call Activity Total Amount. A simple operation "Total Time * Hourly Rate"
So the request now is to add to the Total Amount formula field the rates for all users that are invited to an event.
So if an event takes one hour I need that the Activity Total Amount reflects amounts from the user that are invited together with the acctivity.owner.
Does this explains better what I'm looking for?