Conditional validation using LOOP and variables.
SummaryConditional validation using LOOP and variables.
I know this might be strange, but I found a nice post by Mike Henderson. Essbase Users: Data copy inside IF
Based on that, I modified my script using this method to perform conditional validations instead of using IF.
Req: There are several requests with a request id (Tot_requests) that users submit, and management either approves or rejects where Approved will be copied from Working to Final.
Req_Approve is a Smartlist in the form that management selects by Request number.
There are few hundreds of requests, it works if the first request that it pulls either its Approved or Rejects and assumes the same for all requests and copies the data.