I am using Nintex k2 5 and I created a form to retrieve employee details in a form from the database (smartobject) the form has employee number ,employee name,employee business unit and other fileds like (amount,date,..) when I picked employee number (employee number is a picker list) the rest fields (employee name,employee business unit) displayed automatically in the form from the smartobject , what I want is when I fill the rest fields ( date,amount) and click sumbit button all the fileds data I want them to be added to the smartobject not in a new record I want it to be added in the same record of the employee number I picked,how can I do this
Solved
Nintex Automation
+3Best answer by Frankenbeanie
Hi Aala
Are you using the sql database? Does the table your smartobject is based off has a primary key? if yes then you need to retrieve the primary key(PK) of the row(employee in the picker) you are wanting to update. Once you have the pk you just need to configure a rule to ‘execute a smartobject method’ and then choose your smartobject and ‘update’ method and then configure the fields.
Hopefully, you have what you need to make it work. if not please let me know
Translate
+2Hi Aala
Are you using the sql database? Does the table your smartobject is based off has a primary key? if yes then you need to retrieve the primary key(PK) of the row(employee in the picker) you are wanting to update. Once you have the pk you just need to configure a rule to ‘execute a smartobject method’ and then choose your smartobject and ‘update’ method and then configure the fields.
Hopefully, you have what you need to make it work. if not please let me know
Translate
+3still have the same problem in the first photo there are two records I want only one record to appear with the updated data additionally I don’t have update method and I tried to configure it using save ,but it didn’t work
Translate
+2save method should do what update does.
Can you share the configuration screenshot of input properties of your save method rule? Is ‘employees’ smartobject based off a sql table? is ‘employee code’ the unique primary key of the table?
Translate
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.