If writer = seth than pay .10 per word, If writer = Jamie than pay .15 per word

[Thomas_Walker]

What it says on the tin.

Different authors make different amounts, I’d love to add this kind of conditional logic based on what we’re entering in the “numbers” field, and have those prices automatically calculated in the sheet.

Ideally, I would also be able to hide the formula and have it entered in the currency field so I can later filter by author later and have it automatically populate the total at the bottom of the table, but I won’t get picky.

[Jeremy_Oglesby]

Have a look here:

How to look up a payrate? Ask the community

Unfortunately, @William_B, you’re going to have to set your “Payrates” table up horizontally instead of vertically. Think of each Record (row) in the “Payrates” table as a “Pay Schedule”. Initially, you only need one, your current pay schedule/rates. You’ll need to create a Field (column) for each “Tier” that could be matched against, and it’s percentage value as the Value for that “Pay Schedule”. The advantage of this is that you can change your pay structure in the future by adding a new “Pay…

You’ll want to follow this same general pattern of having a “Pay Schedule” table, just modified a bit to match your schema of “Writers” rather than “Sales Associates”.

[Thomas_Walker]

Thank you so much @Jeremy_Oglesby!

I think I’m more confused than before though :grimacing:

[Jeremy_Oglesby]

Unfortunately I’m a bit too tied up w/ work at the moment to dive into an explanation.

In the spirit of Airtable’s DIY mission, here are some concepts to read about that are important for building a solid database in Airtable, and in particular to meet your use-case:

Airtable - Support

Airtable's guide to many-to-many relationships

What sets Airtable apart from ordinary spreadsheet applications is its ability to link related concepts together. Knowing how to represent the relationships between different groups of objects can ...

Airtable - Support

Lookup field overview

  A lookup field allows you to look up a specific field in a linked record. For example, if you have an Orders table with a field linking to Clients, you could create a lookup field that displays t...

Airtable - Support

Conditional counts, lookups, and rollups

Lookup, rollup, and count fields in a table use linked record fields to pull in values from one table to another. By default, these fields will pull in all the linked records from the other table, ...

:point_up:t2: – those are pretty targeted at key concepts. Here are a couple full-scale guides that might be helpful in just wrapping your head around what’s possible with Airtable when your base is designed well:

you might want to just breeze through this beginner’s guide

Airtable - Support

Getting started: starting with the base-ics

Welcome to Airtable! Whether you're opening your own restaurant, designing a clothing line, wrangling cattle, or managing a record label, Airtable helps you create anything you can imagine to do th...

and then move on to this more advanced one

Airtable - Support

The Airtable power user's guide

  Welcome to the Airtable power user's guide! Airtable is friendly enough that anyone can dive right in with one of our templates or Airtable Universe bases—but it's also a complex tool with many ...