Table 資料表:每個資料庫base裡面有一個或多個資料表tables
Record 紀錄:資料表中的一列就算是一筆紀錄(Record)
Field欄位:每一筆紀錄裡面有許多不同的欄位,紀錄各種相關資料
欄位Fields
設定欄位類別
Airtable尚有提供幾種欄位類別,下面先列出一些基本的類別(後面在介紹進階類別)
- Single line text: 簡單純文字
best for short, unique pieces of text (like the names of musical artists). If you have a single line text field and you find yourself typing in the same values over and over again, consider converting your single line text field into a single select or multiple select field. - Long text: 文字段落
great for when you need a place to store freeform notes or otherwise add multiple lines of text. A long-text field automatically expands, giving you more room to work, and you can even @mention a collaborator inside the text to send them a notification. - Attachment: 附加檔案
allows you to attach files to records and preview or download them later. Upload files from your computer, from a URL, from a web search, or from a cloud service like Google Drive or Dropbox. - Checkbox: 勾選 可打勾的框框
when you need to represent information in a binary true/false format, use a checkbox field. With the checkbox field, you can click on the cell to check or uncheck it. By default, a checkbox field will appear with a green check mark, but if you’re on a workspace with a Pro plan, you can customize the shape and color of the checkbox symbol. - Single select: 單選
ideal for when you want to choose only one option from a set of options that you have predefined. You’ll see a dropdown list of these options when you edit the cell. Workspaces on the free and Plus plans offer 7 colors for select tokens; if you’re looking for even more colors, Pro plan workspaces offer 40 different colors for select tokens. - Multiple select: 多選
like a single select field, a multiple select field works well in situations where you want to select options from a predefined list of potential options; however, unlike a single select field, you can choose as many of the options as applicable. Each select option can be removed by clicking the X. Workspaces on the free and Plus plans offer 7 colors for select tokens; if you’re looking for even more colors, Pro plan workspaces offer 40 different colors for select tokens. - Date: 日期 (可加上時間)
lets you enter a date and (optionally) a time. When editing a date, you will be presented with a calendar widget that makes it easy to select a specific date. From the field customization menu, you can choose which date format you want to display and whether or not you want to provide a timestamp. - URL: 網址
formats the text within it as a URL. Clicking on a URL within a URL field will open up that page. - Rating: 評分 1-10分
rate your records on a numeric scale for the purposes of ranking or quality assessment. From the field customization menu, you can set the maximum rating allowed (from 1-10) and—if your workspace is on a Pro plan—change the style and color of the field’s rating symbol from the default yellow star. - Number: 數字
only accepts number values. You can customize whether you want numbers to display as integers or with decimals, the number of significant digits, and whether or not negative numbers are allowed. - Currency: 貨幣
formats numbers as currency. You can customize which currency symbol the field will use, the precision, and whether or not negative numbers are allowed.
Expanded Records 展開紀錄內容
紀錄討論串