User manual
Table Of Contents
- Contents
- Welcome to Bento
- Overview of Bento
- Using Libraries
- Using the Address Book and iCal Libraries
- Using Collections
- Using Form View
- About Forms
- Viewing a Form and a Table at the Same Time
- Creating Records in Form View
- Editing Records in Form View
- Duplicating Records in Form View
- Deleting Records in Form View
- Creating Forms
- Deleting Forms
- Duplicating Forms
- Renaming Forms
- Adding Fields to a Form
- Tabbing Between Fields
- Moving Fields and Objects on Forms
- Resizing Fields and Objects
- Removing Fields from a Form
- Customizing Form Layouts
- Using Table View
- Using Fields
- Importing, Exporting, and Printing
- Backing Up and Restoring Information
- Using Bento with Bento for iPhone and iPod touch
- Keyboard Shortcuts
- Index
Chapter 8 Importing, Exporting, and Printing 93
Field Types Supported for Import
You can import into these field types: text, choice, checkbox, number, rating,
currency, time, date, duration, address, phone number, email address, URL, and IM
account.
You cannot import into these field types: file list, media, automatic counter,
calculation, related records list, or message list.
For this field type This data can be imported
text
choice
address
phone number
IM account
Any text
email address Any text, but a valid email address must include the @ character.
URL Any text, but the URL field does not support URL values that contain
Japanese characters.
checkbox “1” for checked; “0” for not checked
“True” for checked; “False” for not checked
“Yes” for checked; “No” for not checked
number
currency
Numeric data
rating A number between 0 and 10
time Numeric data in the form HH, HH:MM, or HH:MM:SS, optionally with
“AM” or “PM” where:
1 HH represents the hour (between 0 and 24, if you don’t use “AM” or
“PM”, or between 0 and 12 if you use “AM” or “PM”)
1 MM is minutes (between 0 and 59)
1 SS is seconds (between 0 and 59).
For example: 12:59:59 PM
date Numeric data in the form DD, MM/DD, or MM/DD/YYYY, where:
1 DD is the day (between 1 and 31, as valid for the month)
1 MM is the month (between 1 and 12)
1 YYYY is the year (between 1 and 9999).
A date field can also contain a “time” value, as described for the time
field.
Note: These formats vary depending on the current system date settings.
duration Text representing a duration in weeks, days, hours, minutes, and seconds.
The text may use the following abbreviations:
1 w for weeks
1 d for days
1 h for hours
1 m for minutes
1 s for seconds
For example, the following are all valid duration text:
1 8 days, 5 hours
1 8d,5h
1 8d5h