Issue related with a!writeToDataStoreEntity() function in interface level

Hi Dharma, Once the data is written in DB, on click to the first submit button, you will have to save the fv!storedValues of function a!writetodatastoreentity to the variable, so that the primary key value in db will be updated in the variable. onsuccess parameter of a!writetodatastoreentity function allows you can save the fv!storedvalues to the variable which you are using to update the data. hope this helps.

Hi Dharma Rao (dharmaraok) ,

By reading your description, there may be one of the following issue

1) There a field in CDT which is declared as primary key (auto generate).
i) The data is inserted into db first time and primary key id X is generated.
ii) Trying to insert data second time without setting the primary key field value to X.
Solution: Pass the CDT with primary key field set to X to second a!writeToDataStoreEntity() function

2) There is no primary key field in CDT
Solution: Add/make a field in CDT as primary key. Insert your data to db using first a!writeToDataStoreEntity() function, primary key id X is generated. While executing the a!writeToDataStoreEntity() function second time, set the primary key field value of CDT to X.

Hi Dharma,

it seems in your second form you are not using the primary key value. If you want to update the existing record in from the second form then provide the primary key value in the CDT while using a!writetostatstoreEntity() otherwise every time it will create a new record.

Regards
Abhay Giri

Hi Dharma, simple funda is if primary key is null then it is insert else update. So populate the primary key value in CDT while inserting second form for update.