i have two tables TPS Interchange and TFM Trinary. Primary key of TFM Trinary is foreing key of TPS Interchange which is Trinary_id . TFM Trinary contains key Column which has some text data like TESTCALL, TESTEMAILalso created a record type TPS Interchange and record type TFM Trinary . Now i want to create an custom field like if 'recordType!TPS interchnage.Trinary_id = 15 then it showsTFM Trinary .key= TESTCALL if 'recordType!TPS interchnage.Trinary_id = 20 then it showsTFM Trinary .key= TESTEMAIL otherwise Default nullHow to do this ?
Discussion posts and replies are publicly visible
hi Klaus34 go to your record and follow the below step:
click on new custom record filed:
select write your own expression: it allows related record fields also
write your expression here: example :
a!customFieldMatch( value: recordType!Order.relationships.customers.fields.supportLevel, equals: 3, then: "Critical Customer Order", default: "Customer Order" )
select & give your custom record filed name and select data type of your field
after completing it will be created and visible in your record as below:
AFAIK sync-time evaluation doesn't allow related record field and a!customFieldMatch() as it says in the screenshot ->
a!customFieldMatch () will work only for Real-Time Custom Record Fields
I think he has highlighted in the image saying to opt real-time evaluation. and the customFieldMatch is an example I assume.
yes as I mentioned
ohh I might have focused on the " select write your own expression: it allows related record fields also" and the selected option.