Flowfield formula

Business Central/NAV Developers Forum
2

If you only want to show the calculated value on an form:

Write a function “CalcMyValue” for your SourceTable and put the function-call as SourceExpression on your form (only “CalcMyValue”).

If you want standard flowfield behaviour you can make something like:

  1. add a new field “StartPreviousYear” (make it editable = no) to the table with your field “Start”
  2. Add “StartPreviousYear := CALCDATE(’-1Y’,PlejeplanRec2.Start)” to the OnValidateTrigger of your field “Start”.
  3. Make your flowfield with the filterexpression Date > StartPreviousYear
  4. (Make sure you call the OnValidate-Trigger - not only assign the date :wink: )

forki