Autofill Field based on other field value

[william34]

Hi,

I been working on create Lead form.
How can I make 'website' field auto detect and filled from email field.

Like if email is input as test@example.com
then website should be auto set to example.com

[rabii]

you can use formula to do it, this formula below it does it for an account (i have added a condition if the record if new and there is no website OR if the email address has changed) you can changes these conditions as you want

ifThen(entity\isNew() && !website || entity\isAttributeChanged('emailAddress'),

    $email = emailAddress; // Assign the emailAddress to a variable for readibility (optional)
    $parts = string\split($email, "@"); // Split the email address into parts

    ifThen(array\length($parts) > 1, website = array\at($parts, 1))
)​ 

I hope this helps

[william34]

Hi rabii,

Is there other way? I have set Duplicate check based on Country and Domain now.
Duplicate check seems to fails. When Domain is fetch from email with formula.

[rabii]

what do you mean by (Duplicate check seems to fails. When Domain is fetch from email with formula.) ? as i understand you have now a duplicate check that checks both country and domain (i assume if the country or domain already exist on another record then the duplicate check modal would show up).

so what is the issue when using the formula ?

[rabii]

what do you mean ? duplicate validation ? do you mean duplicate check ?

[william34]

yes Duplicate Check