Hi team,
I am trying to save data in Appian db. I am using the records to fetch the data. I have created a record action for data creation too but that is not working fine.
When I click on the above create suite option, it opens up a form like below:-
The expression rule for the above form is given below- [At line 16th, If I put value: local!UUID, it does not works but if I put value: ri!record.uuid, I am able to save the data in db. But I want to save a auto generated UUID and hence used local variable]
a!localVariables( local!UUID: rule!BTUA_GenerateUUID_Expression(), a!formLayout( label: "Create Suite", contents: { a!columnsLayout( columns: { a!columnLayout( contents: { a!textField( readOnly: true, label: "Uuid", labelPosition: "ABOVE", required: true, value: local!UUID, saveInto: ri!record.uuid, characterLimit: 300, ) } ), a!columnLayout( contents: { a!textField( label: "Suite Name", labelPosition: "ABOVE", required: false, value: ri!record.suitename, saveInto: ri!record.suitename ) } ) } ) }, buttons: a!buttonLayout( primaryButtons: { a!buttonWidget( label: "Submit", submit: true, validate: true, style: "PRIMARY" ) }, secondaryButtons: { a!buttonWidget( label: "Cancel", value: true, saveInto: ri!cancel, submit: true, style: "NORMAL", validate: false ) } ) ) )
Now when I am providing some text value to suite name and hitting on submit button. Its not getting saved and giving me following error:
Also in the table, the value of UUID is not getting saved due to which the issue is happening with the sync
Could u pls help in fixing this ?
Discussion posts and replies are publicly visible
To save the UUID to record use the below expression as suite name Text field.
a!textField( label: "Suite Name", labelPosition: "ABOVE", required: false, value: ri!record.suitename, saveInto:{ ri!record.suitename, a!save(ri!record.uuid,local!UUID) } )
This time, the data is not getting stored in db however the above error has been gone, could u pls look into this ?
This might be related to the process model configurations. Please add some screenshots of your configurations of the Write to DSE node in your PM.
But I am doing this using a record action
When you try to run an instance, can you see the values in the process details?
Thanks Harshit, the above solution worked.