If Expression

[#1]

Hi,

I want to fill my Listbox only with fields that have field_type 'date'.

I used this expression, but it shows all values of the table. Although But I have different Field_types.

=if(Field_Type = 'Date'),$Field)

Br,

CM

[Anil_Babu_Samineni]

Try this

=if(match(Field_Type , 'Date'),Field_Type)

[#3]

Hi Anil,

Thanks for the reply.

I want to generate the Fieldnames ($Field). But only when the field_type = 'Date'. It seems not to work for me?

Thanks,

Mathias

[sunny_talwar]

Field_Type is a field that comes from the data? May be you need this:

If(WildMatch(Lower($Field), '*date*'), $Field)

[#5]

Hi Sunny,

Field_Type indeed comes from the data. Every Field, has also a Field_Type. Depending on the Field_type (the ones which = 'date'), I want to see the $Field.

Is my question clear?

Br,

[sunny_talwar]

May be this?

If(WildMatch(Lower(Field_Type), '*date*'), $Field)

[#7]

This is the table I have:

Field	FieldType
Name	Normal
Address	Normal
StartDate	Date

I want only the field in the listbox when Fieldtype = 'Date'.

Purpose is to have another listbox with the other fields when FieldType is 'Normal'.

So I want to split up the fields according field_type.

Br,

Mathias

[sunny_talwar · Accepted solution]

May be this?

If(WildMatch(Lower(Field_Type), '*date*'), Field)

and for normal, may be this:

If(not WildMatch(Lower(Field_Type), '*date*'), $Field)

[#9]

Hey Sunny,

Thank you very much. It works now.

But can you explain me the difference between your first and second solution?

Best regards,

MC

[sunny_talwar]

You mean difference between these two expressions

If(WildMatch(Lower(Field_Type), '*date*'), Field)

and

If(WildMatch(Lower(Field_Type), '*date*'), $Field)

I guess you were using $Field before and I changed it to Field