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
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]