I have a form that has 2 lookup lists that lookup the Site and Buildings, these are 2 separate lists. I also have a third list that contains the approver for the building/site which i would like the approver name and email address to be pulled through from this list onto the form.
I have the lookup lists pulling the data through, but i'd like to have the approver name and email address populated on calculated values.
The formulas that I have used are:
lookup("Approvers","Building",parseLookup(Building),"Approver")
lookup("Approvers","Building",parseLookup(Building),"Email")
But this doesn't pull the data through that I'm expecting. There are 2 sites, both sites could have building names/numbers that are the same, but with different approvers.
