function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
scriptagentscriptagent 

automatic lookup, how ?

 
I want to create relationships between some fields. Normally a simply Lookup would be enough and I know a Lookup(where you choose a data set from a popuplist) is possible in Salesforce, but I want an automatic Lookup, for example if UserX == profile_HighManager then 80%...elseif UserX == profile_NormalManager == 60% ........ or if UserX choice productA  then discount 20%
Is there a way to develop such a thing without programming or will be Apex necessary ?
I want to call fields from two different tables.
 
Thank you very much! 
Peter
JakesterJakester
Have you looked into the vlookup() function?
scriptagentscriptagent

Hey, thank you very much for the idea.
I used the vLookup and it works!

 



Message Edited by scriptagent on 10-08-2008 07:56 AM

Message Edited by scriptagent on 10-08-2008 07:56 AM
JakesterJakester
Awesome! Could you share the code you came up with? I haven't used vlookups yet myself, and I'm curious to see a real-world example.