?
Solved

Input Translation Question

Posted on 2008-10-06
3
Medium Priority
?
580 Views
Last Modified: 2013-12-18
I have 2 fields on a form:

Field 1  is called "Current"
Field 2 is called "Remove"

Both of these are multi value dialog lists

I need to create an input translation formula that will do the following:

If a value in "Remove" is not contained in "Current" then it will remove this value from "Remove"

I see that a listbox will do this automatically anyway, but I'd really like to keep this field as a dialog list.

I was thinking something along the lines of:

@if(!@ismember...
@replace...

but I can't get this to work.

Any ideas/suggestions greatly appreciated!
0
Comment
Question by:shuboarder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 1000 total points
ID: 22650401
If a value in "Remove" is not contained in "Current" then it will remove this value from "Remove"

superfluous:= @Trim(@Replace(Remove; Current; ""));
reduced:= @Trim(@Replace(Remove; superfluous; ""));

Field Remove:= reduced

Something along these lines...
0
 
LVL 21

Author Comment

by:shuboarder
ID: 22651251
Perfect!
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22651384
:-))
0

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month12 days, 5 hours left to enroll

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question