Hi,
I have an editable grid in which I have column with dropdown in it. I am trying to call submit to update values in selected row. I have been able to select single row in a rule input variable where when I change any value from dropdown the value gets changes. The issue I am facing is to insert that updated row in DB.
Please suggest.
a!dropdownField( label: "Assigned To", labelPosition: "ABOVE", placeholder: fv!item.assignedTo, choiceLabels: { "Anil Verma", "Amit Singh", "Gaurav Singh", "Praveen Kumar", "Sumit Mehta" }, choiceValues: { "Anil Verma", "Amit Singh", "Gaurav Singh", "Praveen Kumar", "Sumit Mehta" }, saveInto: ri!rwmActivity.assignedTo, searchDisplay: "ON", disabled: local!editAssignedToField, validations: {} )
Discussion posts and replies are publicly visible
Maybe this helps
https://docs.appian.com/suite/help/20.3/recipe-use-the-write-to-data-store-entity-smart-service-function-on-an-interface.html
Thank, it solved 50% of my issue, but I am getting an exception now (below)
Interface Definition: Expression evaluation error: An error occurred while executing a smart service: An error occurred while trying to write to the entity “Creativity” [id=049bc51f-d0da-4a48-8da3-e441fd049429@38159, type=Creativity (id=7250)] (data store: Creativity Data Store). Details: org.hibernate.id.IdentifierGenerationException: ids for this class must be manually assigned before calling save()
You probably did not enable auto generation of the primary key for your CDT. You might need to recreate the table in DB to make Appian add this attribute.
Worked thanks :)
Please help me with this as well, I have imported interface-1 in interface-2, Interface-1 contains a form with one paragraph box and a submit button (already working, I can put some text in there and hit submit it gets written in the DB), I am trying to pass text from Interface-2 (where I have imported it) and expecting it should work as it is already working independently.
Please help me with it.