Search the Community
Showing results for tags 'xdf'.
-
Hello, I am working on creating an XDF rule in MarcomCentral to achieve the following: I would like to populate fields in a flyer from an Excel file (.xlsx) based on a user's selection from a dropdown menu. For instance: Users can choose between two managers, John or David. If a user selects 'John,' all of John's information should populate the flyer. If a user selects 'David,' all of David's information should populate the flyer. var XDF = new ExternalDataFileEx("ManagerInformation.xlsx","Excel"); var Manager = ""; var PhoneNumber = ""; var MobileNumber = ""; var EmailAddress = ""; var finaladdress = ""; var i = DeptXDF.FindRecord("Manager", Field("Text_Manager")); if (i>0 && Field("Text_Manager") != "") { Manager = DeptXDF.GetFieldValue(i, "Manager"); PhoneNumber = DeptXDF.GetFieldValue(i, "PhoneNumber"); EmailAddress = DeptXDF.GetFieldValue(i, "EmailAddress"); finaladdress = AppendText(finaladdress, "", Manager); finaladdress = AppendText(finaladdress, "<br>", PhoneNumber); finaladdress = AppendText(finaladdress, "<br>", EmailAddress); } return finaladdress; The reason that I want to use an XDF is because this information is constantly changing If anyone knows if this rule is correct, and the additonal steps I would need to do in order to link the XDF file within MarcomCentral, I would greatly appreciate it.