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"