Question

Wanted to add new custom field

Forum|Forum|2 years ago
January 18, 2024
12 replies
2 views

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, TESTEMAIL

also 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 null

How to do this ?

amaans4178

when creating a custom field make sure to select write your own expression and Real-time evaluation as it will allow you to use related record field.

harshitb6843

[mention:0591d80bf3a5406ebeb3855605fe90c0:e9ed411860ed4f2ba0265705b8793d05] Any of the above would work here considering that the 'Trinary_id' is present in the base record where we are creating the custom record field so we do not need related record fields. So we can use any of them. The real-time will need more evaluation time as it will evaluate the values in the real-time. And sync time is calculated when the data is synced.

For a more performant view, I will advise using sync time evaluation along with if() function to check.

amaans4178

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 ",
    ""
  )
)

karumurua531442

hi [mention:0591d80bf3a5406ebeb3855605fe90c0:e9ed411860ed4f2ba0265705b8793d05] 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"
)