[progress Communities] [progress Openedge Abl] Forum Post: Re: Total Calculation Based On...

  • Thread starter Thread starter Nitin Kumar Singh
  • Start date Start date
Status
Not open for further replies.
N

Nitin Kumar Singh

Guest
Hi Ramon, Value of workflow status can be queried inside formula area for expression/formula fields using integration code of the field such as if("{!R1677405.status#code}" == "APR") { } or if we are querying the database then as Select name from Exception where status = 1677483; Here, status is the integration code of the field: Workflow Status APR/1677483 - is integration code/id of "Approved" status I have designed a basic application around your use case, with 'Project' as primary record and 'budget' and 'exceptions' as related records. Using this metadata, i have calculated initial funding and 'approved' exception based funding as expression fields. I'm attaching the app xml. See, if this helps. (Please visit the site to view this file) Thanks, Nitin

Continue reading...
 
Status
Not open for further replies.
Back
Top