Using Form Field Types

asymmetricallyencryptedstring docid 1rvguxdd6glw0fmpandjtbinary docid 1rvguxdd6glw0fmpandjtboolean docid 1rvguxdd6glw0fmpandjtcurrency docid 1rvguxdd6glw0fmpandjtdate/time docid 1rvguxdd6glw0fmpandjtguid docid 1rvguxdd6glw0fmpandjtlink docid 1rvguxdd6glw0fmpandjtnumber docid 1rvguxdd6glw0fmpandjtpassword docid 1rvguxdd6glw0fmpandjtsymmetricallyencryptedstring docid 1rvguxdd6glw0fmpandjttext docid 1rvguxdd6glw0fmpandjt asymmetricallyencryptedstring when fields are stored in the database in encrypted view, use this field to maximize security for stored text in contrast with symmetrically encrypted text, this text cannot be restored without an externally stored private key uses an asymmetric algorithm for encryption in this use case, asymmetric means that there are two parts of key public and private the public key can be widely known and used for encryption, but for decryption, the private part of key must also be known stores only the public key, so that the data can only be decrypted by a user who knows the private key as well as the public key in the fields workspace, this is displayed as assymmetricallyencryptedstring due to decryption and performance issues, use this type only when necessary parameter description type binding public crypt key public half of an asymmetrical encryption key does not store the private half of the key binary stores large binary files such as images in the fields workspace, this is displayed as binary(max) or binary(a) where a is the value of the variable, max parameter parameter description binary length variable, max the maximum number of characters allowed to be stored in a field entry (maximum 2000 characters allowed) unlimited allows an unlimited number of characters or bytes to display full text properties type column only used when the value of the binary length field is set to unlimited use this for storing the document type for any document (such as an image) that is represented in binary format in the database it contains file extensions such as doc, jpg, pdf, and so on language the default language to use for full text indexes the set of languages to choose from is from microsoft sql server and therefore you cannot modify the values that are displayed here to change this field, under field attributes , ensure that full text indexed is checked and localized is unchecked select a new value from the dropdown list pick list validated field attributes full text indexed specifies that the field is full text indexed indexes unique words for fields that are marked as full text indexed and uses them in full text search and simple keyword search in the business object workspace we recommend setting only a limited number of fields to full text indexed setting too many fields can cause performance issues boolean the simplest type that allows you to store boolean values of true or false in the fields workspace, this is displayed as boolean parameter description pick list validated specifies that any pick lists that include this field are validated pick lists pick list name only displayed if you checked validated n/a only displayed if you checked validated n/a only displayed if you checked validated is state transition only displayed if you checked validated currency a compound value that consists of an amount and a currency code in the fields workspace, this is displayed as currency(a,b) where a is the value of the total number of digits parameter and b is the value of the precision parameter parameter description type binding total number of digits number of digits allowed in the data value precision the number of digits used after the decimal symbol in the data value zero shows only whole numbers pick list validated specifies that any pick lists that include this field are validated pick lists pick list name only displayed if you checked validated n/a only displayed if you checked validated n/a only displayed if you checked validated is state transition only displayed if you checked validated date/time stores date and time entries if you store a date and a time together, internally, the application stores them as utc but shows them to the user in the time zone associated with the user, with a few exceptions such as email and workflow most values consist of only a date and a time, but you can include a time zone, too use this field type to store the following date time time zone date and time time and a time zone date, time, and time zone but not a date and time zone include the time zone to store a specific time zone with a date and time for example, to schedule an event in the time zone in which the event occurs, such as 2pm in the eastern time zone, create a field with a time and a time zone the result is 2pm eastern time, instead of the corresponding time in the user's time zone if you include a time and a time zone, but no date, the application assumes that you are in the current half of the year, in relation to daylight savings time for example, to schedule a meeting every day at 2pm, use this combination the meeting stays at 2pm even after daylight savings time starts or ends in the fields workspace, this is displayed as one of the following date date only time time only date/time date and time only timeonlytimezone time and time zone only timezone date, time, and time zone parameter description type binding date includes the date in a datetime field time includes the time in a datetime field time zone automatically shows the time zone list pick list validated specifies that any pick lists that include this field are validated pick lists pick list name only displayed if you checked validated n/a only displayed if you checked validated n/a only displayed if you checked validated is state transition only displayed if you checked validated guid in the fields workspace, this is displayed as guid link allows you to link one business object to another in the fields workspace, this is displayed as link parameter description type binding relationship the relationship to use for this field you cannot set this field when you create the field you must set the value for this field after you create a relationship with this field create the field and save it then create a relationship using this field and save it then return to this page to update the field to change the value, select either not set or the name of the relationship the application displays the relationships that have this link field selected as a foreign key restrict to displays the name of the related business object when the relationship specifies a standalone business object or a member business object when the relationship specifies a group business object as the related business object, you can restrict the relationship to a specific group create the field and save it then create a relationship using this field and save it then return to this page to update the field to change the value, click the value and select a new value from the dropdown list binding the binding type for the relationship for this field the application automatically populates this field after you create a relationship with this field you cannot change this value component fields linked object id field the application automatically populates this field by appending " recid" to the field name you cannot change this value linked object type field the application automatically populates this field by appending " category" to the field name you cannot change this value number includes integers and real numbers you can specify the precision the maximum limit for the number of digits is 15 if you input more than 15 digits, the last extra digits are deleted automatically when you exit the number field in the fields workspace, this is displayed as one of the following number (a,b) , where a is the value of the total number of digits parameter and b is the value of the precision parameter integer , when the value of the precision parameter is 0, indicating that this is a whole number parameter description type binding total number of digits number of digits allowed in the data value precision the number of digits used after the decimal symbol in the data value if you enter zero, you get an integer pick list validated specifies that any pick lists that include this field are validated pick lists pick list name only displayed if you checked validated n/a only displayed if you checked validated n/a only displayed if you checked validated is state transition only displayed if you checked validated password used for passwords passwords themselves are not stored; the result of the hash function is stored instead when you enter a password, the application compares the returned value of the hash function to the stored value if they match, the password is correct for more information, see about setting the password policy docid\ vh4ffvwqfqq wzcp b3qj in the fields workspace, this is displayed as password(a) where a is the value of the maximum length parameter parameter description type binding maximum length character limit for a field entry store hashed password specifies if the hashed password should be stored symmetricallyencryptedstring stores text securely in contrast with the password field type, it can be restored symmetricallyencryptedstring fields are stored in the database in encrypted view for encryption, symmetric algorithm is used symmetric here means that for encryption and decryption the same key is used therefore, encrypted value can be easily decrypted when needed since symmetric keys are stored in database and can be retrieved by experienced users, this type should be used only in scenarios when "weak" data protection could be implemented in the fields workspace, this is displayed as symmetricallyencryptedstring parameter description type binding maximum length character limit for a field entry crypt key encryption key for a asymmetrically encrypted string encryption algorithm encryption algorithm used symmetrical encryption can use 0 (des), 1 (rc2), 2 (rijndael), 3 (tripledes) and aes algorithms when using the aes algorithm, the key iv value always differs for each encryption the maximum recommended length for the aes algorithm should be between 64 and 128 bytes asymmetrical encryption uses only the rsa algorithm text stores text strings this includes single and multiple rows strings up to 2000 characters length as well as huge amount of text, whose size could be up to several megabytes in the fields workspace, this is displayed as one of the following unicode text(a) , where a is either the value of the variable parameter or is max fixed text (a) , where a is the value of the fixed parameter byte text(a) , where a is the value of the variable parameter or is max fixed unicode text(a) , where a is the value of the fixed parameter html placing html (including javascript) into a text field and then binding it to an html control creates a security hole obviously, this is not good practice and we do not recommend this parameter description field type choose a type from the dropdown list text creates a plain text field unicode text allows the field to contain non english characters for a unicode text field that is marked as validated, only named validation lists with stored fields which are unicode text fields, are shown similarly, regular text fields can only by validated by named validation lists, with stored fields that are regular text fields as an example, assume there is a named validation list defined against the loginid field in the employee business object, that has been marked as unicode (for example, displayname of employee with loginid value by team ) for it to be used as the pick list for a validated text field, the field must also be marked as unicode, for the named validation list to show up also, the data type between the stored field in the named validation list, and a validated field, must match for example, if the named validation list is defined against a text field, but the user is attempting to use it for a number field, the validation does not work html enables html controls and allow users to enter html text html fields are limited to 2 gb see also note below text length variable creates a field of variable length enter the maximum number of characters permitted the default length is 32 the highest number allowed is 2000 fixed fixes the length of a field entry to a specified size the field value includes padding to the right the default length is 32 the highest number allowed is 2000 unlimited allows an unlimited number of characters or bytes to be displayed for this property the highest number allowed is 2 gb html fields should not exceed 200 mb full text properties type column not used language the default language to use for full text indexes the set of languages to choose from is from microsoft sql server and therefore you cannot modify the values that are displayed here to change this field, under field attributes , ensure that full text indexed is checked and localized is unchecked select a new value from the dropdown list pick list validated specifies that any pick lists that include this field are validated pick lists pick list name only displayed if you checked validated n/a only displayed if you checked validated n/a only displayed if you checked validated is state transition only displayed if you checked validated field attributes localized specifies that you can localize the values for this field full text indexed related topics creating forms docid\ jylkxqcbbnayk66grc2ty supported controls for responsive business object form docid\ jylkxqcbbnayk66grc2ty