Hello,
I need some help from the experts please. I appreciate that 1 form.PNGmy question has already been raised several times but I could not find the real code that would make my project work. Hence my request for help from you.
The objective: I would like to be able to auto-populate the 'Assigned to' field with the corresponding value as soon as the field 'Supplier Name' is selected on the Supplier Details section of the form, which is dependent on the 'Product or service' field on the Lead Details section of the form.
The issue: I managed to find a way to work out the procedure from 'Product or Service' to 'Supplier Name' without a big issue. And every time I change the value of 'Product or Service' automatically 'Supplier Name' changes to corresponding options.
However, the code doesn't necessarily work when it comes to 'Assigned to' procedure because as soon as it assign one value, that value will also stays there although I selected different value from either 'Supplier Name' or 'Product or Service'.
The problem here is that, let's suppose the value selected in the field 'Supplier Name' was incorrect. If I then change that value to the correct one, 'Assigned to' field will retain the previous value allocated there from the incorrect value of 'Supplier Name'
Possible Solution: I assume, I should clear that field every time the value of 'Supplier Name' changes but unsure how to do that. Also, I'm sure there is a better way to execute this event from a simpler code, though this is only an assumption.
Any help from you is greatly appreciated. Thank you very much
Please Login or Register to view this content.
Bookmarks