If/Then based on reference field
- April 18, 2023
- 1 reply
- 1723 views
New here, so I apologize if I don't follow proper procedure. Thank you, Thom Parker, for your assistance and I apologize for the delayed check on correct answer from previous question. I have another question regarding my project. Attached are two pages from my project.
Goals:
- To auto populate Name, Agency, Phone, and Email based on drop down list in far-left column (Position) on page 2.
- To utilize same function script (Name, Agency, Phone, Email) for all rows by using split shift to use Row# reference instead of a separate function for each row.
Document:
- Pg 1 only has 10 rows for reference for testing
- Pg. 2 only has one row with one (Name, Agency, Phone, & Email) for testing
I am not having any luck with the script below to populate name based on listed position. Suggestions?
////Script Name: ICS-205A drop
function DoNameReferencePosition()
{
var cRowName = event.target.name.split(".").shift();
var fieldB = this.getField(cRowName + ".205A DropA").value;
if (fieldB == this.getField("Row1.Position").value) event.value = this.getField("Row1.Name").value;
else if (fieldB == this.getField("Row2.Position").value) event.value = this.getField("Row2.Name").value;
else if (fieldB == this.getField("Row3.Position").value) event.value = this.getField("Row3.Name").value;
else if (fieldB == this.getField("Row4.Position").value) event.value = this.getField("Row4.Name").value;
else if (fieldB == this.getField("Row5.Position").value) event.value = this.getField("Row5.Name").value;
else if (fieldB == this.getField("Row6.Position").value) event.value = this.getField("Row6.Name").value;
else if (fieldB == this.getField("Row7.Position").value) event.value = this.getField("Row7.Name").value;
else if (fieldB == this.getField("Row8.Position").value) event.value = this.getField("Row8.Name").value;
else if (fieldB == this.getField("Row9.Position").value) event.value = this.getField("Row9.Name").value;
else if (fieldB == this.getField("Row10.Position").value) event.value = this.getField("Row10.Name").value;
else if (fieldB =="") event.value="";
}
