Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
name of fields is A1,,B2,C3 IN FRONT END WANT SEE LIKE A OR B OR C OR 1,2,3
try this in ur expression,
=If(col='A1','A',
If(col='B2','B',
If(col='C3','C',NULL())))
OR
=If(col='A1','1',
If(col='B2','2',
If(col='C3','3',NULL())))
HI Prabhas
Looking For Some thing Like This
try
Edit Expression in your listbox
if(nameField=A1,1,
nameField=B2,2,
nameField=C3,3)
if(nameField=A1,A,
nameField=B2,B,
nameField=C3,C)
if(nameField=A1,1,
nameField=B2,2,3)
if(nameField=A1,A,
nameField=B2,B,C)
Regards!
Do you want to display field names in your data model or values of a field?
you can use left (field,1) or right (field,2)
HI Prabhas,
As Anbu said above you want display field or Values of that field, Please let us know.
However, You can use LEFT() and RIGHT() functions to get what you are looking.
Expression1: LEFT(FieldName, 1)
Expression2: RIGHT(FIeldName,1)
Regards,
Vish.
LOAD
A1 as A,
B1 as B,
C1 as C
FROM your data source...
=If(Value='A1','A',if(Value='B1','B',if(Value='C1','C')))
HI
I want display the field names in the front end.
regards,
suresh