Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Dynamic columns in flex forms — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Dynamic columns in flex forms

Accepted answer
edited Aug 24, 2021 7:10PM in Planning 2 comments


Hi All, Hope you are doing well. 

We  have a requirement to create a flex form and the same flex form should be used for multiple scenarios ( Forecast, Plan , Long Range Plan) . The Years, Periods should be populated in columns as per the scenario selection.

I'm aware that flex forms columns are static and currently we are trying with Dynamic Calc member to display right columns based on scenario selection which is working upon form open however when we refresh the form , columns are displaying for all years which are in form layout definition (i.e. FcstY1, FcstY2, PlanYear, LRPYear1..5).  Example , for Plan scenario it's showing 2023 upon form open , when we refresh, it's showing all other years as well which are related to Forecast/LRP.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!