Here are the Valid HTML Tags for the Rich Text fields. Hyperlink or Picture | Excel '=HYPERLINK' formula or Linked Text. `Surname, Given #111 #`) Importing a single user does not need the ID (i.e. ![]() Yes/No (check box) | 1/0, Yes/No, or TRUE/FALSE. Lookup | Additional fields are READ-ONLY. `` or `` (M/D/YYYY) must be delimited by either '-' or '/'). Multi-line, rich text | Does not import or export well from/to Excel.Ĭurrency | Numeric only symbols ignored.ĭate and Time | ISO-8601 or per Column Settings (e.g. Multi-line, plain | Any Unicode string multiple lines can be wonky. Single line of text | Any Unicode string. Must be formatted as follows: -COLUMN- | -FORMAT / COMMENT. Certain column types are not able to be imported in this way, such as the Multi-line Enhanced Text. The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |