Link to home
Start Free TrialLog in
Avatar of tashsmith
tashsmith

asked on

Keyword field selection scripts

hi,

I have two keywords fields, called 'publish' and 'delete'

each have three values, all can be selected..

so 'publish' could be 'test, review, live' one or all may be selected.

when a user wants to remove this doc from any of above they use 'delete'
again the values will be the same.

if they select say 'test' in the delete keyword list, I want it to be removed from the 'publish' list and added to the 'delete' list, again one or more may be selected.


Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

More info needed... I'll try to write down what I understand from your question.

Both fields are Editable, multi-value?
Can a user change both fields at the same time?

What do you want to do with the lists? In fact, what is it you intend to do at all? And what are you asking from us, assistance, some @Formula or LotusScript?
Avatar of tashsmith
tashsmith

ASKER

both fields are editable, multi-value.
the user can change either at any point.

 i want a script to prevent any value from appearing in both fields, do someone does not have say 'test' in both 'delete' and 'publish' field.

not sure the best wy to do this, whether an onsave command, says you can't have 'test' in both these fields, please change.
or have the selected value removed from the other field, should it be present.
What are valid combinations? Why don't you turn things around, I mean: make one field with all operations that are allowed. Can you call that field "Status" or so?

You are working towards a solution right now. May I suggest you describe (in business terms) the functionality that you want? Why are those two fields there?
Unfortunately we can't have one field with all combinations as the 'delete' part of this solution is an add on and it would be too complex for us to rewrite what we already have.

We are publishing documents to three different websites and now want to rewrite our current delete process to include a field where content managers can specify which sites they wish to remove this particular document from.

Any combination is valid, as long as a value does not appear in both fields...

so, it is ok for '
published' to be set to 'live'
and
'delete' to be set to 'test,review'

but not

published' to be set to 'live, test'
and
'delete' to be set to 'test,review'




So something like
     @If(publish<>"" & publish<>delete; @Success; @Failure("You need to select different options")

Put this in the Validation-property of one of the fields. It will just tell the user that two different values should be selected. If multiple values can be in both fields, I think things will work.
getting a missing right parenthesis ')' error
ok  got it to work, but added that to the input validation property  of the delete field, but nothing happened...
ASKER CERTIFIED SOLUTION
Avatar of Sjef Bosman
Sjef Bosman
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
perfect cheers