Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.

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/.../