FluentPro Help Center

What do you need help with?

    Sorry, we didn't find any relevant articles for you.

    Send us your queries using the form below and we will get back to you with a solution.


    Concept

    FluentPro Formulas mimics the syntax and functions set of out of the box Project Server functions, with additional extended functionality. The following new groups of functions are available:

    ExternalData

    • Relational databases data access (MS SQL Server / Oracle / any other database accessible with OLE DB)
    • SharePoint data access (any site/list)
    • Project Site data access (Issues/Risks/Deliverables data from project sites only)
    • XML and REST webservices

    Domain

    • Aggregate function from parent to child entities (e.g. Summary/Average/Count/etc. in Project Enterprise Custom Field based on tasks data in project schedule)
    • Lookup of data from child to parent instances (Setting data in task-level Enterprise Custom Fields in Projects)
    • Data summary/lookup between different instances in Project Server (with no reference to parent-child relationship between entities)

    The complete list of domain function can be found here.

    Generation

    • NewId()
    • NewGuid()

    Unsupported functions:

    • ProjDateAdd
    • ProjDateDiff
    • ProjDateSub

    Was this article helpful?

    Table of contents

      Still can't find what you're looking for?

      Contact Support
      Back To Top