hi,
I wanted to set a user filter for my record, which will pull the records based on quarter/month and year. I am trying to avoid the custom record field.
example - Q4 Oct 2024
The field that has date time stamp in my record is "CREATED ON".
Any help is appreciated.
a!customFieldConcat(
{"Q",
'recordType.createdOnQuarter',
" ",
a!customFieldMatch(
value: 'recordType.createdOnMonth',
whenTrue: a!customFieldCondition(
field: fv!value,
operator: "=",
value: 1
),
then: "Jan",
whenTrue: a!customFieldCondition(
field: fv!value,
operator: "=",
value: 2
),
:
:
:
then: "Feb",
whenTrue: a!customFieldCondition(
field: fv!value,
operator: "=",
value: 9
),
then: "Sep",
default: "Oct"
),
" ",
'recordType.createdOnYear'
}
)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.