Solved

Dropdown auto select

+1

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

Best answer by Dani

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

This topic has been closed for replies.

+2

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

+1

Hi Dani,

Thank you, manage to do the default logic

Sign up