Skip to main content

Hallo,

 

If a dropdown field has only one value option, how can it be auto-selected during record creation?

 

below is the field

 

In SF, the Customer field is a lookup 

 

Thank you in advance

Hey ​@Jheng ,

To fill in the field value during creation of the record, you can make use of the 'default’ logic for that table.
https://docs.thinkwisesoftware.com/docs/sf/business_logic#default
 

Something like this:

if (select count(*) from customer) = 1
begin      
    set @customer_id = (select top 1 customer_id from customer);
end

Let me know if it helps.

Kind regards,

Dani

Hi Dani,

 

Thank you, manage to do the default logic

Reply


Terms & ConditionsCookie settings