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

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
0
Jaziar
Asked:
Jaziar
1 Solution
 
SysExpertCommented:
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 !
0
 
ZvonkoSystems architectCommented:
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))

0
 
ZvonkoSystems architectCommented:
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



0
 
HemanthaKumarCommented:
In the default value, Just input this

"JoeBlow@something.com" : "Rose@something.com"

~Hemanth
0
 
JaziarAuthor Commented:
I did not think appending would have work - but I guess it does thanks
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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