Airtable起步指南(2) 表單/紀錄/欄位

table-record-field-diagram.png

Table 資料表:每個資料庫base裡面有一個或多個資料表tables
Record 紀錄:資料表中的一列就算是一筆紀錄(Record)
Field欄位:每一筆紀錄裡面有許多不同的欄位,紀錄各種相關資料

rename-table.gif
重新命名一個資料表Table
add-new-records-10fps.gif
+新增一筆紀錄,或者鍵盤按[shift]+[Enter]來新增一筆紀錄

欄位Fields

make-name-new-field.gif
新增欄位
customize-field-type.png
設定欄位類別

設定欄位類別

field-find.gif

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.

customize.png

Expanded Records 展開紀錄內容

expand-button.png

紀錄討論串

comments-history.png
可以在單一筆紀錄裡面,看到每筆資料編輯的時間/內容,也可以在裡面留言做紀錄或討論。
文章已創建 20

發佈回覆

你的電郵地址並不會被公開。 必要欄位標記為 *

相關文章

開始在上面輸入您的搜索詞,然後按回車進行搜索。按ESC取消。

返回頂部