[Can I reference an ExternalDataFile in a Template Form?]

Ahh...OK. I'm currently doing with iForms, so I'll investigate how to make that process faster. Thanks!

[Can I reference an ExternalDataFile in a Template Form?]

I'm working on a Customer that has a master data file of information for each store. Some of their products are ordered by store number, some are ordered by store brand.

 

Currently, I have the iForm set up to populate the form with only the store numbers/brands that the users have in their territory.

 

Problem becomes, if the spreadsheet is updated I need to go through each product and adjust accordingly.

 

Is there a way that I could populate a Form from information found in the ExternalDataFile?

 

Meaning, is it possible to say something along the lines of "If UserID == 'aetheredge', show only values assigned to that user"