Matching text and text list
Hello Community, I am trying to match a text field with a text list formula field, by using the contains functions but it is not giving me an exact match. eg : if text list contains apple ; orang...
Forum Discussion
Use a query formula with "has"
// the first half of the query {3.EX." & [Record ID#] is there to limit the search to this record only
//replace _fid with the field ID of the multi-select field and [Text Field] with the name of the text field
var text qry = "{3.EX." & [Record ID#] &"} AND {_fid.has." & [Text Field] &"}";
//size should only be able to return 0 or 1, so if it is 1 return true and check the checkbox
Size(GetRecords($qry)) = 1------------------------------
Simon H
------------------------------