need to build a view that takes the first entry in a multiple entry field (delimenter is “;”). Depending on the value in this fld the record then needs to be recategories under one of three twisties. I know how to create a table for the three recategories that need to be established simply by setting up a table for each value and list all of the possibilities for each one. Enough background! My question is how do I determine the value of the first entry in the fld. Using a contains looks at the entire fld, I only want to know the first value? Thanks
Subject: creating a view with multiple entries in flds
You could use @Subset to get the first value in the list.
Subject: creating a view with multiple entries in flds
In the column you want to categorize use this:
@If(@Left(fieldName; “;”)=“Something”; “Nothing”; “”)