Скачать или смотреть Use Airtable to Track Inventory

Get Nerd's Guide to Airtable here:
https://www.nerdenterprises.com/nerds...

Index

04:11 How to become a content creation machine?

10:25 Airtable screen sharing begins with log displayed

11:10 How is Airtable described?

13:39 Airtable columns, already created by Seth

14:44 Don't add customers and projects in the same table

15:50 Building out the table

20:35 Expanding a record for a linear view

22:17 Ability to duplicate the view

22:43 Create a form in Airtable

24:25 When linking a field one table to another

26:10 What is a data base?

27:19 Reordering fields and drag columns

29:15 Creating asset types

30:00 Adding in a serial number for uniqueness of the product

31:04 Adding in the asset type

32:00 Adding in Number of Quantity owned

33:57 Creating the transaction register of what goes in and out

37:25 VLOOKUP setting in use with 33:57

40:00 Shortcut for a state list drop down

42:35 Using "Roll Up" setting for quantity out Airtable tracks it perfectly

48:28 Grouping by asset type and bird eye view

50:00 Do the project and have the project look up the customer by the project

53:00 Create a report that shows low inventory

54:50 Grouping by serial number in the assets column to view a sample issue from 53:00

56:45 Stamp the date created

1:01:00 Affiliate link for Airtable

1:01:21 Sharing capabilities of Airtable

1:05:45 Attaching images similar to linking links using Zapier to help in Airtable


This content is for information purposes only and should not be considered legal, accounting or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Nerd Enterprises, Inc. does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Nerd Enterprises, Inc. does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.