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
kishore nanda
Hi Kishore Within the gridlayout 27 line you are missing saveInto...need to give the field(productId) name use dot-notation
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 .. I have corrected
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