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
ohh I might have focused on the " select write your own expression: it allows related record fields also" and the selected option.
yes, true, that would be something like this ->
if( rv!record['recordType!{42fe68dc-1205-4240-bb84-1cb3065c6210}AT temp2.fields.{7e0ab763-a70a-43c1-95c9-8304cc937922}tempId'] = 15, "TESTCALL", if( rv!record['recordType!{42fe68dc-1205-4240-bb84-1cb3065c6210}AT temp2.fields.{7e0ab763-a70a-43c1-95c9-8304cc937922}tempId'] = 20, "TESTEMAIL ", "" ) )