How can Idaithalam handle some complex assertion?

Using EXCEL FUNCTION. You can build assertion using Excel functions using EvaluateFunctionVariables column

Evaluate the variable created during workflow execution. This will help generate the dynamic variable and values. This execute command using pure EXCEL functions. I have added couple of Date functionality to define values dynamically. This will create variables with evaluated function. Any excel functions can be evaluated during runtime(which script execution) with BDD script.

Of course this will support/evaluate dynamic variables and value needs in IDAITHALAM

Example:

  1. startDate=TEXT(TODAY(),"yyyy-mm-dd")  #today date  - String type
  
  2. expiryDate=SUBSTITUTE(TEXT(NOW()+365, "yyyy-mm-dd HH:\mm:ss"), " ", "T") #future date with yyyy-mm-ddTHH:\mm:ss format
  
  3. success=c~LEN("[firstname]")=3  # will verify if the firstname only 3 character then will succeed
  
  4. fail=c~LEN("[firstname]")=3  # will verify if the firstname only 3 character then will fail
  
  5. length=i~LEN("[firstname]")  # will create Interger variable with value
  
  6. isMatch=b~LEN("[firstname]")=3  # will create boolean variable with value
  
  7. lenghtInDecimals=d~LEN("[lenght]")=3  # will create decimal variable with value