• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 283
  • Last Modified:

Problem @Unique and @Trim in a view based on a field value of a form

Hi, here's my problem...

Got a form...  2 different kind of fields:

1- Editable Dialog list (multiple values) containing the names of some people: "Some Body/something/something"
2- Editable Dialog list (single value) containing the status of a task: "Assigned", "Completed"...

Also got a view... The first column is Multi-value (semi-colon separator) with this formula:

@Unique(@Trim(@Name([CN];PeopleOne):@Name([CN];PeopleTwo)))

Second colum of the view lists the different tasks assigned to these people.  There may be more than 1 task per person.

Here's what I want to do...  If the value of the STATUS field is "Completed", I don't want the task to be listed in the view, under the person's name (twistie)...  I only want the "Assigned" tasks to be shown under each people's row in the view...

Is it any possible??
0
barbotte
Asked:
barbotte
1 Solution
 
p_parthaCommented:
In the view selection formula , add something like :

select form = <formname> & status !="Completed"

replace <formname> with your formname
0
 
barbotteAuthor Commented:
Perfect !  Thank you...
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now