Solved

Site/Building approver

  • 15 March 2022
  • 1 reply
  • 5 views

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.

icon

Best answer by Nunezma 17 March 2022, 19:21

View original

Reply