Get my Airtable course here:
nerdyurl.com/A...
View this on my website (free course):
nerdyurl.com/a...
Index
0:26 Video starts
1:00 Seth has all his clients in Airtable
1:52 Workspaces
2:09 You pay per collaborator per workspace
2:36 Audience question regarding storage space in a workspace
3:17 To create something new click on add base
4:01 Table has been added, table information
5:50 What do you want to track about your client
7:00 Cell option for phone number, will auto format
8:09 Field type for URL
8:30 Repetitive client adding
10:00 Don't leave blank rows
10:44 Create new empty table, employees and subs
11:21 Link employee to tasks
13:07 Row is called the view menu
13:24 Create different views
14:28 Click ellipses to duplicate the view
15:00 Example of why you don't leave empty field
16:08 Grid view easy to work on when just adding
16:16 Audience question
17:05 Seth jumping over to grid view, shows table for pricing plans for apps
19:08 Can add pricing formulas to determine if you save money on the apps or not
20:40 Seth adds a new table to the employee list, client fees and rev share
21:53 Linking to other records
23:40 once the table is configured you can easily look up, or link record
24:26 Writing formulas "concatenate"
26:24 Add monthly fee in client list
27:39 Look up monthly client fees and then add in revenue share and figure the difference
28:30 Established that the info to look up is numeric in nature it will let you format it
29:16 Do the revenue share, figure out how much you are sharing
29:49 Two way to do 29:16
31:16 Adding in the formula for revenue share after number inputted
32:33 Adding a pay type in the employee and subs view
34:33 Reassign employees
36:40 Group by employee, but first duplicate to always keep grid view
38:18 Add pay status as a look up into the view
39:28 Group by pay status then by employee
40:43 Double arrow allows you to expand a cell
42:15 Where the employee linked to the record
43:05 Revision history stays on file such as an audit trail
44:44 Example of how Seth directs payroll
45:55 Any views you have you can download a CSV so you have a record
47:00 Audience question about google sheets, can you add a google sheet
48:27 Seth could open a locked excel, sometimes not safe
50:00 You can also give view only access
51:30 Audience question about pricing
52:33 You can have access to a free Airtable but only invite people as read-only
so you don't get charged
55:00 Seth showing what he is building, course on eCommerce
57:40 Mapping the product to QBO and with Master SKU
58:45 Example Under Armour gear website
1:00:04 Sort by the sales channel SKU
1:01:37 Product grouping
1:02:25 Cannot do grouping in smart sheet
1:05:56 Do a filter by date
1:08:20 Mobile app on air table is good
1:10:29 Real Estate use case , have a block to show google view of each property
1:11:10 Real life use case app for property management, Seth working on it
1:11:40 First tab starts with design and integration notes
1:12:19 Build a form, based on columns, then review the form to adjust
1:13:07 Depending on column type, that's what will switch over to the table
1:14:00 As soon as someone fills out the form it will show up on the grid
1:15:50 How a client gets named
1:16:55 Field 18 created when the client filled out the form
1:17:28 Create a new form
1:19:19 Drag the field to the left to the available fields to remove it from the form
1:24:21 Share options on how to get the form Seth created
1:26:47 Seth going to Zapier , minute after client fills out form on
Airtable, Seth explains what occurs
1:31:20 Not much choices on layout for the forms
1:33:06 When you create a link to a table, it creates another back link to original table
1:35:48 Tenant Table , when you have a vacant property you add the word vacant and its
also linked to Vacant
1:40:00 Another thing Seth has learned
1:42:36 Maintenance request, adding in which property it was for, which vendor is needed
1:45:30 Open questions to audience
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.
Негізгі бет Track Anything For Your Business With Airtable
Пікірлер: 2