Jump to content

Search the Community

Showing results for tags 'index'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Welcome
    • Start Here!
    • News
  • Software-Related Talk
    • Documentation
    • Getting Started
    • The JavaScript Library
    • FusionPro® VDP Creator
    • FusionPro® VDP Producer
    • FusionPro® VDP Server (API)
    • FusionPro® Expression®
    • MarcomCentral®
  • Support
    • Issues, Questions, Etc.
    • Digital Workflow Documents
    • Fonts
  • Off Topic
    • Customer Polls
    • Job Board (Moderated)
    • Reviews, Rants, and General Musings

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


About Me


Location


Occupation


FusionPro VDP software version


OS


Acrobat Version


Homepage


ICQ


AIM


Yahoo


MSN


Skype


User Title

Found 1 result

  1. Hi- I need to be able to create a dynamic index from a provider listing that's built from external data with multi-line records. I need the index to report back the page that the Provider is listed on in the listing part (code below). Seems like I should use cross reference tags, but I can't figure out how to apply that given that I'm looking for a specific provider's name among hundreds that are listed in the directory by specialty. The index is to be displayed in alphabetical order, show the provider's name, specialty and page number that it appears on. Any ideas? This creates the provider listing just how i want it - Now I just need to create the index and populate the page that they fall on. var result = ""; Provider = new ExternalDataFileEx("providers.xlsx", "Excel", "providers"); var rows = Provider.SortBy("SPECIALTY").FindRecords("Adult Companion"); var content_fields = ["last_name","address1","address2","address3","city","state","zip","phone","hours","URL"]; for (ri = 0; ri < rows.length; ri++) { result += "<p>"; // loop through each value of content_fields array for (i = 0; i < content_fields.length; i++) { // check to make sure there is a value for the content field if (Provider.GetFieldValue(rows[ri], content_fields[i]) != '') { if (content_fields[i] == 'last_name') { result += "<b/><color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "</b><br>"; } else if (content_fields[i] == 'address1') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'address2') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'address3') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'city') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ ", "; } else if (content_fields[i] == 'state') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ " "; }else if (content_fields[i] == 'zip') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'phone') { result += "<color name=black>" + "Phone/Telefono: " + Provider.GetFieldValue(rows[ri], content_fields[i])+ " <br>"; }else if (content_fields[i] == 'hours') { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; }else if (content_fields[i] == 'URL') { result += "<color name=black>" + "URL: " + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; } else { result += "<color name=black>" + Provider.GetFieldValue(rows[ri], content_fields[i])+ "<br>"; } } } result += "<br></p>"; } return result;
×
×
  • Create New...