Any insight on the below issue which we have facing on our project will be helpf

Any insight on the below issue which we have facing on our project will be helpful. I am working on a bug and during project creation if the user selects a Large Store, Convenience Retail or Drug Value originating channel the selection of project subtype should be an optional (not required) selection. The dropdown selection should not be removed.

Could anyone let me know what could be the logic which I should use so that" Project Subtype"should be optional for Large Store, Convenience Retail or Drug Value originating channel .
We are using an expression rule "prmOrigChanHasProjectSubType" to pick the originating channel from the constant used out in this expression that is PRM_ORIG_CHAN_STORE_LG = Large Store

=if(contains({cons!PRM_ORIG_CHAN_REGION, cons!PRM_ORIG_CHAN_STORE_LG, cons!PRM_ORIG_CHAN_CONV_RETAIL, cons!PRM_ORIG_CHAN_DRUG_VALUE, cons!PRM_ORIG_CHAN_CANADA, cons!PRM_ORIG_CHAN_OTHER}, ri!origChannel), true(), false()).

Then we have used ...

OriginalPostID-119955

OriginalPostID-119955

  Discussion posts and replies are publicly visible

  • ..." prmGetProjectProjectSubType" to returns the updated value of Project SubType based on originating channel info.
    =if(rule!prmOrigChanHasProjectSubType(ri!origChannel), if(isNull(ri!origChannelSubType), "N/A", ri!origChannelSubType), "N/A")

    We have used this expression "prmListOrigChanSubTypeByOrigChan" to returns a list of channel sub types by originating channel.
    =if(ri!origChannel=cons!PRM_ORIG_CHAN_REGION, rule!prmListOrigChanSubTypeRegion(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_STORE_LG, rule!prmListOrigChanSubTypeStoreLG(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_CONV_RETAIL, rule!prmListOrigChanSubTypeConvRetail(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_DRUG_VALUE, rule!prmListOrigChanSubTypeDrugValue(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_CANADA, rule!prmListOrigChanSubTypeCanada(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_OTHER, rule!prmListOrigChanSubTypeOther(), ri!origChannelSubTypes))))))

    Finally we have used this expression rule "prmListOri...
  • ...gChanSubTypeStoreLG" to list of originating channel subtypes for Large Store.

    ={null(), cons!PRM_ORIG_CHAN_TYPE_REG_CPI, cons!PRM_ORIG_CHAN_TYPE_REG_NONCPI}

    Could anyone let me know what could be the logic and in which expression rule which I should use so that" Project Subtype"should be optional for Large Store, Convenience Retail or Drug Value originating channel .
  • Then we have used " prmGetProjectProjectSubType" to returns the updated value of Project SubType based on originating channel info.
    =if(rule!prmOrigChanHasProjectSubType(ri!origChannel), if(isNull(ri!origChannelSubType), "N/A", ri!origChannelSubType), "N/A")
    We have used this express "prmListOrigChanSubTypeByOrigChan" to returns a list of channel sub types by originating channel.
    =if(ri!origChannel=cons!PRM_ORIG_CHAN_REGION, rule!prmListOrigChanSubTypeRegion(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_STORE_LG, rule!prmListOrigChanSubTypeStoreLG(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_CONV_RETAIL, rule!prmListOrigChanSubTypeConvRetail(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_DRUG_VALUE, rule!prmListOrigChanSubTypeDrugValue(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_CANADA, rule!prmListOrigChanSubTypeCanada(),
    if(ri!origChannel=cons!PRM_ORIG_CHAN_OTHER, rule!prmListOrigChanSubTypeOther(), ri!origChannelSubTypes))))))
    Finally we have used this expression rule "prmListOrigChanSubTypeStoreLG" to list of originating channel subtypes for Large Store.
    Could anyone let me know what could be the logic and in which expression rule which I should use so that" Project Subtype"should be optional for Large Store, Convenience Retail or Drug Value originating channel .
  • Sudhir, can you please elucidate the above with some clear technical requirements rather posting the concepts.. Just let us know how the input and what is the expected output to look like. Surely we should able to help you.
  • When we select from the dropdown list in the field Originating Channel (Large Store, Convenience Retail or Drug Value).T he selection of field project subtype (CPI, Non-CPI)should be an optional (not required) selection. The dropdown selection should not be removed.
    Current issue is the user must enter this value project subtype (CPI or Non-CPI) in the form. We need this field project subtype (CPI or Non-CPI) as an optional field when the user select the dropdown list in the field Originating Channel (Large Store, Convenience Retail or Drug Value).
  • Please follow up on the other post which already has some answers
  • If its in SAIL you can handle it by storing the user selection in a local variable and giving the condition in the required tag
  • Please mention the Appian version that you are using, if its older version(6.x) then you can use advanced Form utilities
    FormAPI.setRequired(fieldId, required)
    you can download the plugin here forum.appian.com/.../