Skip to main content
Participating Frequently
June 23, 2017
Question

How to pull data from attachment?

  • June 23, 2017
  • 1 reply
  • 1869 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.

1 reply

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.