I want to update a specific row in my recordtype with data in one of the columns as follows:
Here I am using my id (the primary key of the table) to specify which row I wish to update, in this case i want to update case number 80 and update the casestatus column with "accepted", however upon doing so I get the following error:
I am guessing that my syntax is incorrect, but I can't seem to figure out what I am doing wrong exactly.
Discussion posts and replies are publicly visible
Use the correct record type field reference syntax for the id field. Just like you do for the index parameter of a!update.
In the update() the data parameter is configured incorrectly. You need to specify the variable in which your data is present.
a!update( data: index(myVariable[fieldName],80,null), index: recordType.fieldName which you want to update, value: "accepted" )
Hi mohamedz4875 ,
you are trying to get the records by using id incorrectly,
Instead query the record type by using expression rule and put it in a local variable, then update the variable, if you don't use that record type rule input in that interface.Follow the sample code :
a!localVariables( local!customer: rule!RMS_GetCustomerByCustomerId(customerId: 3), a!update( data: local!customer, index: RMS Customer.billAmount, value: 555 ) )
You are referencing the record index in a wrong way. Use one of the following sentences.
index(local!allUsers, recordType!yourRecordName.fields.yourField, {}) local!allUsers[recordType!yourRecordName.fields.yourField]