Base Design
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

Create a table showing subtotals from another table

Hi all,I am having a little trouble. I have a base where all my transactions are summarised in a grid view as below.That works like a dream. Now I need to do two calculation, First I need to minus the subtotal Cost of Goods from the Income. I know I ...


Resolved! How assign a number to a single selection value

Hello everyone,I am new to airtable. I have a survey and each question has a single select field option for the answers with a certain amount of points. How can I assign a number to each single select field value e.g. a=0, b=1, c=2 and d=3 so I can a...

Jerrel by 4 - Data Explorer
  • 8 replies
  • 0 kudos

Sorting and filtering with feet and inches

Hey,I have a base where I am storing the height of people, I would like to store the height in feet and inches.I also need to sort and filter by this field as well.I found 4 options that I can do:- I can store it as a string, but then I cant really s...

efreiner by 4 - Data Explorer
  • 1 replies
  • 0 kudos

Show remaining values from linked table

I have a table listing persons linked to another table showing tasks. I'm trying to show the remaining tasks a person needs to do.Example: These two tables are linkedTable 1: a list of 100 peopleTable 2: a list of 34 tasks to be done by each personEa...

G_T by 5 - Automation Enthusiast
  • 3 replies
  • 0 kudos

Resolved! Multiple product quantities moving inventory to multiple locations

Hello! I've got an inventory board ("Print Products") that has hundreds of products (each with variable quantities). I add new amounts of each product regularly (in "Order Received" and "Products Received" for individual line items). When I sell item...

cadyellow by 5 - Automation Enthusiast
  • 13 replies
  • 8 kudos

Resolved! how to auto assign tasks according to a single select field

Hi Airtable Community,  is there a way to auto assign tasks according to a single select field. I have a single select with multible Teams (CRM, Website, Social Media etc.). I want a new record to be auto assigned to the team lead of the team from th...

mirkolando by 6 - Interface Innovator
  • 1 replies
  • 1 kudos