Defaulti ng values for field with lookup table

[Former Member]

Hi Folks,

Suppose there is a field - say - countries which is looking up into the Country' table . Is it possible to default a particular value - say 'USA' during the creation of the record.

Using a boolean field its possible to default a particular value - but how do you do it for a field with a lookup table.

Regards,

Vinay

Edited by: Vinay on May 28, 2008 10:33 AM

[Former Member · Accepted solution]

Vello Vinay,

One of the ways to do this is to create an assignment which places the value in the field. you can run a workflow on add or update which runs the assignment and populates the filed. you can of course also add a condition to verify whether there is already a value in the field so you dont override the User.

[Former Member · Accepted solution]

Thanks Stanley,

Assignments get executed only after record save - the user wants to see the value before the record save !!

Regards,

Vinay

[former_member201266 · Accepted solution]

Hi Vinay,

I dont think so its possible to have a default value to any field(Lookup/Normal). The only case you can get an default value is when its a calculate field or a kind of stamp or auto id.. but in this case you wont be able to change there value...,

Cheers,

Cherry.

[Former Member · Accepted solution]

Hi

I agree with Cherry.

field value cannot be populated before saving using assignment.

can suggest some workaround.suppose requirement is not to save any record before getting approved.Have a staging repository with same data model.Save the data there first(via Portal or directly in data mgr) and create import maps and use auto import to bring records in main repository.

Hope this helps

regards-

Ravi