Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created list box with check box, one can select one or many check boxes at a time and these selected fields are added to a table box and now i want to export the fields in custom table, I tried to achieve it by Pick and mach expression but then i came to know pick and Match cant be used with list boxes, i tried using if statement as well but no luck,
When i select one field then column it works perfectly fine but when i select multiple fields columns are not getting added properly, can anyone please suggest what can be done in this case.
expression i am using is as below,
=pick(match(GetFieldSelections(Dimensions_External)='GLBL_COUNTRY',
GetFieldSelections(Dimensions_External)='GLBL_SIC',
GetFieldSelections(Dimensions_External)='Global_Duns',
GetFieldSelections(Dimensions_External)='MAJOR_DIVISION', GLBL_COUNTRY,GLBL_SIC,Global_Duns,MAJOR_DIVISION))
If statement i am using is as below,
=if(GetFieldSelections(Dimensions_External)='GLBL_COUNTRY',GLBL_COUNTRY)
,if(GetFieldSelections(Dimensions_External)='GLBL_SIC',GLBL_SIC)
,if(GetFieldSelections(Dimensions_External)='Global_Duns',Global_Duns)
,if(GetFieldSelections(Dimensions_External)='MAJOR_DIVISION',MAJOR_DIVISION)
Hi,
This won't work as you stated. You can also test this by putting your statement in a text box. You will see that it will return a '-'. This is because a pick(match()) will only pick one value.
What do you mean with exporting the fields in a custom table? You want the users to select their own dimensions? Because if you want this, you can better use the Climber Custom Report which makes it way easier, check the link.
Jordy
Climber
Hi,
This won't work as you stated. You can also test this by putting your statement in a text box. You will see that it will return a '-'. This is because a pick(match()) will only pick one value.
What do you mean with exporting the fields in a custom table? You want the users to select their own dimensions? Because if you want this, you can better use the Climber Custom Report which makes it way easier, check the link.
Jordy
Climber