Skip to main content
Participating Frequently
June 23, 2017
Question

How to pull data from attachment?

  • June 23, 2017
  • 19 replies
  • 1909 views

I am trying to pull data from an excel file into a form or text box.

I have tried using importTextData, which works on a one-by-one basis, but can this be used to pull an attached file?

The end result that i'm hoping for (in case there is a better way to do this) is this:

My PDF will be a map with several points on it. I would like each point to be a clickable button/link, and when the user clicks on the point, either a text box pops up with additional info on that site, or there is a form/side panel that displays the additional info.

This topic has been closed for replies.

19 replies

try67
Community Expert
Community Expert
June 23, 2017

You can do it using the getDataObjectContents method.

FyreHawkeAuthor
Participating Frequently
June 23, 2017

I saw some into on getDataObjectContents, but how do I make it look up the specific point that i want into for (each point has a unique ID) and output to the form fields?

try67
Community Expert
Community Expert
June 23, 2017

You need to parse the file, searching for the desired data. I don't know the structure of your file so I can't really help beyond that...

However, this is not going to work with an Excel file (xls/xlsx/etc.). The file will have to be in plain-text format.