Let me start by saying I’m not a programmer, and I’ve searched for this answer, but cannot find how to implement.
I’m using Plumsail Forms for SharePoint online. The list my form is based on is for “Facility Tickets” and has a lookup field to another list called Vendor. In addition to the ID and DisplayName, it also gets additional fields:
On my form, I have the lookup field drop down, and it works as expected. I can click the dropdown for Vendor and it gives me the Vendor’s Names from the Vendor List. What I’m trying to accomplish is that when you select the Vendor from the drop down, that it would show, or auto-populate additional controls/fields on the form for the Vendor SupportPhone or SupportEmail. I want this done dynamically so that the person creating the ticket can see the phone number immediately without having to save the form and re-open it. I don’t want it to display the number in the dropdown itself, as I want them to select the vendor, and then it will show all the relative vendor information for the selected vendor. Then they can email, call, know the account number, etc.
I’ve found this article by searching the community and I think it’s asking the exact same thing, but understanding what code to use and where that code actually goes is beyond me. Auto-populate columns based on lookup
I have added “Extra” fields in the control of the lookup for SupportPhone, however, I do not know what to do with it. I can supply any other information that would be helpful. I have figured out other pieces of code and added to JS, so I’m not a complete novice, I’m just not a programmer by trade.
Any help you can provide would be most appreciated. I love your product and we use it on several lists.
Gary, Carolina BioOncology Institute