Skip to content
+1-888-319-3663

COMMUNITY FORUM

Get data from GP so that exsisting data is not over writen using create/update nodes.

Jeanne Allan asked 6 years ago
Rather than overwrite a value I don’t want to change – can I get the value from GP?
How exactly would this be set up?
As an example, say I wanted an items “description” from GP.
 
Answers
Best Answer
Arthur answered 6 years ago
I use the msql lookups, it is quite useful especially if you want users to be able to upload changes to ETA’s etc without adding new lines for example.
http://www.eonesolutions.com/Manuals/SmartConnect/SmartConnect%202014/?page=smartconnect_mssql_lookup_column
Jeanne replied 6 years ago

Thank you very much!

Thank You!
That sounds like it would work….
So in my example above…., if I were adding a new piece of information to every items inventory record – UDF1 for example – and the items and the description field were required I could use the lookup to return the current data to the required fields for existing items, but not accidentally create a new item if I had a typo in the item number, as the item would not be found I could just reject the record…..

Arthur replied 6 years ago

yes that sounds right


If you would like to submit an answer or comment, please sign in to the eOne portal.