Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
May be this?
If(WildMatch(Lower(Field_Type), '*date*'), Field)
and for normal, may be this:
If(not WildMatch(Lower(Field_Type), '*date*'), $Field)
Try this
=if(match(Field_Type , 'Date'),Field_Type)
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
Field_Type is a field that comes from the data? May be you need this:
If(WildMatch(Lower($Field), '*date*'), $Field)
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,
May be this?
If(WildMatch(Lower(Field_Type), '*date*'), $Field)
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
May be this?
If(WildMatch(Lower(Field_Type), '*date*'), Field)
and for normal, may be this:
If(not WildMatch(Lower(Field_Type), '*date*'), $Field)
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
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