Jump to content

Can I reference an ExternalDataFile in a Template Form?

Recommended Posts

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"

Link to comment
Share on other sites

You can do this with the User Context ID field in the iForm. You'll still have to update the iForm every time they make changes but you shouldn't have to change the product templates at all. We use PHP to convert the customer databases into the iForm format so its a pretty fast process.
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...