Get data from GP so that exsisting data is not over writen using create/update nodes.
Jeanne Allan asked 8 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.
How exactly would this be set up?
As an example, say I wanted an items “description” from GP.
Answers
Best Answer
Arthur answered 8 years ago
Jeanne replied 8 years ago
Arthur replied 8 years ago
Arthur answered 8 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
http://www.eonesolutions.com/Manuals/SmartConnect/SmartConnect%202014/?page=smartconnect_mssql_lookup_column
Jeanne replied 8 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 8 years ago yes that sounds right