Searching Dates in General Search

[Rocky Machado]

Hi – I notice when I try and do general search on dates. my records do not show up. Is it because the Date is in a table field within the form? I seem to be able to get the right results when I search text fields in a table.

thanks,
rocky

[Brendan]

Hi Rocky,

That’s right. Date fields can’t be searched via the general search. You need a Saved Search for that. However, Date fields within a Table field can’t be searched at all. I only index the text and numeric data types within a Table field. You could do it by adding a Script field to your parent form which extracts out the date values from your Table field into a single Script field in the parent form. That way when you do a general search you’ll be searching the parent form, not the Table field’s records directly.

Thanks,

Brendan

[Sam Moffatt]

The script I posted for combining multiple values from a child form should also work for tables. I use this to make parent fields searchable by values in their child fields.

[Rocky Machado]

Thanks Sam / Brendan – I created a script and brought the date(s) to the parent form. I can now search using the General Search.

thanks,
rocky

[Author]

Posts