I have a form call Plants that is filled with a list of products. To update the list I, I import an updated list to another form called Upload Plants that uses the On Success Workflow scrip below to copy the newly uploaded list to the Plants form. This works fine to update existing information if the items match but it does not add new items in the Plants list.  Can someone help me with the logic to do this? My attempt to add a new item is the scrip starting with if(input.Description = Null) but it does not work.

 

plantdata = Plants[PLANT_ID == input.PLANT_ID && STAGE == input.STAGE];

if(input.Description != Null)

{

plantdata.Description=input.Description;

plantdata.PLANT_ID=input.PLANT_ID;

plantdata.STAGE=input.STAGE;

plantdata.Plant_Price=input.Plant_Price;

plantdata.Label_Required=input.Label_Required1;

plantdata.Label_Price=input.Label_Price;

plantdata.Royalty_Required=input.Royalty_Required1;

plantdata.Royalty_Price=input.Royalty_Price;

}