Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
In the multi box object, when no value is selected i need to show 'Please select value' or '-select-'
Please guide me.
Try this one it will work
In Label u can add This one
=if(GetFieldSelections(Month),'Month','Select Value')
You can try the below expression in label of each field like:
for 1st field:
if(GetSelectedCount(field1)=0 and GetSelectedCount([field2])=0 and GetSelectedCount(field3)=0,'Select field1,'field1');
for 2nd field:
if(GetSelectedCount(field1)=0 and GetSelectedCount([field2])=0 and GetSelectedCount(field3)=0,'Select field2,'field2');
Like this for all fields.
Hi try this
Label expressions for the fields in multibox
Upadte:
=If(GetSelectedCount(Client_Name)>0,'Client_Name','---Select Client_Name---')
=If(GetSelectedCount(Client_Name_Fix)>0,'Client_Name_Fix','---Select Client_Name_Fix---')
=If(GetSelectedCount(Reference_ID)>0,'Reference_ID','---Select Reference_ID---')
Hope this helps you..
Hi all,
Thanks for the responce.
But my requirement is not to show the label as '-select-' but to show in the values place a select when no value is selected.
i tried 'if(gectselectioncount(field)>0,field,'select')' as calculated field, this worked good to show 'select' but unable to make selection.
If you want the lable to read 'Select' only use the same as the example that Ravi Kumar supplied but change the label for the Say Level field to :
='if(Len(Level) = 0, 'Select', 'Level') and this would show the label 'Level' only when a value has been selected.