This function will put a formatted random character string (a..z, 0..9) in the field specified. You may use a mask parameter to include text data. The mask parameter may contain <#field tags that will be resolved appropriately before the random number is generated.
For example, to randomly generate a password in the ClientPW field in the wce_contact table for contacts that have "Lead" in the ID/Status field, using a format of last name plus 4 random numbers - you would use the following:
alpharandom table=wce_contact field=clientpw mask="<#field field=lastname>####" digits=4 limits="idstatus = 'lead'"
which would produce results like:
Huffmanazav
Mooreppvd
Nixusi7
|