Record Field Id

Question

Hi everyone , 
 I have scenario where my data is stored in Map/Dictionary. 
 Now this has to be stored in record. Each field to be mapped with the respective record field. Considering the volume, Is there a way to use the Field Id to map the value. Example: 
 a!localvariables( 
 local!list:{ { columnName:"Name", recordFieldId"4567898765" }, 
 { columnName:"Desc", recordFieldId"4567856894" }, /* Now the data to be mapped */ a!foreach( locaL!list, index(record,fv!item.recordFieldId,null) ) 
 )

Shubham Aware · Answer

No, you cannot use Field IDs to dynamically map data to records. /* Method 1: Direct casting (recommended for volume) */
cast(
 recordType!YourRecord,
 local!mapData
)

/* Method 2: Using record constructor */
recordType!YourRecord(
 recordType!YourRecord.fields.name: local!mapData.name,
 recordType!YourRecord.fields.desc: local!mapData.desc
)

/* For Bulk Operation */

a!forEach(
 items: local!listOfMaps,
 expression: cast(recordType!YourRecord, fv!item)
)
 Field IDs are internal and not accessible for dynamic referencing. Use field references with dot notation instead.

Mathieu Drouin · Answer

Have you considered making a dictionary/map mapping the fieldName to the recordField to store the mappings and then using that for the copy? This would allow you to have recordFields using relationships.

Shubham Aware · Answer

When field names differ between source and record, you must manually map each field using recordType!Record.fields.fieldName: sourceData.differentName. Direct casting only works when field names match exactly. Related records require separate handling after parent records are created.

Shubham Aware · Answer

Let's give it a try by doing this, Update an Rule MCI_returnRecordFieldBasedOnLabel a!localVariables(
 local!fieldMap: {
 {label: "Name", field: "name"},
 {label: "Description", field: "description"},
 {label: "Status", field: "status"},
 /* Add all 30 field mappings here */
 },

 index(
 index(
 local!fieldMap,
 wherecontains(ri!label, local!fieldMap.label),
 {}
 ),
 "field",
 null
 )
) Use this type of grid code: a!localVariables(
 local!columns: rule!getColumnsFromTable(), /* Your column labels from DB */
 local!data:{}, /* Your data */
{
 a!gridLayout(
 rows: a!forEach(
 items: local!data,
 expression: a!gridRowLayout(
 contents: a!forEach(
 items: local!columns,
 expression: a!textField(
 value: index(
 fv!item,
 rule!MCI_returnRecordFieldBasedOnLabel(
 label: fv!item.columnLabel
 ),
 null
 ),
 saveInto: {
 a!save(
 index(
 fv!item,
 rule!MCI_returnRecordFieldBasedOnLabel(
 label: fv!item.columnLabel
 ),
 null
 ),
 save!value
 )
 }
 )
 )
 )
 )
 )
 }
)