CreateRecord

You use the CreateRecord keyword to create a new record by entering values into one or more fields in a list or form applet. The keyword fails in list applets if the sequence Id is automatically generated when a user tries to create a new record.

Signature

The CreateRecord keyword supports the following signature:

CreateRecord(AppletRN|Button(RN)|[RowNum],FieldRN(1..N)|Value(1...N) OR 
Variable,RN of Save record in AppletMenu)

Note the following about the CreateRecord keyword signature:

• The row number is optional.

• The keyword supports:

  • Unique values by adding the '$' symbol at the end of the text.

  • Date format like Today,Today+1,Today-1.

  • Variables like @var1, @var2 and numbers.

Desktop Examples

The following table describes how to use the CreateRecord keyword to create a new record in list and form applets in desktop applications.

Target Object	Inputs	Closing Action	Comments
Contact List Applet|NewRecord	Last Name|last,First Name|first	WriteRecord(SWE)	Creates a record in the list applet.
SIS Account List Applet|NewRecord	Name|D$,Account Status|Red Customer	WriteRecord(SWE)	Creates a record in the list applet.
Contact Form Applet|NewRecord	LastName|@var1,FirstName|first	WriteRecord(SWE)	Creates a record in the form applet.
Contact List Applet|NewRecord|3	Last Name|@Variable	WriteRecord(SWE)	Creates a record in the third row in the list applet.

Mobile Examples

The following table describes how to use the CreateRecord keyword to create a new record in list and form applets in mobile applications (on mobile devices).

Target Object	Inputs	Closing Action	Comments
SHCE Sales Opportunity Form Applet - Mobile|New	Name|John$,Currency|USD,CloseDate|11|12|12	WriteRecord	Creates a record in the form applet.
CG Account List Applet - Mobile|New	Name|abc	WriteRecord	Creates a record in the list applet.
CG Account List Applet - Mobile|New|4	Name|abc	WriteRecord	Creates a record in the fourth row in the list applet.