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

Forum Posts

Lookup contact info from another table

Hi there - I keep getting hung up on lookups and links and it's driving me bananas so it's time to phone a friend! To generalize, I have a "Counterparty" table that lists all of the counterparties our organization has a contract with that includes th...

AndreaR by 5 - Automation Enthusiast
  • 116 Views
  • 3 replies
  • 0 kudos

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 ...

Mark_Jamieson_0-1719458753714.png

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
Solved
  • 3386 Views
  • 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
  • 178 Views
  • 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
  • 261 Views
  • 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
Solved
  • 1194 Views
  • 13 replies
  • 8 kudos