asked on

More than one default Value

I have a field that is populated from a dblookup

@DbColumn("": "NoCache"; ""; "(HiddenInternNotifyList)"; 2)

The field is a dialog box that displays user emails. Do when I select the dialog box I will see

JoeBlow@something.com
Chuck@something.com
Rose@something.com
BobbySock@something.com

My question is there a way to assign default values to the dialog box. When I create a document I want the field to already be assigned to JoeBlow and Rose, if I want to remove them or add others I can do so?

Thanks

SysExpert

I would make it a multiline text field and put your default names.

Then have a button that does an address lookup, and whatever chosen is added to your default list.

I hope this helps !

Zvonko

Yes, it is possible.

In your DialogList you use the upper @formula for choices.

If you like to have DefaultValue, then put this @formula as Field's DefaultValue:

InternNotifyList:=@DbColumn("": "NoCache"; ""; "(HiddenInternNotifyList)"; 2);
@If(@Elements(InternNotifyList)<3;@Return("");
@Subset(InternNotifyList;1):@Subset(InternNotifyList;3))

Zvonko

Sorry, take this for DefaultValue:

InternNotifyList:=@DbColumn("": "NoCache"; ""; "(HiddenInternNotifyList)"; 2);

@If(@Elements(InternNotifyList)<3;"";@Subset(InternNotifyList;1):@Subset(@Subset(InternNotifyList;3);-1))

Good luck,
Zvonko

ASKER CERTIFIED SOLUTION

HemanthaKumar

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jaziar

ASKER

I did not think appending would have work - but I guess it does thanks