To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Fast Formula - Global Absence Entry Validation - GET_VALUE_SET Formula
Summary
GET_VALUE_SET FormulaContent
Hi,
I want to create a fast formula controls that if a worker has an absence type A, this worker shouldn't get any absence. To do so I created this fast formula:
l_person_id = GET_CONTEXT( PERSON_ID,0)
l_absence_type_id = GET_CONTEXT( ABSENCE_TYPE_ID,0)
l_person_id_char =to_char(l_person_id)
L_absence_type_id_char = to_Char(l_absence_type_id)
L_PARAM ='|=PERSON_ID='||l_person_id_char||'|=ASSIGNMENT_ID='||L_absence_type_id_char
L_RETURN_VALUE = GET_VALUE_SET('