Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
May I know the meaning for this script::
IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',
IF((NOT IsNull(PO_NUMBER) OR LEN(TRIM(PO_NUMBER)))<>0,'Project Completed',
IF(Not Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED'), 'SOW Acceptance Pending',
IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED')
AND (ISNULL(RFQ_NO) OR LEN(TRIM(RFQ_NO))=0)
,'Sourcing Initiation Pending',
Hello,
IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'REJECT*'),'SOW Rejected',
this line mean that if the field [SOW_APPROVAL_STATUS] on upper format have on it begining the word REJECT remplace it with the new value = 'SOW Rejected'
-----------------------------------------------------------------------------------------------------------------------------------------------------
IF((NOT IsNull(PO_NUMBER) OR LEN(TRIM(PO_NUMBER)))<>0,'Project Completed',
this one mean that if the field [PO_NUMBER] is not null , have a value and not empty by testing the length of it and if it's <> to 0 , we gonna replace the value of the field [PO_NUMBER] by 'Project Completed'
-----------------------------------------------------------------------------------------------------------------------------------------------------
IF(Not Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED'), 'SOW Acceptance Pending',
here we test if the value of the field [SOW_APPROVAL_STATUS] in upper format is not matching APPROVED we replace it by 'SOW Acceptance Pending'
-----------------------------------------------------------------------------------------------------------------------------------------------------
IF(Wildmatch(UPPER(SOW_APPROVAL_STATUS),'APPROVED')
AND (ISNULL(RFQ_NO) OR LEN(TRIM(RFQ_NO))=0) ,'Sourcing Initiation Pending',
the last lines means that if the field [SOW_APPROVAL_STATUS] in upper format is matching APPROVED and the other condition it's if the field [RFQ_NO] is null , have no value and empty by testing the length of it, if the conditions are confirmed we replace the value of the field [SOW_APPROVAL_STATUS] by Sourcing Initiation Pending