Virtualan
logo_-original - Copy.png
  • Twitter
  • Linkedin
  • Home

  • Why Choose Us

  • Our Services

    • Cloud Transformation
    • Digital Transformation
    • ​Technology Consulting
    • Cloud Security
    • QA Engineering
    • Support Consulting
  • Products

    • Virtualan
    • Idaithalam
    • Cucumblan
    • Idaithalam-saas
  • Plans & Pricing

  • About Us

  • Contact Us

  • Forum

  • Privacy Policy

  • Members

  • More

    Use tab to navigate through the menu items.
    To see this working, head to your live site.
    • Categories
    • All Posts
    • My Posts
    Elan Thangamani
    Dec 29, 2021

    How can Idaithalam handle some complex assertion?

    in Questions & Answers

    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
    0 comments
    0
    0 comments

    Contact Us

    Thanks for submitting!

    Address: 

    2020 Calamos Court, Suite 200, Naperville, Illinois 60563

    Tel. 1-‪773-657-5917‬  

    Email. info@virtualansoftware.com   

    © 2023 by Virtualan Software

    Top of Page