Dropdown auto select

Question

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

Dani · Accepted Answer

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#defaultSomething like this:if (select count(*) from customer) = 1begin          set @customer_id = (select top 1 customer_id from customer);endLet me know if it helps.Kind regards,Dani

Jheng · Answer

Hi Dani,Thank you, manage to do the default logic

Sign up

Login to the Thinkwise Software Community

Scanning file for viruses.

This file cannot be downloaded