Iam trying to add a new row link to the editable grid, The data entered in the new row shoud be saved to Database. anyone give suggestions.
Discussion posts and replies are publicly visible
Add the brackets () after the record reference in your value parameter.
value: recordType!KNS Product Details()
Thank you Harshit bumb, I have corrected the mistake but again getting error while saving the values from the New Row
a!localVariables( local!data:rule!IT_getProductDetailsFromRecord(), { a!cardLayout( contents: { a!gridLayout( label: "Product Details", labelPosition: "ABOVE", headerCells: { a!gridLayoutHeaderCell(label: "Product Id"), a!gridLayoutHeaderCell(label: "Name"), a!gridLayoutHeaderCell(label: "Category"), a!gridLayoutHeaderCell(label: "Price"), a!gridLayoutHeaderCell(label: "Brand"), a!gridLayoutHeaderCell(label: "Rating") }, columnConfigs: {}, rows: { a!forEach( items: local!data, expression: a!gridRowLayout( contents: { a!integerField( value: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{153b4a0d-fa28-42b1-93a8-743296065f94}productid'], saveInto: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details'] ), a!textField( value:fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{7d9347e6-175d-4ce7-8518-ac7d3a3188e5}name'], saveInto: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{7d9347e6-175d-4ce7-8518-ac7d3a3188e5}name'] ), a!textField( value: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{0bd23d9d-6272-4401-ad24-11178974ad9d}category'], saveInto: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{0bd23d9d-6272-4401-ad24-11178974ad9d}category'] ), a!integerField( value: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{479ce285-bbc8-4712-90b5-c171f482c82f}price'], saveInto: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{479ce285-bbc8-4712-90b5-c171f482c82f}price'] ), a!textField( value: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{d7bfc7af-8dc8-4918-8bed-72ca1c5ab151}brand'], saveInto: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{d7bfc7af-8dc8-4918-8bed-72ca1c5ab151}brand'] ), a!floatingPointField( value: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{dd8acd71-e555-4d3d-81d2-dc28c41273ef}rating'] , saveInto: fv!item['recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details.fields.{dd8acd71-e555-4d3d-81d2-dc28c41273ef}rating'] ) } ) ) }, addRowLink: a!dynamicLink( label: "Add New Record", value: 'recordType!{271af57d-1ea1-4b98-bd80-8092624e72b6}KNS Product Details'(), saveInto: { a!save(local!data,append(local!data,save!value)) } ), selectionSaveInto: {}, validations: {}, shadeAlternateRows: true ), }, height: "AUTO", style: "TRANSPARENT", marginBelow: "STANDARD" ) } )
Do you try to use dot-notation somewhere?
https://docs.appian.com/suite/help/23.4/reference-records.html
The problem is on line 27
no ,i have indexed all record fields properly
On line 27, you haven't added any sort of field after the record reference
Thank you for the correction,
New row is adding to the grid, and could you please help me with Saving the new data to the DB table!
For that, you will need to pass this data in the process model. And then after the User Input task, you can simply add a Write Record Smart service that writes the data in the DB
https://docs.appian.com/suite/help/23.4/Write_to_Data_Store_Entity_Smart_Service.html
https://docs.appian.com/suite/help/23.4/Write_Records_Smart_Service.html
Thank you very much Harshit Bumb, cant we submit and save data from the grid itself to the record and the record should be sync to databse?