Problem while using SAIL dropdown

skumar over 10 years ago

Hi All,

Would like to share with you guys problem we're facing while using Sail dropdown. Please find problem explained below.

We've two single select dropdowns list a. Team list and b. Analyst list on a Tempo Report.

We're resetting value of Analyst list to its default value i.e "Please Select" on change of Team List. This is happening fine but after then it doesn't allow me to change value of Analyst list & eveytime it reset to its default value.

For your reference please find code below. Many Thanks in advance.

=load(
                    local!team: 1,
                    local!user_name: null,
                    local!pre_team: local!team,
                    with(
                                        local!user_name: if(local!pre_team=local!team,local!user_name,null),
                                        local!pre_user:if(local!pre_team=local!team,local!pre_team,local!team),
                                        a!formLayoutColumns(

                                                            columns:{
                                                  a!columnLayout(
                                                                      contents: {a!sectionLayout(
                                                                                          label: "Report Filters",

                                                                                          firstColumnContents: {
                                                                                a!dropdownFieldByIndex(
                                                            ...

Discussion posts and replies are publicly visible

Parents

0 sikhivahans over 10 years ago

Hi skumar, here goes the code which meets your requirement.
=load(
local!team: 1,
local!user_name: null,
local!pre_team: local!team,
with(
          local!dummy:null,
          a!formLayoutColumns(
                    columns:{
                              a!columnLayout(
                              contents: {a!sectionLayout(
                                        label: "Report Filters",
                                                  firstColumnContents: {
                                                            a!dropdownFieldByIndex(
                                                                      label: "Team",
                                                                      instructions: "Select Team To View Company Report",
                                                                      multiple: false,
                                                                      disabled: false,
                                                                      choiceLabels: {
                                                                      "Services",
                                                                      "Software"
                                                                      },
                                                                      value: local!team,
                                                                      saveInto:
                                                                      {
                                                                      local!team,
                                                                      local!user_name<<rule!APN_returnFirstInput(null,_)
                                                                      }
                                                            ),
                                                            a!dropdownFieldByIndex(
                                                                      label: "Analyst",
                                                                      instructions: "Select Analyst To View Company Report",
                                                                      multiple: false,
                                                                      disabled: false,
                                                                      placeholderLabel: "Please Select",
                                                                      choiceLabels: if(local!team=1,{"Avish","Sandeep","Shaily","Vikas"},{"Manu","Apporv"}),
                                                                      value: local!user_name,
                                                                      saveInto:local!user_name

                                                            )
                                                  }
)}
)

}
)
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 sikhivahans over 10 years ago

Hi skumar, here goes the code which meets your requirement.
=load(
local!team: 1,
local!user_name: null,
local!pre_team: local!team,
with(
          local!dummy:null,
          a!formLayoutColumns(
                    columns:{
                              a!columnLayout(
                              contents: {a!sectionLayout(
                                        label: "Report Filters",
                                                  firstColumnContents: {
                                                            a!dropdownFieldByIndex(
                                                                      label: "Team",
                                                                      instructions: "Select Team To View Company Report",
                                                                      multiple: false,
                                                                      disabled: false,
                                                                      choiceLabels: {
                                                                      "Services",
                                                                      "Software"
                                                                      },
                                                                      value: local!team,
                                                                      saveInto:
                                                                      {
                                                                      local!team,
                                                                      local!user_name<<rule!APN_returnFirstInput(null,_)
                                                                      }
                                                            ),
                                                            a!dropdownFieldByIndex(
                                                                      label: "Analyst",
                                                                      instructions: "Select Analyst To View Company Report",
                                                                      multiple: false,
                                                                      disabled: false,
                                                                      placeholderLabel: "Please Select",
                                                                      choiceLabels: if(local!team=1,{"Avish","Sandeep","Shaily","Vikas"},{"Manu","Apporv"}),
                                                                      value: local!user_name,
                                                                      saveInto:local!user_name

                                                            )
                                                  }
)}
)

}
)
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data